RE: Why do I get this PLS-00225 error ?
- From: "Guang Mei" <gmei@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 20 Feb 2004 09:41:16 -0500
Thanks! I have written hundreds of this kind of code and my brain was just
dead for a few minutes.
Guang
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of
Trevor.Williams@xxxxxxxxxx
Sent: Thursday, February 19, 2004 10:26 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Why do I get this PLS-00225 error ?
Hi
You have named your row "x" so need to put_line( x.name )
t
-----Original Message-----
From: Guang Mei [mailto:gmei@xxxxxxxxxx]
Sent: Friday, 20 February 2004 10:51 am
To: oracle-l@xxxxxxxxxxxxx
Subject: Why do I get this PLS-00225 error ?
Oracle 8173 on Solaris
MT@rex-SQL> select distinct name from all_source where
owner='MT' and
type ='PROCEDURE';
NAME
------------------------------
DEPTREE_FILL
MT@rex-SQL> set serveroutput on
MT@rex-SQL>
MT@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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at
//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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
