Hi,

Is it possible to get the error message if one is thrown within a
stored procedure? i.e

WHEN ANY DO
BEGIN
IF (ERRORMESSAGE CONTAINING 'some string') THEN
DO SOMETHING
ELSE
EXCEPTION; -- re-throw the exception
END

regards

Si