Not a Valid Month error from Oracle, no date in Query

108 Views Asked by At

I have received the most bizarre error I have encountered in a long time.

My query is:

select last_name
from COMPLETEDATA

I am querying on a view in Oracle. There are no dates in the view. The view works fine. The query above when entered into Oracle SQL Developer works fine.

When I run the page I get the following error:

[Macromedia][Oracle JDBC Driver][Oracle]ORA-01843: not a valid month

The datasource is correct, and is working in a query earlier in the page.

CF 2018 Oracle 11g

0

There are 0 best solutions below