Line 1710: dbms_lock.sleep(dbms_random.value(60,180));
1706: execute immediate v_sql into v_status using v_schema_id;
1707:
1708: -- if another workflow is running, sleep for 1 to 3 minutes
1709: IF (v_status = 'Running') THEN 1710: dbms_lock.sleep(dbms_random.value(60,180)); 1711: END IF;
1712: END LOOP;
1713:
1714: EXCEPTION