David,
You need a cusor variable to pass a result set. Something like this:
DECLARE
TYPE EmpCurTyp IS REF CURSOR RETURN emp%ROWTYPE;
PROCEDURE open_emp_cv (emp_cv IN OUT EmpCurTyp) IS ...
Hth..
"Bartolo, David" <[EMAIL PROTECTED]> on 06/01/2001 02:11:29 PM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: (bcc: Chaim Katz/Completions/Bombardier)
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
