pash wrote:
> 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...
Error: ORA-24777
Text: use of non-migratable database link not allowed
---------------------------------------------------------------------------
Cause: The transaction, which needs to be migratable between sessions,
tried
to access a remote database from a non-multi threaded server process.
Action: Perform the work in the local database or open a connection to the
remote database from the client. If multi threaded server option is
installed, connect to the Oracle instance through the dispatcher.
Received on Wed Jun 14 2006 - 04:42:25 CDT
