You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by "ivan.bogouchev" <iv...@sgcib.com> on 2009/07/17 17:08:54 UTC

Cannot execute stored procedure in batch mode after upgrade to 2.3.4.726

Hello,

Recently we upgraded to ibatis-sqlmap-2.3.4.726 and since have problems
executing stored procedures in batch mode.

The error is : ORA-00900: invalid SQL statement .

Is it a known issue or some problem with our code?

Here is the relevant code:

<parameterMap id="ParamMap" class="map">
    <parameter property="param" jdbcType="BIGINT" javaType="java.lang.Long"
mode="IN"/>
</parameterMap>

<procedure id="myProc" parameterMap="ParamMap">
    {call MyProc(?)}
</procedure>

SqlMapExecutor executor ...

executor.startBatch();
executor.update("myProc", paramMap1);
executor.update("myProc", paramMap2);
executor.executeBatch();


Thanks in advance.

-- 
View this message in context: http://www.nabble.com/Cannot-execute-stored-procedure-in-batch-mode-after-upgrade-to-2.3.4.726-tp24536324p24536324.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org

Re: Cannot execute stored procedure in batch mode after upgrade to 2.3.4.726

Posted by blmmz <bg...@hotmail.com>.
Hi, anybody got any ideas?

I encountered the same problem.



ivan.bogouchev wrote:
> 
> Hello,
> 
> Recently we upgraded to ibatis-sqlmap-2.3.4.726 and since have problems
> executing stored procedures in batch mode.
> 
> The error is : ORA-00900: invalid SQL statement .
> 
> Is it a known issue or some problem with our code?
> 
> Here is the relevant code:
> 
> <parameterMap id="ParamMap" class="map">
>     <parameter property="param" jdbcType="BIGINT"
> javaType="java.lang.Long" mode="IN"/>
> </parameterMap>
> 
> <procedure id="myProc" parameterMap="ParamMap">
>     {call MyProc(?)}
> </procedure>
> 
> SqlMapExecutor executor ...
> 
> executor.startBatch();
> executor.update("myProc", paramMap1);
> executor.update("myProc", paramMap2);
> executor.executeBatch();
> 
> 
> Thanks in advance.
> 
> 

-- 
View this message in context: http://www.nabble.com/Cannot-execute-stored-procedure-in-batch-mode-after-upgrade-to-2.3.4.726-tp24536324p26007826.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org