DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: re: viewing loop counter

  1. #1
    Join Date
    Jan 2004
    Posts
    58

    re: viewing loop counter

    hi! Guys ,

    I am running a proc in which there is a loop

    for i in 1..100000 loop
    .....
    end loop;

    how do i monitor what "i" is
    how do I keep watching "i" to see what value it is at ...

    1) from sqlplus
    OR
    2) from OEM console
    thanks,
    harish

  2. #2
    Join Date
    Apr 2003
    Posts
    353
    for i in 1..1000000 loop

    v_count:=i;
    if (v_count,10000)=0 then
    update count_track set last_count=v_count; --temporary table to track
    --the counter.
    commit;
    end if;

    then select from that count_track table

  3. #3
    Join Date
    Apr 2003
    Posts
    353
    Sorry please add Mod function in the first if command.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width