Archives of the TeradataForum
Message Posted: Thu, 18 Apr 2003 @ 01:13:57 GMT
You would need to create an exit handler. The syntax is something like this:
DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN /* what u want to do when an error is raised before exiting */ SET error_message = 'something went wrong'; END
The above block goes right after variable declarations.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|