This discussion is locked
3 Replies Latest reply: Jan 6, 2014 5:40 AM by BluShadow RSS

need help

f3665bb6-1b11-4d8f-ba83-befd00bfce5e Explorer
Currently Being Moderated

Hi all

 

i have a procedure how to chk the performance of this

 

PROCEDURE SP_GET_LAST_POSTED_DATE IS
    BEGIN
      SELECT MAX(ATMCHGCTL_APPLIED_UPTO_DATE)
        INTO W_LAST_POSTED_DATE
        FROM ATMCHGCTL
        WHERE ATMCHGCTL_ENTITY_NUM = W_ENTITY_NUM
        AND ATMCHGCTL_BRN_CODE = V_ACNTS_BRN_CODE
        AND ATMCHGCTL_INTERNAL_ACNUM = V_INTERNAL_ACNUM;

    END SP_GET_LAST_POSTED_DATE;

 

like this i have 5 more proc in a pkg

after executing it takes more time how to resolve

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points