Re: PLS-00201: identifier must be declared

On Fri, 09 Jul 2004 10:38:19 -0400, cschang <cschang_at_maxinter.net> wrote:

>I construct a package includeing a cursor as
>CURSOR c_FL_NSN (p_sa IN sa_codes.sa%TYPE) IS
>select name
>from fl_management f, TABLE(f.mgmts_nt) f2
>where f2.sa= p_sa;
>
>BEGIN
>..
>
>
>the SQL script works well in SQL mode (with a value of p_sa) but not in
>a PL/SQL procedure. the compilation of the package complained the errors of
>86/17 PLS-00320: the declaration of the type of this expression is
>incomplete or malformed
>
>87/38 PLS-00201: identifier 'F.MGMTS_NT' must be declared
>lines 86, 87 are the from and where lines.
>Any alternative? My set up in 8.1.7.4 on NT 4. Thanks.
>
>C Chang

This question has now been asked more than a zillion times. Please use Google before asking it again.

--
Sybrand Bakker, Senior Oracle DBA