[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-java
Subject:    Regarding MySql Functions
From:       "Thirumaran" <thirumaran () roomsnet ! com>
Date:       2004-04-14 8:16:08
Message-ID: 000401c421f8$be584b40$49ff7893 () RoomsNet ! com
[Download RAW message or body]


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 ?.
 
 
Regards,
 Thirumaran.


[prev in list] [next in list] [prev in thread] [next in thread]