We are writing software using embedded PL/SQL to perform database
To connect, we do:-
EXEC SQL CONNECT :username IDENTIFIED BY :password USING :db, where username
and password are always the same, but db varies. So within a single
application, the connect statement may be executed say 3 times with 3
different db values. Additionally, the db values are the names in the
tnsnames.ora file and all point to the same service although this won't
always be the case.
Then, to disconnect, we do:-
EXEC SQL ROLLBACK WORK RELEASE
which seems to disconnect everything. What we want to be able to do is to
selectively disconnect from a specific db, whilst leaving the other
If anyone can suggest a possible solution, we'd be most grateful.