Debug parameter error

Debug parameter error

Postby 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
Posts: 5
Joined: Fri 27 Mar 2009 15:14

Postby 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.
Devart Team
Posts: 476
Joined: Fri 29 Oct 2004 09:25

Postby capetto » Mon 30 Mar 2009 07:36

Thank you very much.
Posts: 5
Joined: Fri 27 Mar 2009 15:14

Return to dbForge for Oracle