Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!newshosting.com!nx02.iad01.newshosting.com!fu-berlin.de!uni-berlin.de!not-for-mail
From: "Oracle Newbie" <f93c0532@yahoo.com>
Newsgroups: comp.databases.oracle.misc
Subject: Fields in variable cursor
Date: Wed, 7 Jul 2004 16:30:33 +0500
Lines: 29
Message-ID: <2l255gF7hpjvU1@uni-berlin.de>
X-Trace: news.uni-berlin.de P9T0PCb8n6daL8IlyzFgvgTKy8kpfJP5OXhvg8OyjK6/VJVeU=
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Xref: core-easynews comp.databases.oracle.misc:111531
X-Received-Date: Wed, 07 Jul 2004 04:29:03 MST (news.easynews.com)

A stored procedure has returned a variable cursor (say rsg ). Now in SQL
Plus how can I access the fields or columns of the record ?
Is'nt there something like rsg(1) etc. and even if I know the field names
rsg.ename doesnt work.

thx.

SQL> DECLARE
  2    TYPE rfc IS REF CURSOR;
  3    rsg rfc;
  4    ename varchar(15);
  5
  6
  7  BEGIN
  8     emp_grade.GetEGrade(18,rsg);   /* rsg is an output cursor parameter
*/
  9
 10     dbms_output.put_line(rsg.ename);
 11  END;
 12  /
   dbms_output.put_line(rsg.ename);
                            *
ERROR at line 10:
ORA-06550: line 10, column 29:
PLS-00487: Invalid reference to variable 'RSG'
ORA-06550: line 10, column 4:
PL/SQL: Statement ignored