SELECT ISRETRIABLE INTO isRetriable from ACME_ERRORCODES where ERRORCODE=theERRORCODE;
If theERRORCODE is not found, I get a "ORA-01403: no data found".
In reality, in this case I would like to return 0.
This can be achieved by adding the clause:
EXCEPTION WHEN NO_DATA_FOUND THEN return 0; WHEN OTHERS THEN RAISE;
No comments:
Post a Comment