AFAIK functions inside packages need to be passed through the <procedure> tag. I Hope this can help, and sorry if it's not like I say.
Greetings! 2009/8/30 Andrew P Chan <andrewnik...@yahoo.com.hk> > > Hi Guys, > > I got stuck in another problem on calling the packaged function in Oracle. > > The Function need one parameter, and the function will return a boolean > type > data. > I am using the select statment to do with it like > > <select id ="IsOverdue" parameterClass="System.DateTime" > resultClass="Boolean"> > SELECT lib_bill.is_return_date_overdue(#value#) FROM DUAL > </select> > > The error is "Expression if of wrong type, statement ignore" (The Function > has a "Date" Signature) > Did I use the wrong type? > > Again, thx for help. > > Regards > Andrew Chan > > -- > View this message in context: > http://www.nabble.com/Call-of-Packaged-Oracle-Function-tp25217547p25217547.html > Sent from the iBATIS - User - Cs mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-cs-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-cs-h...@ibatis.apache.org > > -- Juan Pablo Araya 787 76 034
