Re: stored procudure java date problem

From: C. Ferguson <c_ferguson_at_rationalconcepts.com>
Date: Mon, 22 Nov 1999 22:35:22 GMT
Message-ID: <3839C52B.668E53BD@rationalconcepts.com>

did you try sending "to_date('01-JAN-2000', 'DD-MON-YYYY')" as the string?

onekilo_at_my-deja.com wrote:

> I am trying to send the date to a stored
> procedure but am running into problems. The
> stored procedure uses pl/sql to do an update to a
> oracle db. the Error I am getting is
>
> ORA-01858: a non-numeric character was found
> where a numeric was expected ORA-06512: at line 1
>
> I am sending the date as a string to the stored
> procedure since the oracle date format is
> "01-JAN-2000" and java.sql.Date is "2000-01-01".
> Have tried sending as a java.sql.Date also and
> get the same error. cheers.
> muzza
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Nov 22 1999 - 16:35:22 CST