I am facing an issue in my workspace in Oracle Fusion Middleware Jdeveloper ( Version: 11.1.1.7.2).
In our code flow we are preparing SQL statement to call plsql packages and trying to execute it from java.
Example: private static final String SQL_GET_RULES =
"{call csr_rules_pvt.get_scheduler_rules( " +
" p_api_version => 1.0" +
", p_init_msg_list => fnd_api.g_true" +
", x_return_status => :1" +
", x_msg_count => :2" +
", x_msg_data => :3" +
", p_appl_id => :4" +
", p_resp_id => :5" +
", p_user_id => :6" +
", p_res_tbl => :7" +
", x_res_rules_tbl => :8" +
");}";
Whenever we try to execute this query im getting an exception saying java.sql.SQLException: ORA-00900: invalid SQL statement.
I tried to execute the same in Sql developer and query seems to be fine.
I tried to modify the query with Begin , End instead of Call then it seems to resolve the issue. But we have so many number of queries in our flow and it will be difficult to modify each and every query.
Do we have to add any libraries or jars to fix this issue? Or do we have any other way to fix this. Please help.