Simple select gives invalid argument

[Petros Amiridis]

I have a select * from MY_TABLE and MY_TABLE has a date column. This column is nullable.

When I run the query from TOracleDataSet in Delphi 2005 I get the error Invalid Argument, both during designtime and runtime. The same query runs fine in PL/SQL Developer or other tools.

If a certain row has a corrupted date value, how can I spot it?

Delphi 2005, latest DOA

 

[Marco Kalter]

Maybe you can run this query in a TOracleQuery, fetch all records until you get this error, and display its key column values.

 

[Petros Amiridis]

Thanx!

It was an invalid Date value. I used your suggestion and discovered the problematic records.

 

[Marco Kalter]

Okay, thanks for the update.