I am using Oracle, MTS, VB.
Oracle has something called V$Session. It provides a mechanism to
store connection specific data.
This is neat because then and stroed procedures / triggers can
access this information and incorporate it in whatever they do.
You set Data in V$Session by some Stored Procedures layed on by Oracle.
Here is my question:
I want to set data in V$Session Data at the beginning of a Transaction
and Reset it at the end if the Transaction.
Is there any way that I be guaranteed that all ADO connections used
within a transaction will use the same connection?
If this is not possible, is there a way that I can hook in to do pre /
post processing with all connections that are dispensed?
Thanks
--
Jack Stephenson
Sr Systems Analyst
EDS Canada
Sent via Deja.com http://www.*-*-*.com/
Before you buy.