This content has been marked as final. Show 4 replies
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)
Edited by: Nawneet on Apr 12, 2010 9:34 AM
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.
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
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..