ORA-01036: illegal variable name/number while running job
Posted: Sat Oct 24, 2009 8:52 am
Hi all,
I got below fatal error while i tried to running a datastage error. I'm able see the data through viewdata in oracle datastage.
ORA-01036: illegal variable name/number.
Iam performing the reference lookup on the following SQL which is UserDefined from Table and columns
SELECT MAX(CUST_KEY) as CUST_MAX_KEY, 'Literal' FROM DS_BK.BK_CUST_DIM .
And the datatypes for CUST_MAX_KEY and Literal are numeric .Also, the key colun was Literal .
Could you plesae help me i getting this problem resolved..
Thanks
I got below fatal error while i tried to running a datastage error. I'm able see the data through viewdata in oracle datastage.
ORA-01036: illegal variable name/number.
Iam performing the reference lookup on the following SQL which is UserDefined from Table and columns
SELECT MAX(CUST_KEY) as CUST_MAX_KEY, 'Literal' FROM DS_BK.BK_CUST_DIM .
And the datatypes for CUST_MAX_KEY and Literal are numeric .Also, the key colun was Literal .
Could you plesae help me i getting this problem resolved..
Thanks