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
<andrewnik820@...>
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-unsubscribe@...
For additional commands, e-mail: user-cs-help@...
--
Juan Pablo Araya
787 76 034
