Anyway to disable autonomous transaction during SQL query execution
451392Jul 28 2008 — edited Jul 30 2008I am using Oracle DB 10.2.
Is there any way I can disable autonomous transaction execution in my session while executing a SQL query.
If a SQL query refers to a function which does DML operation the query returns exception as it should.
However if the query refers to a function which does the DML operation as a part of autonomous transaction, the execution of the query successfully executes the autonomous transaction as well.
My requirement is to block execution of query, which refers to a function which does DML operation as a part of autonomous transaction.
Thanks