Re: [No Subject]

If I am not mistaken, that is being done routinely. Here is an example:

BEGIN
   TYPE local_rec IS RECORD (

   ename                    emp.ename%TYPE,
   sal                          emp.sal%TYPE,
   dept_no                 emp.dept_no%TYPE);

   TYPE local_cur IS REF CURSOR RETURN local_rec;

   TYPE local_cur2 IS REF CURSOR;
END;
/

Michael

• Original Message ----- From: <ajay_at_tems.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, August 14, 2000 7:17 PM Subject: [No Subject]

> Is it possible to create a reference cursor manually without creating from
query running on actual table.And how ?
> Thanks in advance.
> Ajay
> --
> Author:
> INET: ajay_at_tems.com
>
> 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 Sun Aug 20 2000 - 21:16:57 CDT