This discussion is archived
5 Replies Latest reply: Nov 26, 2012 4:04 PM by Srini Chavali-Oracle RSS

Insert data from Oracle Database 11G into 10G

683199 Newbie
Currently Being Moderated
Hi,

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 )
     IS

     begin

          execute immediate chaine;

     end;
------

Now, the server APEX1 as been upgrade to Oracle Database 11g Release 11.2.0.1.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: [55916], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [55916]
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).

Regards,

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points