Re: Oracle/SQL Question

Hi Eric,

Erik E. Bengtson wrote in message <6h0s43$pr3$1_at_winter.news.erols.com>...
>Lorrie,
>
> There is a great Graphical Oracle Database Browser called SQL*Pro.
>It allows you to run up to 10 SQL statements at the same time. ( It is a
>multithreaded application ). Each statement has it's own window. Each
>of these windows keep statistics, such as start time, time run so far, and
>end time. In the event you don't want to wait for the SQL statement to
>complete, you can cancel it with the touch of a button, without affecting
>any other running statements. When the statement is cancelled, you won't
>need to talk to your DBA for anything, because it is a clean cancel through
>Oracle's OCI API.

No one can clean cancel PL/SQL anonymous block through OCI API. This can be done only with pure SQL statements.

                                           Andrew Protasov