I'm trying to make a call of packaged stored procedure, e.g.:

=================== perl code ===================
  $sSQL = q{
    begin

      package.function_name( :i_param1
                                   , :i_param2
                                   , :i_param3
                                   , :o_param1
                                   );
    end;
  };

  $sth = $dbh->prepare($sSQL);

  $sth->bind_param(':i_param1', 1);
  $sth->bind_param(':i_param2',  $sDateStart, { ora_type => ORA_VARCHAR2 });
  $sth->bind_param(':i_param3',  $sDateEnd,  { ora_type => ORA_VARCHAR2 });

  $sth->bind_param_inout( ':o_param1', \$iDaysCnt, 100000, { ora_type
=> ORA_NUMBER } );

  $sth->execute;
=================== perl code ===================

function_name is an overloaded PL/SQL stored procedure, one accepts
i_param2 & i_param3 of type DATE, second accepts i_param2 & i_param3
of type VARCHAR2.
When executing code like above, I'm getting this error:

   PLS-00307: too many declarations of 'function_name' match this call

Is there any way to make it work?

-- 
   WBR, Eugene Krivdyuk

Reply via email to