Hi All,
I wanted to convert some Java procedures to PL/SQL procedures due to performance issues. Is there any tool or inbuild utility in Oracle to do that or Do I need to manually re-write the logic?
Eg. this simple java code, if I want to convert to PL/SQL
private static final long calculateDays(Date dateEarly, Date dateLater) {
long lngNoOfDays = 0;
if (dateEarly.before(dateLater) || dateEarly.equals(dateLater)) {
lngNoOfDays = (dateLater.getTime() - dateEarly.getTime()) / (24 * 60 * 60 * 1000);
lngNoOfDays = lngNoOfDays + 1;
}
return lngNoOfDays;
}
Thanks.