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

[former_member372521]

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.

[former_member372521]

Resolved. Quantity field changed to TYPE FLTP.