CREATE OR REPLACE FUNCTION xhogehoge(Pa_SyoriMode IN CHAR
,Pa_SyoriKind IN CHAR
,Pa_SyoriCnt IN NUMBER
,Pa_Status OUT NUMBER
,Pa_Message OUT VARCHAR2
) RETURN NUMBER AS
USER_ABEND EXCEPTION;
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
--ここに処理を記述
COMMIT;
RETURN 0;
EXCEPTION
--異常終了
WHEN OTHERS THEN
ROLLBACK;
RETURN SQLCODE;
END;
/
SHOW ERRORS