This discussion is archived
6 Replies Latest reply: Jul 23, 2003 8:38 AM by 390106 RSS

pls-00225

390106 Newbie
Currently Being Moderated
Hello, when I try to deploy a map (created in OWB920) into a target database oracle 9i. I'll get this error message(pls-00225). I did looked it up in error message file I know what it means but do know how to fix it, because OWB generated the script.

Please Help

Thanks
David S.
  • 1. Re: pls-00225
    314429 Newbie
    Currently Being Moderated
    Can you please give more details about the mapping and the DB version you are trying to use?

    Regards:
    Igor
  • 2. Re: pls-00225
    390106 Newbie
    Currently Being Moderated
    This is the error message. Main is the name af my map.

    "PLS-00225: subprogram or cursor 'MAIN' reference is out of scope"

    This is the actual code OWB has generated


    "IF (batch_inserted + batch_merged) >= get_map_num_rows THEN
    a_table_to_analyze.ownname := actual_owner;
    a_table_to_analyze.tabname := actual_name;
    a_table_to_analyze.estimate_percent := 90;
    a_table_to_analyze.granularity := 'ALL';
    a_table_to_analyze.cascade := FALSE;
    a_table_to_analyze.degree := NULL;
    MAIN.tables_to_analyze;[b[i]](MAIN.tables_to_analyze.COUNT + 1) := a_table_to_analyze END IF;"

    and the problem could be that "tables_to_analyze" does not have COUNT element?

    ]](MAIN.tables_to_analyze.COUNT + 1) := a_table_to_analyze


    Regards
    David S.
  • 3. Re: pls-00225
    314429 Newbie
    Currently Being Moderated
    Count is the system attribute of all the table objects, so I don't think this is the problem. Have you tried to deploy the mapping through SQLplus?
    Also, can you please describe the map, I might have to recreate your case.

    Regards:
    Igor
  • 4. Re: pls-00225
    390106 Newbie
    Currently Being Moderated
    Yes same message,
    168/11 PL/SQL: Statement ignored
    168/16 PLS-00225: subprogram or cursor 'MAIN' reference is out of scope
    912/13 PL/SQL: Statement ignored
    912/18 PLS-00225: subprogram or cursor 'MAIN' reference is out of scope
    1640/13 PL/SQL: Statement ignored
    1640/18 PLS-00225: subprogram or cursor 'MAIN' reference is out of scope


    I am trying to learn OWb so the map is a simple map, one table (source is orc8) and one dim )target is (ora9i) nothing fancy.
  • 5. Re: pls-00225
    26222 Newbie
    Currently Being Moderated
    David,

    I think MAIN is a reserved word. I recommend you call your mapping differently to resolve the issue.

    Mark.
  • 6. Re: pls-00225
    390106 Newbie
    Currently Being Moderated
    It worked thanks.

    David S.