ORA-01008: not all variables bound

sid19 · Post by **sid19** » Thu Feb 23, 2017 6:16 am

Hi,

We recently installed Datastage 11.3.1.2. We are creating a parallel job with following design

Sequential file ( One filed)---->Transformer( added one more field as key1 with hardcoded value as 1)------> Lookup stage ( Reference link directly from Oracle connector Stage with following SQL
"
SELECT 1, XX_FAH.XX_BSF_OGL_GEN_SEQ.NEXTVAL FROM DUAL WHERE 1=:1

"

doing lookup on key1. From lookup we have a target file.

we are facing following error log

SVF_DAILY_TRANS_SEQ,0: The following SQL statement failed: SELECT 1, XX_FAH.XX_BSF_OGL_GEN_SEQ.NEXTVAL FROM DUAL WHERE 1=:1.

SVF_DAILY_TRANS_SEQ,0: The OCI function OCIStmtExecute returned status -1. Error code: 1008, Error message: ORA-01008: not all variables bound. (CC_OraStatement::executeSelect, file CC_OraStatement.cpp, line 3,900)

Please let me know how to sort this out.

Thanks

chulett · Post by **chulett** » Thu Feb 23, 2017 8:03 am

Whatever you are thinking should be matching up to the :1 bind variable needs to be marked as a key and it doesn't sound like it is. If it is, we'd need to know how your columns are configured in the lookup, in and out.

sid19 · Post by **sid19** » Thu Feb 23, 2017 8:16 am

Hi chulett,

We have marked field as key in the column tab of output column of Oracle connector stage and similarly Key has been Market for main link as well. We have kept the same name both the side (from Transformer as main and from Oracle connector as reference) We kept the data type as integer in both the link.

Thanks,

sid19 · Post by **sid19** » Thu Feb 23, 2017 8:38 am

Hi Chullet,

We have just noticed that Oracle Connector Stage -- Output -- Properties tab
Lookup type was Normal. We changed to Sparse and it working fine

Thanks,
Shamim