I have an SQL Query that I'm running from Microsoft Excel to extract data from an Oracle database. I have successfully run this query on 2 computers, however, for some reason, when I run this query on my lap top, I get an ORA-01858: a non-numeric character was found where a numberic is expected error. I have isolated the problem, and found that this line is causing the issue: AND c.START_TIME >= '1-JUN-2005'
AND c.START_TIME < '7-MAY-2006'

If I remove these lines, the query will run on my lap top.

I suspect there is a date format setting that is mis-aligned on this computer, but I can't for the life of me find that setting. My system settings (Windows XP) for long and short date formats are the same on all computers, as are the date settings in MS Excel. I am running Version of the Oracle ODBC driver on all machines as well.

Does anyone have any idea what setting might be messed up on this computer?

Thanks for your help.

Who is Participating?
GGuzdziolConnect With a Mentor Commented:
I suppose this will help:

Ora-01858 error can occur if Left-Value does not match Righ-Value when comparing. I agree with GGuzdziol solution. If not, then please paste the DDL of the tables used in the query and some sample data.
atufaConnect With a Mentor Commented:
I had same error like Dave and finally I solved. ;)

The problem was regional settings when Oracle client was intalled. The NLS_LANG of server should be same at the client.

For this, check the NLS_LANG key from registry into
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup Zone:
SPLIT between GGuzdziol(16677871) and atufa(16869368)

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

Experts Exchange Cleanup Volunteer
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.