| OCI Equivalent of EXEC SQL ROLLBACK RELEASE [message #428366] |
Wed, 28 October 2009 02:20  |
macexplorer
Messages: 1
Registered: October 2009
|
Junior Member |
|
|
Hi,
This is my first post to orafaq. Hope I do this right, especially as I am no expert on Oracle concepts.
Also please do excuse the length.
In brief,
Is there an equivalent of the pro*c statement,
EXEC SQL ROLLBACK WORK RELEASE
in OCI?
Also what is the effect of this statement when the DB Server is suddenly offline? How does calling this help, like does this affect the oracle client/TNS etc.,?
I am having a problem with Oracle 11gR2 when the DB is present in a separate DB server machine and is undergoing shutdown and restart.
We have a set of existing applications developed using Pro*C and my application using Roguewave DB Api(which in turn uses OCI).
On losing connection from DB, existing apps(on error), invoke the
EXEC SQL ROLLBACK WORK RELEASE
embedded sql statement.
My application does not do anything special(maybe just a rollback) and reconnection. However on reconnection(after db is back online) I seems to get some dummy connection.
Using this to do a serious query, results in error and application again goes back to reconnect. This continues repeatedly. DB teams comment is that since logoff(equi of rolback release) is not happening, this problem results.
While existing apps(Pro*C) seems to work fine.
Any thoughts and comments will be really helpful.
Thanks in advance..
mac
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
