Exception Handling in Teradata SP?

Database
Enthusiast

Exception Handling in Teradata SP?

Hi,

I have created a SP with huge logic and i am in the situation to handle the exeption in my SP. Can anyone help me?

Thanks,
Uma Kathir
1 REPLY
Enthusiast

Re: Exception Handling in Teradata SP?

I am all set now and handles as below:

-----------
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET mTT = mTT || 'ERR-' || SQLSTATE
-----------

where mTT is the output variable.