It's possible there is some sort of bug when it has to handle a large number of variables. A workaround might be to assign the PL/SQL variables to the bind variables before calling the package. Also put a dbms_output statement against each bind variable. If it hasn't been declared properly you should get an error here as well.
Code:declare v_vis_c_fname emps.c_fname%TYPE; v_vis_c_lname emps.c_lname%TYPE; ... begin dbms_output.put_line(:v_vis_c_fname); v_vis_c_fname := :v_vis_c_fname; dbms_output.put_line(:v_vis_c_lname); v_vis_c_lname := :v_vis_c_lname; .. load_names_p.pr_load_names (v_vis_c_fname, v_vis_c_lname, [more variables listed here]...); end;




Reply With Quote