create or replace function fn_dml_oprs return number as procedure prc_insert as pragma autonomous_transaction; begin insert into t1 values(250) where A=20; commit; end; procedure prc_update as pragma autonomous_transaction; begin update t1 set A=300 where A=10; commit; end; procedure prc_delete as pragma autonomous_transaction; begin delete from t1 where A=30; commit; end; begin prc_insert; prc_update; prc_delete; return 0; end; /
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)