Skip to Content
0
Former Member
Apr 06, 2015 at 10:48 PM

INSERT with CONNECTION to an external Database.

16 Views

Hi All,

I have to INSERT an internal table values to an external Oracle Database. The Solution I saw in Forums are with CONNECTION Addition in INSERT option with DBCON.

insert TABLE_NAME@SCHEMA CONNECTION 'PAYPROD'

from table gt_summary.


I am getting syntax error that "TABLE_NAME@SCHEMA", is unknown. It does not exist.


Can anyone help me an example with CONNECTION option in INSERT.


Regards,

Asha