Invalid Argument to Decode Time

[Jens Fudickar]

I have an interesting Feature.

Select a table with three date-field by "select *" raises the following error message: "Ung

 

[Marco Kalter]

This exception indicates that there is a database column that contains an illegal date value. If you can isolate the record and column that causes the exception, you can use SQL*Plus to check if the time fraction of this date is correct:

select to_char(<date_column>, 'dd-mm-yyyy hh24:mi:ss')
from <date_table>
where rowid = <bad_rowid>

If it seems correct, try to do some math with it. For example add 1 hour:

select to_char(<date_column> + 1/24, 'dd-mm-yyyy hh24:mi:ss')
from <date_table>
where rowid = <bad_rowid>

You may find that SQL*Plus can display the date value correctly, but that Oracle can't do any calculations with it.

In either case, the record in the database is corrupt.

------------------
Marco Kalter
Allround Automations