Re: "ORA-01843: not a valid month"

Ok, now with "to_date" it works great ! (now it seems so simple...) I was in trouble because SQL+ does an implicit cast, and JDBC does not.

Thank you very much for your help.
Jerome Poirier

Jerome Poirier <jerome.poirier_at_lip6.fr> a écrit dans le message : CjS_4.1354$qY.2729009_at_nnrp4.proxad.net...
> 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