Hi
You have named your row "x" so need to put_line( x.name )
t
-----Original Message-----
From: Guang Mei [mailto:gmei_at_incyte.com]
Sent: Friday, 20 February 2004 10:51 am
To: oracle-l_at_freelists.org
Subject: Why do I get this PLS-00225 error ?
Oracle 8173 on Solaris
MT_at_rex-SQL> select distinct name from all_source where
owner='MT' and
type ='PROCEDURE';
NAME
------------------------------
DEPTREE_FILL
MT_at_rex-SQL> set serveroutput on
MT_at_rex-SQL>
MT_at_rex-SQL> declare
cursor c1 is select distinct name from all_source
where owner='MT' and type ='PROCEDURE';
lname varchar2(30);
begin
for x in c1 loop
dbms_output.put_line (c1.name);
end loop;
end;
/
dbms_output.put_line (c1.name);
*
ERROR at line 7:
ORA-06550: line 7, column 31:
PLS-00225: subprogram or cursor 'C1' reference is out of
scope
ORA-06550: line 7, column 6:
PL/SQL: Statement ignored
TIA.
Guang
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:
oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at
http://www.freelists.org/help/fom-serve/cache/1.html
Disclaimer. This e-mail is private and confidential. If you are not the
intended recipient, please advise us by return e-mail immediately, and
delete the e-mail and any attachments without using or disclosing the
contents in any way. The views expressed in this e-mail are those of the
author, and do not represent those of this company unless this is clearly
indicated. You should scan this e-mail and any attachments for viruses. This
company accepts no liability for any direct or indirect damage or loss
resulting from the use of any attachments to this e-mail.
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Feb 19 2004 - 21:26:16 CST
