Oracle Exception handling
614921Nov 21 2008 — edited Dec 23 2008We are doing like this in Our Stored Procedure
EXCEPTION WHEN OTHERS THEN
raise_application_error(SQLCODE, SQLERRM);
and there was a comment from the testing Team
raise_application_error(SQLCODE, SQLERRM) for error handle is not correct. All error out of range of -20000 to -20999 will encounter another error as ORA-21000: error number argument to raise_application_error of -1400 is out of
range
So can anyone tell us exctly that how to Do this.
Our requirement is that we want to log the Exact error msg and Code.