6 Replies Latest reply: Jul 23, 2003 10:38 AM by 390106 RSS

    pls-00225

    390106
      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
          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
            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
              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
                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
                  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
                    It worked thanks.

                    David S.