Integration

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!

Using DB links in Stored proc call in DB adapter 11G SOA

user626262May 31 2010 — edited Jan 27 2011

Hi
We are using Oracle 11G SOA Suite and have created a DB adapter which has a call to stored procedure . The stored proc has sql queries to access remote DB using db links. The DB link has been created in our local database pointing to another schema where the tables are residing.
When executing this we get the following error

ORA-24777: use of non-migratable database link not allowed

Can anybody provide solution to this ?

Thanks

This post has been answered by Anuj Dwivedi-Oracle on Jun 2 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 24 2011

Added on May 31 2010

#applications-integration-using-oracle-fusion-middleware, #soa-process-management

4 comments

2,849 views