Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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 DBAReceived on Fri Jul 09 2004 - 13:33:03 CDT
![]() |
![]() |