I'm currently working with a client that only grants me access to Oracle Packages (I'm not allowed to run SELECT queries on the database), so when I need specific data from the Database, the DBA creates a procedure inside a Package that return the information I asked for. So what I've doing so far is, creating SQL Queries in FixedQueryWithOutput mode and executing the command "CALL Package.Procedurename(Param1,Param2...,?)" and this returns whatever I need from the database.
I decided to deploy JTA JDBC custom action blocks to enhance DB performance, but I found out that the Basic Query action block doesn't work with the "CALL" statement. When I try to run a command like "CALL Package.Procedurename(Param1,Param2...,?)" I get an error like I if I was trying to run this command in a SQL Query set to FixedQuery mode.
Is there any workaround this?
MII Version: 12.1
Database: Oracle 10g