Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-24777: use of non-migratable database link not allowed

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

From: pash <ajnd05_at_gmail.com>
Date: 13 Jun 2006 12:42:20 -0700
Message-ID: <1150227740.674789.15390@c74g2000cwc.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US