Why do I get this PLS-00225 error ? 2004-02-19 - By Trevor.Williams@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
