Skip to Content
author's profile photo Former Member
Former Member

Error on SQL command on the SAP MII after new installation - ORA-01722: invalid number

Hi Dear,

Here on the company we have two MII machines, one of them was installed on last week. We have the same application on both, the more old is working fine, but in the other machine the SQL queries are returning the error:

"com.sap.xmii.Illuminator.logging.LHException: com.sap.xmii.Illuminator.logging.LHException: java.sql.SQLException: ORA-01722: invalid number"

The SQL commands that we are using is sending a parameter between quotes, for exemplo: '98.6598'. But on the new environment this command is not working.

We already checked the internationalization server config, the same on both, the JVM too.

Anybody help me?

Thanks

Thiago Alves

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jul 27, 2012 at 03:03 PM

    Please try it without the quotes. In general, you should not need the quotes when you have numbers as the Values.

    Regards, Mike

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 30, 2012 at 05:35 PM

    Make sure the parameter is actually being populated with data before the SQL statement is executed.

    Also try and execute the SQL through an SQL tool like SQL developer from oracle or SQL Plus. This will validate your SQL query is valid.

    The quotes shouldn't matter Oracle should try and parse the string into a number if it's expecting a number. But removing the quotes wouldn't hurt and it would save some CPU cycles.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.