We're using an vendor-supplied application that uses procedures. I need to
run a script that calls one of the procedures to update some tables, and
need to do it repeatedly on multiple records. I can do it with direct
updates but use of the procedure is much preferred.

The procedure requires parameters A, B, and C. I know I can invoke the
procedure with:

call procedure(A,B,C)

but I also need to do it repeatedly, with for example:

call procedure(D,E,F)
call procedure(G,H,I)

Given a list of parameters, is there a simple way to loop through multiple
calls? Maybe something like (making this up):

Call procedure(?,?,?)

using parameters(A,B,C)
(D,E,F)
(G,H,I)

Thanks in advance for any assistance offered.

Chris Cowles
Gainesville, FL

I think you could put parameter values in table variable and loop through
it and call the procedure with the values from the table variable.
It can also be done by storing the parameter values in a database table
(may be temporary table) and using cursor to loop through it and
execute the procedure.

Hilarion