OraFAQ Forum: Reports & Discoverer » Ora-01858 a non numeric character.......

Home » Developer & Programmer » Reports & Discoverer » Ora-01858 a non numeric character.......

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Ora-01858 a non numeric character....... [message #389906]

Wed, 04 March 2009 01:06

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

Report message to a moderator

Re: Ora-01858 a non numeric character....... [message #389907 is a reply to message #389906]

Wed, 04 March 2009 01:07

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Ora-01858 a non numeric character....... [message #389908 is a reply to message #389906]

Wed, 04 March 2009 01:17

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

Report message to a moderator

Re: Ora-01858 a non numeric character....... [message #389913 is a reply to message #389908]

Wed, 04 March 2009 01:53

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes if the new PC is not configured for the usual territory and/or language.

Regards
Michel

Report message to a moderator

Re: Ora-01858 a non numeric character....... [message #390005 is a reply to message #389906]

Wed, 04 March 2009 09:12

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.

Report message to a moderator

Re: Ora-01858 a non numeric character....... [message #390012 is a reply to message #390005]

Wed, 04 March 2009 10:15

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Ora-01858 a non numeric character....... [message #390115 is a reply to message #390012]

Thu, 05 March 2009 01:00

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.

Report message to a moderator