|
|
Archives of the TeradataForum
Message Posted: Thu, 18 Sep 2003 @ 10:32:29 GMT
Subj: | | How can I get the message of exception? |
|
From: | | hzhang |
Hi All
In stored procedure ,we can catch exception by SQLEXCEPTION,example:
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
INSERT INTO Proc_Error_Table
(:SQLSTATE, CURRENT_TIMESTAMP, 'spSample4','Failed to Insert Row');
This program can get the SQLSTATE of Exception ,but i want to get the detailed message of Exception defined by teradata system, how can i
do?
THANKS!
zhanghao
| |