Tuesday, August 11, 2009

PRAGMA autonmous_transaction

If you want to create a procedure to perform some dml operations and commit this transactions regardless or without affect the transactions control of the calling environment you should use PRAGMA autonmous_transaction
in the declaration section of your pl/sql code

pragma autonmous_transaction instruct oracle server to do the dml operations and commit or rollback independently of the calling environment

sample code :

create or replace procedure xx as

pragma autonmous_Transaction ;
begin
......
end;

No comments: