uOverload

The uOverload param in DbiOpenSPParamList allows specification of an overload number if the server supports overloading of procedure and function names. For example, using Oracle 7, you might have this package specification:

   create package EMP_RECS as

        procedure get_sal_info (
             name      in      emp.ename%type,
             salary    out     emp.sal%type);

        procedure get_sal_info (
             ID_num    in      emp.empno%type,
             salary    out     emp.sal%type);

        function get_sal_info (
             name     emp.ename%type)   return emp.sal%type;

   end EMP_RECS;

 

DbiOpenSPParamList with uOverload=1 would return the name and salary parameters for procedure 1. If uOverload = 2, then ID_num and salary would be returned.

If a procedure is not overloaded, then uOverload should be set to 0. Otherwise uOverload should be set to 1..n for n overloadings of the name.