CREATE OR REPLACE
PROCEDURE PROCE_NAME(V_IN varchar2, V_OUT out varchar2) AS
BEGIN
--...
commit;
V_OUT := 'aaa';
exception
when others then
V_OUT := '999' || SQLerrm || DBMS_UTILITY.format_error_backtrace;
rollback;
END;
CREATE OR REPLACE
PROCEDURE PROCE_NAME(V_IN varchar2, V_OUT out varchar2) AS
BEGIN
--...
commit;
V_OUT := 'aaa';
exception
when others then
V_OUT := '999' || SQLerrm || DBMS_UTILITY.format_error_backtrace;
rollback;
END;