Skip to Content

Error while inserting Negative values in Oracle database : Proxy to JDBC scenario

Hello,

Am working on a Proxy to JDBC scenario.

The interface works fine , but the issue is am not able to insert any negative values into the database. For example the quantity field = - 115.9, its failing in PI with the below error.

Error when executing statement for table/stored proc. 'TABLENAME' (structure 'StatementName'): java.sql.SQLSyntaxErrorException: ORA-00936: missing expression.

Please help with inputs .

Thanks,

Zameera.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 16, 2017 at 05:33 PM

    Resolved. Quantity field changed to TYPE FLTP.

    Add comment
    10|10000 characters needed characters exceeded