I need to insert data from my Oracle 11G to my Oracle 10G. I have no support for my Oracle 10G.
In the past, I was able to do this between two Oracle 10G using the following :
- One DBLink on the server APEX1 that point to the server PROD1 (DLPROD1).
- One DBLink on the server PROD1 that point to the server APEX1 (DLAPEX1).
- One procedure commande_directe on the server PROD1.
Code of the procedure commande_directe :
CREATE OR REPLACE
procedure commande_directe ( chaine IN varchar2 )
execute immediate chaine;
Now, the server APEX1 as been upgrade to Oracle Database 11g Release 220.127.116.11.0 - 64bit and my server PROD1 is in Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 (I can't upgrade this server because the contract support wasn't renew and because the product that use the database isn't certified on 11G).
Since this upgrade, we can't insert data from APEX1 to PROD1. We get this error message :
execute sic_commande_directe@DLPROD1 ('insert into olivier (column1) (select dossier from sic_al@DLAPEX2)')
Rapport d'erreur :
ORA-04052: erreurs lors de la consultation de l'objet distant S9881_GL_00.SIC_COMMANDE_DIRECTE@DLPROD1
ORA-00604: une erreur s'est produite au niveau SQL récursif 1
ORA-06544: PL/SQL: internal error, arguments: , , , , , , , 
ORA-06553: PLS-801: internal error 
ORA-02063: précédant 2 lines de DLPROD1
Do you know how solve this issue ? (remember that the support of our Oracle Database 10G wasn't renew, but I have support for my Oracle Database 11G).
This forum is commonly handling connections using a gateway connecting to foreign databases - you'd better get your issue addressed in the PL/SQl forum.
Now to the error you reported: ORA-06544: PL/SQL: internal error, arguments: , , , , , , , 
It happens when you use a 11g client calling 10g PL/SQL and is a defect in the 10.2.0.1 release which was fixed starting with 10.2.0.2 - see also Note: Bug 4511371 - ORA-6544 / ORA-4052 using PLSQL between 10g and 11g (Doc ID 4511371.8) available on My Oracle Support.
As suggested in the note, please apply the latest patch setto the Oracle 10g installation - the latest patch set is 10.2.0.5.
Thanks for your answer.
I'm sorry if I have open this in the wrong part of the forum.
I know that this is a bug. The real problem is that my society hasn't renew the contract support for this installation (I have support for the 11g installation).
Do you know if it is possible to do this by another way (Insert some data on a 10G database from a 11G database) ?
Yes you can directly upgrade from 10.2.0.1 to 10.2.0.5. The patch number is in this MOS Doc
10.2.0.5 Patch Set - Availability and Known Issues [ID 1087991.1]
Follow the directions in the README of the patch.