stored procudure java date problem

From: <onekilo_at_my-deja.com>
Date: Mon, 22 Nov 1999 15:53:53 GMT
Message-ID: <81boue$40i$1@nnrp1.deja.com>

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 - 09:53:53 CST