PL/SQL cursor declaration

From: Bartolo, David <bartolo_at_USCOLO.edu>
Date: Fri, 01 Jun 2001 11:46:53 -0700
Message-ID: <F001.003182BC.20010601101129@fatcity.com>

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: bartolo_at_USCOLO.edu

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: ListGuru_at_fatcity.com (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). Received on Fri Jun 01 2001 - 13:46:53 CDT