CODEWITHSUNDEEP
javasqloracle-database
simpleuser
simpleuser

Reputation: 55

Error executing sql query

I try to execute the following query using java.sql.PreparedStatement:

SELECT  NVL (tb.ddate, '2002-10-15')
FROM tb

But get this error:

java.sql.SQLException: ORA-01843: ¿¿¿¿ ¿¿ ¿¿¿

What is wrong?

Upvotes: 0

Views: 1742

Answers (1)

dani herrera
dani herrera

Reputation: 51665

The date is not in expected format.

See http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams122.htm

Or try:

SELECT  NVL (tb.ddate, to_date('2002-10-15', 'YYYY-MM-DD') )
FROM tb

Upvotes: 3

Related Questions