Why do I get this PLS-00225 error ?

From: Guang Mei <gmei_at_incyte.com>
Date: Thu, 19 Feb 2004 21:51:20 -0500 (EST)
Message-ID: <Pine.GSO.4.33.0402192148170.10606-100000@bev-ssh>

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


-----------------------------------------------------------------

Received on Thu Feb 19 2004 - 20:51:20 CST