how to execute this sql server function in oracle,pls help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: how to execute this sql server function in oracle,pls help

  1. #1
    Join Date
    Feb 2008
    Posts
    1

    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;

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    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
  •  



Click Here to Expand Forum to Full Width