I have not used iBATIS with Oracle, but with SQL Server, you don't need the
(?,?). iBATIS caches a derive parameters call, so it knows the number of
parameters and matches them with your parameter map.
Try
<procedure id="Process" parameterMap="Accesses">
dba_lib_package_a.update_Process
</procedure>
Mike
On Mon, Jul 20, 2009 at 5:16 AM, Andrew P Chan <[email protected]>wrote:
>
> Hi guy,
>
> I would love to use the iBatis to call a store procedure function from the
> database server which is in the package. The configuration is listed below:
>
> <parameterMap id="Accesses" class="System.Hashtable">
> <parameter property="code" dbType="VARCHAR2">
> <parameter property="message" dbType="VARCHAR2">
> </parameterMap>
> .....
> ...
> ..
> <procedure id="Process" parameterMap="Accesses">
> dba_lib_package_a.update_Process(?, ?)
> </procedure>
>
> What's wrong with my configuration. I've got the Oracle Exception.
> Can anyone pls verify the correct way to invoke a store procedure?
>
> Many Thanks
>
> --
> View this message in context:
> http://www.nabble.com/Calling-Oracle-StoreProcedure-FUNCTION-tp24567140p24567140.html
> Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
