Line 526: select (SYSDATE- START_TIME) into lv_process_time from dual;
522: EXIT;
523:
524: ELSE
525: 526: select (SYSDATE- START_TIME) into lv_process_time from dual; 527:
528: IF lv_process_time > p_timeout/1440.0 THEN Raise EX_PROCESS_TIME_OUT; END IF;
529:
530: DBMS_LOCK.SLEEP( 5);
Line 537: select (SYSDATE- START_TIME) into lv_process_time from dual;
533:
534: ELSE
535: -- ============= Check the execution time ==============
536: 537: select (SYSDATE- START_TIME) into lv_process_time from dual; 538:
539: IF lv_process_time > p_timeout/1440.0 THEN Raise EX_PROCESS_TIME_OUT; END IF;
540:
541: DBMS_LOCK.SLEEP( 5);