Line 689: select (SYSDATE- START_TIME) into lv_process_time from dual;
685: EXIT;
686:
687: ELSE
688: 689: select (SYSDATE- START_TIME) into lv_process_time from dual; 690:
691: IF lv_process_time > p_timeout/1440.0 THEN Raise EX_PROCESS_TIME_OUT; END IF;
692:
693: DBMS_LOCK.SLEEP( 5);
Line 700: select (SYSDATE- START_TIME) into lv_process_time from dual;
696:
697: ELSE
698: -- ============= Check the execution time ==============
699: 700: select (SYSDATE- START_TIME) into lv_process_time from dual; 701:
702: IF lv_process_time > p_timeout/1440.0 THEN Raise EX_PROCESS_TIME_OUT; END IF;
703:
704: DBMS_LOCK.SLEEP( 5);