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.

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.