Archives of the TeradataForum

Message Posted: Wed, 19 Dec 2012 @ 13:43:32 GMT


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

Subj:		Re: Using results returned from a Stored Procedure

From:		David Clough

Fred Pluebell wrote ....

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.

Blow me down, it only works !

Thanks Fred.

If anyone wants the example, look at page 35 in the Stored Procedures Manual (V13). The example works a treat.

If only I could then do

     SELECT * FROM TABLE (CALL alloc007()) ........ then we'd have it all !!

Regards

David Clough
Senior BI Database Designer


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

Archives

2016		2007
2015		2006
2014		2005
2013		2004
2012		2003
2011		2002
2010		2001
2009		2000
2008		1999

2012 Indexes

Jan		Jul
Feb		Aug
Mar		Sep
Apr		Oct
May		Nov
Jun		Dec

Last Modified: 15 Jun 2023