Here is the ASP code
ccyy = "2001"
set cn = server.CreateObject("adodb.connection")
set cmd = server.CreateObject("adodb.command")
set rs = server.CreateObject("adodb.recordset")
cn.ConnectionTimeout = 120
cn.CommandTimeout=30
cn.ConnectionString="DSN=db;UID=user;Password=pwd"
cn.Open
cmd.ActiveConnection = cn
cmd.CommandText = "{call course.course_bulletin.course_select({resultset
10000, o_call_no,
o_schl_cd, o_dept_cd})}"
cmd.CommandType=adCmdText
cmd.Parameters.Append cmd.CreateParameter("i_ccyy", adInteger, adParamInput,
, clng(ccyy))
set rs.Source = cmd
rs.Open
-----Original Message-----
Sent: Wednesday, May 30, 2001 12:01 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
I think the error is in the call to the procedure, not in the procedure
itself -- the procedure looks fine at a glance. Could you post the ASP
code that makes the call?
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]
"Bartolo,
David" To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
<bartolo@USCO cc:
LO.edu> Fax to:
Sent by: Subject: PL/SQL Error
root@fatcity.
com
05/30/2001
01:06 PM
Please
respond to
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: Bartolo, David
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bartolo, David
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).