I have imported a data dump on oracle 10g server, to create a new schema.
Though the import is complete all the packages, functions, triggers are in uncompiled state, unable to compile them. Follwoing is the error trace. Seems like some grant or default packages might be missing. Need help on this. Any guidance will be appreciated.


Error: PLS-00302: component 'COUNT' must be declared
Line: 497
Text: FOR bankeridx IN 1..v_tt_banker_id.COUNT LOOP
Error: PL/SQL: Statement ignored
Line: 497
Text: FOR bankeridx IN 1..v_tt_banker_id.COUNT LOOP

Error: PLS-00201: identifier 'PLITBLM' must be declared
Line: 0
Error: PLS-00302: component 'COUNT' must be declared
Line: 529
Text: FOR idx IN 1..v_tt_aum_rm_prog_local.COUNT LOOP
Error: PL/SQL: Statement ignored
Line: 529
Text: FOR idx IN 1..v_tt_aum_rm_prog_local.COUNT LOOP
Error: PLS-00201: identifier 'PLITBLM' must be declared
Line: 0

fix the code.
"COUNT" is a reserved/keyword & should not be used as object/column name.

Hi LokeshB,

Have a look at your source database. Most probably, the same objects will not compile correctly.
As anacedent says it: Fix the code.