Hi,

I am trying to insert a date field in Oracle via Pipline Pilot using the ODBC Insert Component, but I am always getting Error "[22008] ODBC Datetime field overflow".

I tried all kind of combinations of Date Formats to read and oracle's to_date() function in the Insert statement, such as

INSERT INTO Table (ID, Date)  VALUES (?, to_date(?,'DD/MM/YY'))

The dates are normal (>2005) so no BC dates.

[Q] I know it's not PP specific, but did some one come across the same problem and/or has a solution for it?

Server- System:

Oracle (11g 11.2.0.1.0),

Oracle instance: NLS_DATE_FORMAT = 'DD/MM/RR';

Client- System:

Win XP Professional

PP (Student Edition v6.1.5)

ODBC using Oracle native 11g client,

Thanks for any help

Johannes