errbuf and retcode
It's explained in the Developer Guide. The ERRBUF is the message that you return and RETCODE is the return code. These two parameters are very much required exactly in the fashion.
If the RETCODE is 0 stands for Success, 1 for success with warnings and 2 for Errors.
For example you have a stored procedure created as below
CREATE PROCEDURE TEST_CONC(ERRBUF OUT VARCHAR2,RETCODE OUT VARCHAR2)
AS
BEGIN
--- PROCESSS
ERRBUF := 'Successful Operation';
RETCODE := '0';
EXCEPTION
--- EXCEPTION HANDLING
ERRBUF := 'Found Exception ';
RETCODE := '2';
END;
If the RETCODE is 0 stands for Success, 1 for success with warnings and 2 for Errors.
For example you have a stored procedure created as below
CREATE PROCEDURE TEST_CONC(ERRBUF OUT VARCHAR2,RETCODE OUT VARCHAR2)
AS
BEGIN
--- PROCESSS
ERRBUF := 'Successful Operation';
RETCODE := '0';
EXCEPTION
--- EXCEPTION HANDLING
ERRBUF := 'Found Exception ';
RETCODE := '2';
END;
Comments