 | | | Why do I get this PLS-00225 error ? | Why do I get this PLS-00225 error ? 2004-02-20 - By Guang Mei
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@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of
Trevor.Williams@(protected)
Sent: Thursday, February 19, 2004 10:26 PM
To: oracle-l@(protected)
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@(protected)]
Sent: Friday, 20 February 2004 10:51 am
To: oracle-l@(protected)
Subject: Why do I get this PLS-00225 error ?
Oracle 8173 on Solaris
MT@(protected) > select distinct name from all_source where
owner= 'MT ' and
type = 'PROCEDURE ';
NAME
-- ---- ---- ---- ---- ---- --
DEPTREE_FILL
MT@(protected) > set serveroutput on
MT@(protected) >
MT@(protected) > 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 (See ORA-06550.ora-code.com): line 7, column 31:
PLS-00225: subprogram or cursor 'C1 ' reference is out of
scope
ORA-06550 (See ORA-06550.ora-code.com): 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@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
|