Q:
Running Procedures within the PL/SQL program
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?!
ASKED:
Apr 28 2008 10:53 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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.
