Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PLS-00201: identifier must be declared
I think the table function only works in 9I and above.
cschang <cschang_at_maxinter.net> wrote in message news:<40EEADDB.9040907_at_maxinter.net>...
> 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
Received on Fri Jul 09 2004 - 14:39:16 CDT