executing procedure from sqlplus

From: Christian M. Aranda <christian.arandaNOSPAM_at_NOSPAMiiginc.com>
Date: Thu, 21 Jan 1999 21:35:43 GMT
Message-ID: <788630$g0a$1@news-2.news.gte.net>

I am attempting to execute a stored procedure from sqlplus using the following syntax:

SQL> exec
BBNSP_DERIV_SRVC_v220BR_PKG.BBNSP_DERIV_SRVC_v220BR('100','IS','200','',''); begin
BBNSP_DERIV_SRVC_v220BR_PKG.BBNSP_DERIV_SRVC_v220BR('100','IS','200','',''); end;

      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'BBNSP_DERIV_SRVC_V220BR'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

here is the package specification:

create or replace package bbnsp_deriv_srvc_v220br_pkg as

       type service_name_table_type is table of sw_case.bbnservicename%Type index by binary_integer; procedure bbnsp_deriv_srvc_v220br (

          siteid          in      sw_case.swsiteid%Type,
          servtype        in      sw_case.bbnservicetype%Type,
          custid          in      sw_customer.swcustomerid%Type,
          servicename     out     service_name_table_type,
          batch_size      in      int,
          out_batch_size  in out  int,
          status          out     int);

end bbnsp_deriv_srvc_v220br_pkg;
/
show errors

create or replace package body bbnsp_deriv_srvc_v220br_pkg as

.
.
.

I'm not too sure what I'm doing wrong. The datatypes match, I'm using 5 input params...

Any and all comments appreciated! Received on Thu Jan 21 1999 - 15:35:43 CST