DSXchange

And let me guess, user-defined sql? Or did the stage generate some for you? In either case, please post your sql. It is not user-defined SQL, the stage generate some for me; The date format is mm-dd-yyyy in oracle database The properties in ODBC enterprise stage are: * target - table=TBablexx - Wri...

What are the data types in the Oracle table? Is the date format correct for your Oracle instance? What is the SQL being executed (this is reported in the Oracle stage)? I use this oracle table CREATE TABLE TBablexx ( T_ID NUMBER(8,2), T_DATE DATE ) Three questions, one answer. Your problem is at be...

ray.wurlod wrote:What are the data types in the Oracle table? Is the date format correct for your Oracle instance? What is the SQL being executed (this is reported in the Oracle stage)?

I use this oracle table

CREATE TABLE TBablexx
(
T_ID NUMBER(8,2),
T_DATE DATE
)

You could use fixed length if your datas have the same length

XXXX
413862
ZZXXT|05157
ZZXX1|GN""FK""130183333
062120

Hi all, I am trying to insert data with a date field with ODBC Enterprise stage; my job looks like: sequencial file ------> tranformer -----> ODBC Enterprise 1,'2003-02-15' 2,'2001-12-02' I have this error: ODBC_Enterprise_102,0: [Oracle][ODBC]Numeric value out of range. ODBC_Enterprise_102,0: Failu...

Could you retrieve here one ligne from your file for example