I want to call a stored procedure in my exception handler. However when I have an error that triggers the exception handler it doesn't seem to trigger the stored procedure.
Is it possible to do this?
Is there something I am doing wrong? I do however get a message from the raise_application_error that lets me know something went wrong.
Here is my exception handler:
EXCEPTION
WHEN OTHERS THEN
StoO_error := SQLCODE;
StoO_errmsg := SQLERRM;
--Call stored procedure
UPDATE_Product_Problem(INSERT_PRODUCT.PROD_ID, 'INVALID);
raise_application_error(SQLCODE, SQLERRM,true);
Is it possible to do this?
Is there something I am doing wrong? I do however get a message from the raise_application_error that lets me know something went wrong.
Here is my exception handler:
EXCEPTION
WHEN OTHERS THEN
StoO_error := SQLCODE;
StoO_errmsg := SQLERRM;
--Call stored procedure
UPDATE_Product_Problem(INSERT_PRODUCT.PROD_ID, 'INVALID);
raise_application_error(SQLCODE, SQLERRM,true);