Subject Fetching exception message text?
Author Björn Reimer
(Retry sending it to the list)

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



--
Björn Reimer - RRZE