Archives of the TeradataForum

Message Posted: Fri, 26 Mar 2004 @ 13:17:19 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

I do not think, the current implementation will capture the error message in stored procedure. We can always check the error message corresponds to the SQLCODE in the DBC.ERRORMEGS table. If any of the handlers does not exist CALL will report that error. In case if the handler exists, you can capture the SQLSTATE and SQLCODE and check for the error message.

-- Padmini

	<Prev	Next>		<<First	<Prev	Next>	Last>>