Page 1 of 1
dbms_transaction statement
Posted: Tue 17 Oct 2006 22:48
by josir
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
Posted: Fri 20 Oct 2006 08:25
by Challenger
ODAC executes this sql statement to start new transaction or determine that transaction is active.
change/not execute dbms_transaction
Posted: Mon 23 Oct 2006 22:02
by josir
Is there a way not to execute it or to change the SQL command ?
Thanks in advance,
Josir.
Posted: Wed 25 Oct 2006 13:51
by Challenger
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.
Overriding dbms_transaction statement
Posted: Thu 26 Oct 2006 21:04
by josir
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