Using DB links in Stored proc call in DB adapter 11G SOA
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