Debug parameter error

capetto · Post by **capetto** » Fri 27 Mar 2009 15:21

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

Duke · Post by **Duke** » Mon 30 Mar 2009 07:28

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.

capetto · Post by **capetto** » Mon 30 Mar 2009 07:36

Thank you very much.