-
how to execute this sql server function in oracle,pls help
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;
-
well what have you come up with so far
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|