Question

Running Procedures within the PL/SQL program

PL/SQL, SQL Server stored procedures, EXEC, Stored procedures

WE are dealing with stored procedures in a PL/SQL program. I am trying to execute the procedure from within the program itself. Is there a need to do it within a cursor or is there a specific manner to do that?!

I might be missing a few details, but to execute another stored procedure inside a stored procedure, simply call the procedure with its parameters

procedure1(parameter1,parameter2,...);

Whether or not it needs to be in a cursor, depends on what the procedure does. If the cursor does not return a lot of rows ( less than a thousand or so) you could pack the data into varrays. You will probable need a varray as an out variable to hold the results of the stored procedure. If possible you could also write it as a function and embed the function call in the SQL statement itself.

If you have any details you can provide, you might get a better answer.