All Forums Database
GuptaLav 1 post Joined 06/15
04 Jun 2015
Reg Rules and Limitations for Dynamic Result Sets

Hi Guys,
There is a requirement ..where in we have to create 2 Stored Proc ;
SP1-- Returns dynamic result set (multiple rows/multiple colums) as output via cursor.
We want to create another SP2 (wrapper SP ) which should call SP1 internally , and returns resultset of SP1 as SP2 it possible..?
We are using TD.14.10.
Please share some sample example...

dnoeth 4628 posts Joined 11/04
05 Jun 2015

Hi Lav,
have a look at ALLOCATE:


You must sign in to leave a comment.