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

    ORA-01007: variable not in select list

    Ava
    Ava Apr 12, 2010 11:37 AM
      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.
      • 2296 Views
      • Tags:
        • 1. Re: ORA-01007: variable not in select list
          Nawneet_Aswal
          Nawneet_Aswal Apr 12, 2010 1:35 PM (in response to Ava)
          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
            Ava Apr 13, 2010 5:46 AM (in response to Nawneet_Aswal)
            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
              765394 Apr 13, 2010 10:21 AM (in response to Ava)
              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
                Ava Apr 13, 2010 11:31 AM (in response to 765394)
                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