ORAOCI error
Posted: Wed Sep 12, 2001 11:32 am
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
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