Skip to Content
0
Feb 15, 2017 at 05:27 PM

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

62 Views

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.