> We are using iBATIS as a persistence layer running on top of DB2.
> We've ran into a problem executing stored procedure.
> 
> The following works:
> <procedure id="user.deleteById" parameterClass="DaoUserId">           
>               {call PERMIT.PERMIT_DELETE_USER_BY_ID_SP(#id#,
> #updateId#)} 
> </procedure>
> 
> But this does not:
> <procedure id="user.deleteById" parameterClass="DaoUserId">           
>               {call PERMIT_DELETE_USER_BY_ID_SP(#id#, #updateId#)} 
> </procedure>
> 
> The error reported is that stored procedure named
> PERMIT_DELETE_USER_BY_ID_SP cannot be found.
> 
> Basically we are forced to specify the schema name for the stored
> procedure. The schema name is set up in the config file and we do not
> have to specify it for any regular <insert>, <update>, <delete>
> elements.
> 
> Have anyone seen this problem and knows how to solve it? We have
> multiple schemas used by different developers, so hard coding it is
> not an option.
> 
> Thank you in advance. 

Reply via email to