PLS-00201: identifier must be declared

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 - 09:38:19 CDT