Devart Forums

Hello. I'm using a trial version of OraDeveloper Studio with Oracle 9i.

When I try to debug a function with a date-type input parameter I receive this error:

Failed to execute :
ORA-01858 a non-numeric char was found where a numeric was expected.

What is the right format to insert a date in the parameter field?

Thank you

OraDeveloper Studio modifies NLS session parameters so that they match client OS settings.
But for DATE parameters you need to enter time to avoid this error. For example, 30.03.2009 00:00:00.00.
Another workaround is to enter change parameter type to VARCHAR and enter date only.
We'll change wrong conversion behavior in the next releases.

Thank you very much.