Hi all,
I am getting a PLS-320 the declaration of the type of this expression is
incomplete or malformed.
This is ORACLE V7, PL/SQL V2.1.4. I know I am missing something but I can't
see it.
The select should return multiple rows to be passed into a web page.
Thank in Advance
David
Here is the code.
create or replace PACKAGE COURSE.COURSE_BULLETIN is
CURSOR C1 (i_ccyy IN NUMBER) is
select call_no, schl_cd, dept_cd
from course.cmcmcrst
where ccyy = i_ccyy
and term_cd = '2'
and instrl_cd = '0';
procedure COURSE_SELECT(i_ccyy IN NUMBER, rsCur IN OUT C1);
end;
create or replace PACKAGE BODY COURSE.COURSE_BULLETIN is
procedure COURSE_SELECT(i_ccyy IN NUMBER, rsCur IN OUT C1)
begin
open rsCur (i_ccyy);
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).