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;
Tuesday, August 11, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment