Archives of the TeradataForum

Message Posted: Fri, 13 Oct 2006 @ 08:07:18 GMT

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

Hi Haritha,

I'm not sure if I'm missing something here. But, if I have understood your problem correctly, then writing "HANDLERS" inside your procedure should solve the problem. You can choose to write CONTINUE/EXIT HANDDELR for a specific SQL EXCEPTION or a GENERIC ONE depending upon the possible scenarios in your procedure.

Hope this helps.

Thanks,

Tapas

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