I have a stored procedure ( SP1 ) that returns a cursor with many columns, I need to know how from another stored procedure ( SP2 ) I call SP1 strong> and the result manipulated it with a SELECT to group, add and do other kinds of things with that data?
Note: I do not include the SP1 query because it is very long and complex.
The only thing I have is how to call SP1 from SP2 but I can not do a SELECT :
EXEC ESQUEMA.PAQUETE.SP1('21/02/2018', 1, 'usertest', :salida);
SELECT * FROM salida WHERE CODIGO = 'ABC'