> 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.