We are migrating our project from version 6.0 to 7.5.1a in Tru64 OS. I am having Oracle stage as lookup and its having where condition. The custion SQL Stagement is ike:
When I run this job in version 7.5.1aI am getting the error like.SELECT TESTING_TB.PRODUCT_ID, TESTING_TB.PRO_COMP_NBR, TESTING_TB.UOM_STOCKING, TESTING_TB.SU_CONV_FACTOR, TESTING_TB.AZ_PRODUCT_ID
FROM I_ETL.TESTING_TB
WHERE AZ_PRODUCT_ID=:1
When I run the same job in version 6.0, running fine. What does :1 refer exactly? What could be the problem. I searched in the forum but I could not find the required solution.ORA-01008: not all variables bound
Please help me to solve this issue.
Thanks in advance.
[/code][/quote]