3 Replies Latest reply: Jan 6, 2014 7:40 AM by BluShadow RSS

    need help

    1043556

      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