You have to tell iBATIS that it's a proc, and set the statement type to
CALLABLE and set the parameter to an output parameter, as follows:
@Select(" ibatis3select(#{Currency*,mode=OUT*}) ")
*...@options(statementType = StatementType.CALLABLE)*
Integer selectACurrencyBatis3(String sCurrency );
Most procs will probably run without it, but for any proc specific
variables, like out parameters, you have to do this.
Clinton
On Wed, Mar 24, 2010 at 4:03 AM, Arpon <the_philosop...@mail.inet.hr> wrote:
>
> Does anyone have an example of calling stored procedures with IN and OUT
> parameters without IBatis Map files (by using Annotations).
> Sending parameter to procedure works well, but can't return parameter...
>
> I am using IBatis3 beta 10...
>
> Interface:
> @Select(" ibatis3select(#{Currency}) ")
> Integer selectACurrencyBatis3(String sCurrency );
>
> Some DAO:
> Integer ret = ((ACurrencyObjDuro)
> pomDuro).selectACurrencyBatis3(sCurrency);
>
> Cheers,
> Arpon
> --
> View this message in context:
> http://old.nabble.com/IBatis-3.0-beta-10-%2B-annotations-%2B-stored-procedures-tp28012821p28012821.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
> For additional commands, e-mail: user-java-h...@ibatis.apache.org
>
>
