Exception Handler in Teradata Stored Procedure

[anusha2]

I have an exception handler already defined in my stored procedure which will capture the error code and error message and load them in an error table.

What I want is, suppose my update statement in the stored procedure fails for a particular serial number, I want to capture that also in my error table along with the error code and error message.

Can I do that in Teradata stored procedure and if yes, could you please provide me with a code sample?

Thank You!!