Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calling stored procedure to insert values in one DB from another DB

JSMQFeb 9 2018 — edited Feb 23 2018

Dear All - We have a requirement to retrieve values from an oracle database (replicated production server version 11.2) to another oracle target database for a reporting purpose.Since the source database is a replicated server it's only read only mode and have restrictions in using DB links(which discussed on another forum).

We have stored procedures to fetch and insert the values into target database and we can make use of callable statement from a JDBC program to invoke and execute the stored procedure .

Since source and target tables are in different database,how do we connect these two databases? Can we link it through stored procedure(as copied insert statement below) or else do we need any middle ware here?

INSERT INTO [LINKEDSERVER\INSTANCE].remoteDATABASE.remoteSCHEMA.remoteTABLE SELECT * FROM localTABLE

Appreciate your help in advance!

Thanks,

Sen

This post has been answered by Mark D Powell on Feb 12 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 12 2018

Added on Feb 9 2018

#general-database-discussions

12 comments

2,298 views