Integration

Hi,

While executing a simple query/oracle procedure comprising of a database link, I am getting an error "Invalid Namespace Value".

Say I have a database A from which there is a link named IDMLINK to a database B. Now through a database adapter created in SOA Suite, if I am trying to execute the following query, the following error is getting thrown.

select distinct(owner) from all_tables@IDMLNK;

ORA-28267 - Invalid Namespace Value
Ora-02063 - Preceding name from IDMLink

For further reference I am using a non-xa driver(instance connections) with emulate two-phase commit turned on.

When I am using an XA driver, the error is different as below:

**Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'DBADP' failed due to: Pure SQL Exception.**
**Pure SQL Execute of select distinct(owner) from all_tables@IDMLNK failed.**
**Caused by java.sql.SQLException: ORA-24777: use of non-migratable database link not allowed**


Thanks In Advance,
Arnab