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 output...is it possible..?
We are using TD.14.10.
Please share some sample example...
have a look at ALLOCATE: