I am doing direct lookup to an oracle table (having userdefined Query with multiple unions) when i run the job with out giving bind variable "the first row value of lookup is repeated for the remaining rows".
when i use a bind variable i am getting the following error
Code: Select all
"ORA-01036: illegal variable name/number"