Hi, I am making using of the WHEN clause to trap any exceptions that are produced during the execution of my stored procedure (non selectable). ... WHEN ANY DO BEGIN INSERT INTO SP_ERRORS (ROWNO, EXCEPT_MESSAGE) VALUES (:vIRN, ????); END ...
How can I store the value (text) of the exception that was created where I have the ?'s above? Regards Marius J. Labuschagne