Hi..

I am using Mysql 5.0 and Connector/J 3.1.

I am trying to convert an oracle statement into mysql statement.

Oracle statement contains functions inside the script. eg : select fn_checkDates(joinDate,ConfDate) leaveDates from LEAVE_DATA

Since we can't use functions in mysql ( till now I suppose).. I am trying to use procedure with out parameter inside mysql script.

select fn_checkDates(joinDate,ConfDate,leaveDates) from LEAVE_DATA Here leaveDates is an output parameter. I don't know whether we can do this..

Any sugessions pls. I read in mysql documentation that Fuctions can't refer to tables. Have Mysql Team implemeted support to functions ?.