+ Reply to Thread
Results 1 to 4 of 4

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

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

    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)


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

    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.



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

    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.



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

    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.



+ Reply to Thread