Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

loop indefinitely

francy77Mar 15 2012 — edited Apr 3 2012
Hi all,

I've invoked the following pl/sql script
SQL> declare val number:=10;
  2  begin
  3  loop
  4  val:=11;
  5  exit when val=10;
  6  end loop;
  7  end;
  8  /
Now i want to see that it is running, how i can do that? there are some dictionary view or else. Please help meeee!!!
and also how i can kill it?

Thanks
Francesco
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2012
Added on Mar 15 2012
12 comments
443 views