Hi ,
This is Ravindra, I am able to execute the below sql server function in sql server but not able to convert and use it in oracle

So any body please help..........................







FUNCTION ftblCheckForBalance

(

intHeadId IN INTEGER DEFAULT NULL,

dtFrom IN TIMESTAMP DEFAULT NULL

)

RETURN GLOBALPKG.RCT1

IS

REFCURSOR GLOBALPKG.RCT1;

BEGIN

OPEN REFCURSOR FOR

SELECT

AB_JLID, ABheadId, ABAmount

FROM

AccountBalance AB, HeadMasterLink, Loandet

WHERE

AB_JLId = LDId AND LD_LSId = HML_SMId AND HML_HMId =
ftblCheckForBalance.intHeadId AND ABheadID = HML_BAMId AND

ABDate in

(

SELECT

MAX(ABdate)

FROM

AccountBalance

WHERE

AB_JLId = AB.AB_JLId AND

ABHeadId = AB.ABheadId AND

ABdate < ftblCheckForBalance.dtFrom

GROUP BY

AB_JLID

)

AND ABdate < ftblCheckForBalance.dtFrom;

RETURN REFCURSOR;

END;