Home » Developer & Programmer » Precompilers, OCI & OCCI » how to write applications using XA???
how to write applications using XA??? [message #222552] Mon, 05 March 2007 07:03
Messages: 2
Registered: March 2007
Junior Member

I am writing an application which uses transaction management to connect to Oracle(no explicit connect calls... xa_open is called to connect)

The problem i am facing is :
the XA trace shows that the application has logged on to Oracle and calls like xa_open and xa_begin are successful.
but when it comes to embedded SQL calls ..EXEC SQL DECLARE CURSOR... and then Open cursor, the application fails at the point of 'open cursor' giving the error 'ORA_1012 - not logged on'(in application trace)

After this point, as per the application logic, xa_rollback is called and it is successful.

I am using Pro*C 8.0.6 against Oracle 8.1.7 server. platform: unix MPRAS.

is there anything i am missing such as libraries( i am including static library -lclient and also xaonsl.o), environment setting, any calls to get the context from Oracle to the application??

plz help!!!

Previous Topic: How can you disable "error" tracing?
Next Topic: Dynamic Sql with cursor?
Goto Forum:

Current Time: Tue Aug 16 02:21:56 CDT 2022