Not getting Current Transection id from oracle instance.

0.00/5 (No votes)

See more:

hi all,
i am not able to get cuurent transection id from bellow code. can u please help me for this.
session.BeginTransaction();
string transactionId = DBHelper.GetCurrentTransactionId(session);

i want this to log sone event From code to DB.
i have also tried like....

session.BeginTransaction(System.Data.IsolationLevel.Serializable);
string transactionId = DBHelper.GetCurrentTransactionId(session);

this gives me id but when i try to execute Stored procedure it was given me exception.
plz help me.

thanks
Supriya

Posted 26-Dec-13 1:46am

supriya29

Add a Solution

Comments

ZurdoDev 26-Dec-13 7:59am

You're calling your own custom code. We have no idea what DBHelper is doing and why it may not be working.

ZurdoDev 26-Dec-13 7:59am

Just step through the code and debug it.

supriya29 26-Dec-13 8:04am

DBhelper is nothing but we have call all sql or SP from that. and that SQL containce only this
SELECT dbms_transaction.local_transaction_id FROM dual

and one out parameter which containc ID

CHill60 1-Jan-14 19:42pm

What exception is thrown? Do you get any errors when you run the SP directly (in an Oracle IDE rather than via the C# DBhelper class)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Last 24hrs

This month

Pete O'Hanlon	115
OriginalGriff	85
Dave Kreskowiak	75
Andre Oosthuizen	45
Graeme_Grant	35

Pete O'Hanlon	1,790
OriginalGriff	1,315
Graeme_Grant	810
Richard Deeming	743
Dave Kreskowiak	634

Not getting Current Transection id from oracle instance.

Add your solution here

Preview 0

Not getting Current Transection id from oracle instance.

Add your solution here

Preview 0

Existing Members

...or Join us