|
|
Archives of the TeradataForum
Message Posted: Thu, 11 Dec 2008 @ 15:48:29 GMT
Subj: | | Re: Exception handling for stored procedures and functions |
|
From: | | Geoffrey Rommel |
I second the remarks of Michael and others that SP's should ordinarily be avoided. But to return to the original question: if you decide that
you must use procedures, there is no equivalent of PUT_LINE. If you want the procedure to issue messages, you must insert them into a log table.
The procedure can also display a message in an OUT parameter, but it can only be a single row.
| |