David,
How are you calling this procedure? Into what structures are you receiving
the PL/SQL Out Arguments, which are PL/SQL tables? I'll bet that's your
problem.
Show us the code that calls this procedure and handles the output.
BTW, if you checked the "speeling" of your PL/SQL as well as you did your
message, there may be even more problems. ;-)
Jack
--------------------------------
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068
-----Original Message-----
David
Sent: Wednesday, May 30, 2001 12:07 PM
To: Multiple recipients of list ORACLE-L
Hi all
Can someone help me out here? I am getting this error when I try to run this
PL/SQL code from an ASP page.
The error manual just says to check speeling. I DID. Is there anything I am
missing? The DB is V7.3 I am trying to
return the resultset to the page.
PLS-00306: wrong number or types of arguments in call to 'COURSE_SELECT'
Here is the PL/SQL code
create or replace package course.course_bulletin is
TYPE tbl_call_no IS TABLE of cmcmcrst.call_no%type
INDEX BY BINARY_INTEGER;
TYPE tbl_schl_cd IS TABLE of cmcmcrst.schl_cd%type
INDEX BY BINARY_INTEGER;
TYPE tbl_dept_cd IS TABLE of cmcmcrst.dept_cd%type
INDEX BY BINARY_INTEGER;
PROCEDURE course_select(i_ccyy IN NUMBER, o_call_no OUT tbl_call_no,
o_schl_cd OUT tbl_schl_cd,
o_dept_cd OUT tbl_dept_cd);
end;
create or replace package body course.course_bulletin as
PROCEDURE course_select(i_ccyy IN NUMBER, o_call_no OUT tbl_call_no,
o_schl_cd OUT tbl_schl_cd,
o_dept_cd OUT tbl_dept_cd) IS
CURSOR c1 is
SELECT call_no,schl_cd,dept_cd
FROM COURSE.cmcmcrst
WHERE ccyy = i_ccyy
AND term_cd = '2'
AND instrl_cd = '0';
crscount NUMBER DEFAULT 1;
BEGIN
FOR c IN c1 LOOP
o_call_no(crscount) := c.call_no;
o_schl_cd(crscount) := c.schl_cd;
o_dept_cd(crscount) := c.dept_cd;
crscount := crscount + 1;
END LOOP;
END;
end;
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack C. Applewhite
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).