Home » Developer & Programmer » Reports & Discoverer » Ora-01858 a non numeric character.......
Ora-01858 a non numeric character....... [message #389906] Wed, 04 March 2009 01:06 Go to next message
Derek N
Messages: 80
Registered: September 2002
Member
We have been running a report that worked for months. Today when running the same report (no changes done to report) we get an ORA-01858 A non-numeric character was found where a numeric was expected.

The only difference is that the user has got a new PC. Could this be a data error. Or has a date in the format DD-MON-RRRR has got to be set in the regedit file on the pc?

Thanks
Re: Ora-01858 a non numeric character....... [message #389907 is a reply to message #389906] Wed, 04 March 2009 01:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-01858: a non-numeric character was found where a numeric was expected
 *Cause: The input data to be converted using a date format model was
  incorrect.  The input data did not contain a number where a number was
  required by the format model.
 *Action:  Fix the input data or the date format model to make sure the
  elements match in number and type.  Then retry the operation.

Regards
Michel
Re: Ora-01858 a non numeric character....... [message #389908 is a reply to message #389906] Wed, 04 March 2009 01:17 Go to previous messageGo to next message
Derek N
Messages: 80
Registered: September 2002
Member
Hi Michael

Can I rule out the possibility that the setup on the new PC could also be the cause of this error.

Thanks
Re: Ora-01858 a non numeric character....... [message #389913 is a reply to message #389908] Wed, 04 March 2009 01:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes if the new PC is not configured for the usual territory and/or language.

Regards
Michel
Re: Ora-01858 a non numeric character....... [message #390005 is a reply to message #389906] Wed, 04 March 2009 09:12 Go to previous messageGo to next message
Derek N
Messages: 80
Registered: September 2002
Member
I have found that on the database that this client is using, the nls_date_fromat is set as 'RRRRMMDD'. The report was doing a to_date of a field with a format mask of 'DD-MON-RRRR'.

I refreshed the test database from the clients site. The nls_date_format on the test database is 'DD-MON-RR'. Ran the same report and it works fine.

Could the nls_date_format throw out this error. Have now asked our dba to set the nls_date_format on the test database to 'RRRRMMDD' and would see what happens when I run the report.
Re: Ora-01858 a non numeric character....... [message #390012 is a reply to message #390005] Wed, 04 March 2009 10:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Could the nls_date_format throw out this error.

Yes.

Quote:
Have now asked our dba to set the nls_date_format on the test database to 'RRRRMMDD' and would see what happens when I run the report.

No, change your code so you NEVER use implicit/default format.

Regards
Michel
Re: Ora-01858 a non numeric character....... [message #390115 is a reply to message #390012] Thu, 05 March 2009 01:00 Go to previous messageGo to next message
Derek N
Messages: 80
Registered: September 2002
Member
Out of curiosity I changed the nls_date_format to 'RRRRMMDD' on our test database and the report still works fine.

The user had a new pc installed and am now wondering if there are any parameters that needs to be set in the regedit file. Perhaps these parameters are missing and causing the error.
Re: Ora-01858 a non numeric character....... [message #390119 is a reply to message #390115] Thu, 05 March 2009 01:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check HKLM\Software\Oracle\Home...

Regards
Michel
Re: Ora-01858 a non numeric character....... [message #390199 is a reply to message #389906] Thu, 05 March 2009 07:18 Go to previous message
Derek N
Messages: 80
Registered: September 2002
Member
Thanks Michel. Report now works fine. Smile Smile
Previous Topic: Reports 10g Issues
Next Topic: How to 'Group'
Goto Forum:
  


Current Time: Sun Dec 04 19:01:54 CST 2016

Total time taken to generate the page: 0.04540 seconds