Subject Fetching exception message text?
Author Björn Reimer
How can I fetch the message text of an exception in an when-block?

Given I raise an exception with a message inside a trigger or an
stored procedure and I call this procedure from another procedure or
the trigger is fired when modifying data vie a stored procedure.

Can I and when how get the message of the raised exception into a
variable inside the calling procedure?

GDSCODE and SQLCODE are both zero. That's in the moment the only hint
I've got that the exception was raised not from the engine.


Björn Reimer - RRZE