Posted on 2006-05-14
Last Modified: 2008-01-09
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.

Question by:dcmaslen
    LVL 14

    Accepted Solution

    I suppose this will help:

    AND c.START_TIME >= TO_DATE('01-JUN-2005', 'DD-MON-YYYY')
    AND c.START_TIME < TO_DATE('07-MAY-2006', 'DD-MON-YYYY')
    LVL 11

    Expert Comment

    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.

    Assisted Solution

    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
    LVL 22

    Expert Comment

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now