ORAOCI error

[admin]

Hi,

Im designing a job with a stage ORAOCI containing the following query:

select substr(a.idrbes,1,15) idrbes, a.idrf, substr(a.idvpdwh,2,6) idvpdwh from ODS.tctrt a, ODS.tproduto b where a.idvpdwh=b.idvpdwh and b.ctdrpb=35

The option View Data doesnt return any error.

Running the job Ive got the following error.

LSESAME.TO_TCTRT: ORA-01036: illegal variable name/number

This problem is a very common problem here in our client, what we have done is change the Stage ORAOCI by ODBC and it works.

Anyone knows this error? Is this a bug?

Thanks

Antonio Monteiro