A generic procedure that can execute any procedure/function
input
Package name (IN)
procedure name (or function name) (IN)
A table indexed by integer, it will contain values that will be used to
execute the procedure (IN/OUT).
E.g
let's assume that we want to execute the procedure below
utils.get_emp_num(emp_name IN VARCHAR
                  emp_last_name IN VARCHAR
                  emp_num OUT NUMBER
                  result  OUT VARCHAR);
The procedure that we will create will have as inputs:
package_name = utils
procedure_name = get_emp_num
table = T[1] -> name
        T[2] -> lastname
        T[3] -> 0   (any value)
        T[4] -> N   (any value)
run_procedure(package_name,
              procedure_name,
              table)
The main procedure should return the same table that has been set in the
input, but with the execution result of the procedure
table =  T[1] -> name
         T[2] -> lastname
         T[3] -> 78734 (new value)
         T[4] -> F     (new value)
any thought ?
No comments:
Post a Comment