Does someone know how to resolve this ? I am using XA driver using
Oracle 9i 9.2.0.6/WebSphere MQ Version 5.2 in IBM WebSphere version
5.1.1.4. This problem shows up when I make a query to a different
database instance connected via dblink.
java.sql.SQLException: ORA-24777: use of non-migratable database link
not allowed
ORA-06512: at "XYZUSER.PKG_XYZ_QUERIES", line 528
ORA-06512: at line 1
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1957)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1114)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2181)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2063)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2922)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:644)
at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:722)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:400)
...
...
...
at
com.ibm.CORBA.iiop.ServerDelegate.dispatchInvokeHandler(ServerDelegate.java:608)
at com.ibm.CORBA.iiop.ServerDelegate.dispatch(ServerDelegate.java:461)
at com.ibm.rmi.iiop.ORB.process(ORB.java:432)
at com.ibm.CORBA.iiop.ORB.process(ORB.java:1728)
at com.ibm.rmi.iiop.Connection.doWork(Connection.java:2227)
at com.ibm.rmi.iiop.WorkUnitImpl.doWork(WorkUnitImpl.java:65)
at com.ibm.ejs.oa.pool.PooledThread.run(ThreadPool.java:95)
Received on Tue Jun 13 2006 - 14:42:20 CDT
