Why do I get this PLS-00225 error ? 2004-02-19 - By Guang Mei
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
