Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2012
    Posts
    1

    Unanswered: Errors after importing data dump

    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

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    fix the code.
    "COUNT" is a reserved/keyword & should not be used as object/column name.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2005
    Location
    Gex - France
    Posts
    15
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •