How can I pass the values in a table to a procedure?
Printable View
How can I pass the values in a table to a procedure?
If I 'm right, there are several ways to do that, one of the ways is:
Create a cursor to hold all the values that U want, and start a loop, U can call the procedure within this loop until U want to exit the loop; if only one value, U can using an implicit cursor to hold the value, and then pass it to the procedure.
Hope it will give U a hint.
Take care