dbms_transaction statement

josir · Post by **josir** » Tue 17 Oct 2006 22:48

Hi folks,

working on the ORA Monitor, I verify that several times, ODAC generates

begin :result := sys.dbms_transaction.local_transaction_id(true); end;

why ODAC generates this SQL ?
Is there a way to not use it ?

Thanks in advance,
Josir Gomes

Challenger · Post by **Challenger** » Fri 20 Oct 2006 08:25

ODAC executes this sql statement to start new transaction or determine that transaction is active.

josir · Post by **josir** » Mon 23 Oct 2006 22:02

Is there a way not to execute it or to change the SQL command ?
Thanks in advance,
Josir.

Challenger · Post by **Challenger** » Wed 25 Oct 2006 13:51

You can't change this SQL command. Don't call StartTransaction method or ApplyUpdates method to avoid it. Please explain if it is possible the reasons why do you want to avoid execution of this SQL command.

josir · Post by **josir** » Thu 26 Oct 2006 21:04

Hi challenger,

I've already have a call to self-made procedure that start the transaction and do other processing.

If I can override this command, I could call my procedure instead of dbms_transaction.

I will try to stop calling StartTransaction. But avoiding ApplyUpdates is problematic... I will do some tests before continue the thread.

Thank you.
Josir

Devart Forums

dbms_transaction statement

dbms_transaction statement

change/not execute dbms_transaction

Overriding dbms_transaction statement