4 Replies Latest reply on Apr 13, 2010 11:31 AM by Ava

    ORA-01007: variable not in select list

    Ava
      Hi All,

      We are facing the following error while exeucting mappings in Oracle Warehouse Builder 11.1.0.7.0

      earlier all mappings are executing fine. from this morning we are getting the following error.

      we are using the join condition in mapping as follows:

      INGRP1.COLA>=INGRP2.COLA

      Can you please share how can we resolve the above error?

      Regards,
      Ava.
        • 1. Re: ORA-01007: variable not in select list
          Nawneet_Aswal
          What is the error.
          Is the mapping deployed without warning ...? If yes then run it .. Sometime OWB show validation warning but it can be ignored.
          (Mark the answer as help or correct if it is helpfull)

          Cheers
          Nawneet

          Edited by: Nawneet on Apr 12, 2010 9:34 AM
          • 2. Re: ORA-01007: variable not in select list
            Ava
            Hi nawneet,

            Mapping is deploying successfully. But while execution it is throwing below error and stopping the execution of mapping.

            ORA-01007: variable not in select list
            ORA-02063: preceding line from ERS_PSYS

            Earlier days mapping works fine. But from yestraday it is throwing the above error.


            Regards,
            Ava
            • 3. Re: ORA-01007: variable not in select list
              765394
              You did not explicitely say if you changed anything in the mapping or the database(tables ??) since yesterday...

              This error: ORA-01007 variable not in select list happens when there are not same number of values in the SELECT list as in the INTO clause.

              In your place I would carefully check the mappping code- package in the database ..look out for INTO clauses (BULK COLLECT as well)and see if everything is OK
              syntactically and if at runtime it is populated correctly.

              I can tell you anything more precise without seeing you package code..

              I am not sure if it is allowed for you to post the code here ?

              Edited by: Reggy on 13.04.2010 03:20
              • 4. Re: ORA-01007: variable not in select list
                Ava
                Hi,

                The mapping code is everything perfect. There is no changes in the code at source and mapping level.

                This issue came from yestraday morning. We are unable to place the code her as per policies..

                Regards,
                Ava