issue while using SQL Functions in Ready API SoapUI JDBC request
Do you know if its possible to use an existing SQL functions that already created in the oracle DB on JDBC request?
in my case im trying to create a validation test step that calling SQL function that returning TRUE/FALSE in case test passed accordingly.
once running the query in oracle DB directly im reciving an output
but once running same query on same DB connection using JDBC request its fails with the bellow log info
- 2018-08-28 11:03:46.670 - Error getting response; java.sql.SQLException: ORA-00911: invalid character
im using the connection driver: oracle.jdbc.driver.OracleDriver
i will be thankfull to get your advise :-)