Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Wrong number or type of arguments in call to REPORT - pls-00306

698726Apr 28 2009 — edited Apr 28 2009
I'm getting PLS-00306 wrong number or type of argument in call to 'REPORT'. I'm stumped!

This is the call in the spec of my package:

-- Report output procedure
PROCEDURE report (i_sessionid IN VARCHAR2 DEFAULT ' '
,i_start IN DATE
,i_end IN DATE
,i_type IN VARCHAR2 DEFAULT 'L'
,i_amount IN NUMBER DEFAULT 0
,i_giftclub IN VARCHAR2 DEFAULT ' '
,i_campus1 IN VARCHAR2 DEFAULT ' '
,i_campus2 IN VARCHAR2 DEFAULT ' '
,i_allocation IN VARCHAR2 DEFAULT ' '
,i_person_or_org IN VARCHAR2 DEFAULT ' '
,i_operator IN VARCHAR2 -- Operator logon (Required for every report)
,RC1 IN OUT refcur_pkg.rc);

This is the report ini the body of the package
******************************************************************************/
PROCEDURE report ( i_sessionid IN VARCHAR2 DEFAULT ' '
,i_start IN DATE
,i_end IN DATE
,i_type IN VARCHAR2 DEFAULT 'L'
,i_amount IN NUMBER DEFAULT 0
,i_giftclub IN VARCHAR2 DEFAULT ' '
,i_campus1 IN VARCHAR2 DEFAULT ' '
,i_campus2 IN VARCHAR2 DEFAULT ' '
,i_allocation IN VARCHAR2 DEFAULT ' '
,i_person_or_org IN VARCHAR2 DEFAULT ' '
,i_operator IN VARCHAR2 -- Operator logon (Required for every report)
,RC1 IN OUT refcur_pkg.rc)

I've recompiled this code a couple of times and it compiles without errors.
Any help would be appreciated, Susan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 26 2009
Added on Apr 28 2009
4 comments
1,724 views