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