DA0003 error

[system]

Hi All,
I am facing DA0003 error .

Details:
Error during SQL execution:(DA0003)

Exception:DBD,ORA-01858: a non-numeric character was found where a numeric was expectedState: N/A.

Let me know how we can fix this errror.

Thanks In advance,
James Charlie

---

jamescharlie (BOB member since 2010-12-21)

[system]

Welcome to B:bob:B!

Can you post the SQL statement that DeskI generates and fires against the database?

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Something similar was discussed on BOB. Please go through that discussion I think is help for you?

120×120 10.4 KB

Hi, Have a time stored in an Oracle Database (9i) as number(5,2). Normally I’d use the to_date function to specify what I want eg to_date(table.column, ‘HH24:MM’). However, when I do this I get the following error : Error during SQL execution: (DA0003) Details: Exception: DBD, ORA-01840: input value not long enough for date format State: N/A I suspect it’s something to do with the decimal place but have tried a few things unsuccessfully. Anyone any ideas? Thanks. Steve Steve…

---

suhas.BOBI (BOB member since 2010-12-09)