"ORA-01843: not a valid month"

Hello,

Trying to use JDBC to access a database Oracle 8i, I have somme trouble with dates. The following SQL statement works great with SQL+, but an error occurs when send with JDBC : "insert into V1 values ('05/06/00', ...)", where V1 is a view :

Create or Replace View V1 as
Select d, ...
From T1;

Create Table T1 (

    d DATE,
    ...
);

The error is "ORA-01843: not a valid month".

Do you have an idea ?

Thank you
Jerome Poirier
jerome.poirier_at_lip6.fr Received on Mon Jun 05 2000 - 00:00:00 CDT