ous Transaction Tips

welcome to http://www.startdays.com
welcome to http://www.ijachouf.com
welcome to http://www.swtools.biz
welcome to http://www.decoderhd.com

Autonomous Transaction Tips

Oracle Tips by Burleson Consulting
June 29, 2011

Question: I am getting an âORA-14552: cannot perform a DDL, commit or
rollback inside a query or DMLâ error and I want to make my function
into an autonomous transaction with the âpragma autonomous transactionâ
syntax:

create or replace function
rebuildSequence
return number
as
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------