OCI has fetched truncated data
Posted: Mon Dec 10, 2007 12:54 am
Hi,
I know it has been posted in the past. These posts helped me to solve my problem.
we are using Oracle database as a source, one column data type in Oracle table is "date". when we are trying to retrieve data from this date column by using OCI stage, it is giving error "OCI has fetched truncated data". But we declared datatype for this date column is "char(10)" in OCI stage. It is working in pre-prod environment but it is giving error in prod environment. After changed the datatype from char(10) to Timestamp, it is working in prod environment also.
why it is still working in pre-prod environment?
we verified database level date formate settings in prod and pre-prod, both are same.
we verified datastage level NLS property tab is disabled in prod and pre-prod.
please help me regarding the same.
Thanks
I know it has been posted in the past. These posts helped me to solve my problem.
we are using Oracle database as a source, one column data type in Oracle table is "date". when we are trying to retrieve data from this date column by using OCI stage, it is giving error "OCI has fetched truncated data". But we declared datatype for this date column is "char(10)" in OCI stage. It is working in pre-prod environment but it is giving error in prod environment. After changed the datatype from char(10) to Timestamp, it is working in prod environment also.
why it is still working in pre-prod environment?
we verified database level date formate settings in prod and pre-prod, both are same.
we verified datastage level NLS property tab is disabled in prod and pre-prod.
please help me regarding the same.
Thanks