Skip to Content
0

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

Feb 15, 2017 at 05:27 PM

25

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Feb 16, 2017 at 05:33 PM
0

Resolved. Quantity field changed to TYPE FLTP.

Share
10 |10000 characters needed characters left characters exceeded