delete tab_xx where fid = id; insert into tab_xx(name) values(name)....
CREATE OR REPLACE PROCEDURE temp(p_id varchar2,p_name varchar2) IS BEGIN delete tableA where id = p_id ; insert into tableB(name) values(p_name); COMMIT; EXCEPTION WHEN OTHERS THEN ROLLBACK; END;
insert into tab_xx(name) values(name)....
IS
BEGIN delete tableA where id = p_id ; insert into tableB(name) values(p_name); COMMIT;
EXCEPTION
WHEN OTHERS
THEN
ROLLBACK;
END;