HI EVERYBODY , IN THE FOLLOWING CODE YOU WILL FIND A DBMS.OUTPUT('MESSAGE '); INSIDE A LOOP
OPEN C1 ;
LOOP
FETCH C1 INTO V_EXCHANGE_CODE;
EXIT WHEN C1%NOTFOUND;
V_SERIAL := V_SERIAL + 1 ;
V_COMMIT_SERIAL := V_COMMIT_SERIAL + 1;
-----------------------------------

DEL_EXCHANGE_2006_DATA (V_EXCHANGE_CODE);
-----------------------------------
IF V_COMMIT_SERIAL = 50 THEN
PANEL := 'Step 1 : Please Wait... Deleting '||V_SERIAL||' Of '||V_COUNT
--------------------------------------------------------
DBMS_OUTPUT.PUT_LINE(panel);
---------------------------------------------------------
COMMIT;
V_COMMIT_SERIAL := 0 ;
END IF;
END LOOP;
CLOSE C1;
SO WHAT I WANT IS TO LET THIS MESSAGE APPEAR AT IT'S TIME
BECAUSE THIS MESSAGES APPEAR BUT AFTER THE END OF THE WHOLE PORCEDURE ,
IT APPEARS LIKE 100 MESSAGES AT THE SAME TIME
AND THIS IS NOT THE PURPOSE I MADE IT FOR

سلام لوسمحت ياخي ممكن تبين لي اش المشكله او ماذا تريد بتحديد

هل تريد مايدعى sleep في التكرار