Archives of the TeradataForum

Message Posted: Sat, 15 Dec 2012 @ 09:45:06 GMT

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

After you call the SP, use ALLOCATE statement to open a cursor for the result set. You can't use FOR to iterate through the result set, you need to explicitly FETCH. If your SP returns multiple result sets, you can ALLOCATE a cursor for the second after you CLOSE the first.

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