You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
GDSCODE and SQLCODE are both zero. There are no more variables I can check.
Please add a possibility to get the name and message of the exception into a variable e.G. EXTYPE and EXMESSAGE and handle the variables like GDSCODE and SQLCODE
The text was updated successfully, but these errors were encountered:
Submitted by: Bjoern Reimer (bnreimer)
Is related to CORE2040
Votes: 7
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.
GDSCODE and SQLCODE are both zero. There are no more variables I can check.
Please add a possibility to get the name and message of the exception into a variable e.G. EXTYPE and EXMESSAGE and handle the variables like GDSCODE and SQLCODE
The text was updated successfully, but these errors were encountered: