oracle 存储过程模板

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;