We have our own ETL(Abinitio) job which joins with oracle database and pulls out the respective columns from the table. While running today in prod environment we encountered "not all variables bound" issue. Below is the sql:
select /*+ PARALLEL */table1.rowid, table1.column1 as out1, table1.column2, table1.column4, table1.column3, table1.column5, table1.column7 from table12 table1 where table1.column3 = substr(:column3,6,7) and table1.column4 IN (1,2) and table1.column5 = :column5 and table1.column6 NOT IN ('HI','HELLO')
But when this is run in dev i don't get any issue. Below is the oracle and AIX version.
Oracle version: 11.2.0
AIX Version: 7.1.0.0