Problems with JTA JDBC custom action blocks

Guilherme Portela Jul 20, 2012 6:16 AM

Currently Being Moderated

Hi,

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

Regards,

Guilherme Lopes

Problems with JTA JDBC custom action blocks

Michael Appleby Jul 24, 2012 9:24 PM (in response to Guilherme Portela)

Currently Being Moderated

Hi Guilherme,
I don't know what to suggest for resolving this, but I would request that you put in the SP and build for MII as well as for the underlying NWCE installation. MII 12.1 is now at SP 10 patch 1 with corresponding NWCE required updates.

Regards, Mike
Report Abuse

Like (0)
- Re: Problems with JTA JDBC custom action blocks
  
  Guilherme Portela Jul 25, 2012 6:42 PM (in response to Michael Appleby)
  
  Currently Being Moderated
  
  Hi Michael,
  
  Thanks for your answer, but I found out that the problem was with the Custom Action Block itself. Basic query doesn't support FixedQueryWithOutput which is necessary to execute Oracle procedures that return Dataset.
  
  Regards,
  
  Guilherme
  
  Report Abuse
  
  Like (0)

Go to original post