Oracle OCI Stage
Posted: Tue Jul 03, 2007 3:01 am
Hi,
We are using the 8.0.1 version.
We are facing problem while reading and writting from and to Oracle OCI stage.
Though we can view (view button) the data from the stage but when the job runs we get the following error:ORA-01036: illegal variable name/number.
But the same query runs fine from SQL prompt. The Query Type is: Custom SQL
The second problem we are facing is with the date data type when we use the same OCI stage.
What I have observed is while reading the query should read as "YY-MON-DD" and while writting to the stage it should always be as "DD-MON-YY", otherwise we get some other date in the target.
For example if I have 29-May-2007 in the source and I use "DD-MON-YY" to read it in the target I would get : 07-Jun-2029. I 'm not running any transformation on this column.
Its really tesing our patience.
Regards
Om
We are using the 8.0.1 version.
We are facing problem while reading and writting from and to Oracle OCI stage.
Though we can view (view button) the data from the stage but when the job runs we get the following error:ORA-01036: illegal variable name/number.
But the same query runs fine from SQL prompt. The Query Type is: Custom SQL
The second problem we are facing is with the date data type when we use the same OCI stage.
What I have observed is while reading the query should read as "YY-MON-DD" and while writting to the stage it should always be as "DD-MON-YY", otherwise we get some other date in the target.
For example if I have 29-May-2007 in the source and I use "DD-MON-YY" to read it in the target I would get : 07-Jun-2029. I 'm not running any transformation on this column.
Its really tesing our patience.
Regards
Om