Re: PL/SQL Question : How to understand which statement Oracle is executing

From: J. G. Dutcher <DutcherJG_at_navair.navy.mil>
Date: Wed, 09 Jun 1999 09:31:39 -0800
Message-ID: <DutcherJG-0906990931390001@clhrd7.chinalake.navy.mil>

If speed isn't an issue, try adding some message to tell where you're at

example

message ('Just before update',acknowledge); message (' ') ;
clear_message;

not fancy but enough of theses scatterd throught the block should give you some indication of what is happening

In article <375DB1F8.60D590EB_at_gwl.com>, Dogan Cibiceli <dcib_at_gwl.com> wrote:

> Hi,
> This is rather a simple question. I have an anoymous pl/sql block and
> it is processing some temp tables. During its execution it seems, it
> stops at some point for some reason because I see no updates to the temp
> table. How can I understand where it is at during execution ? any bright
> ideas, any internal tables I can look at ? Thanks in adv.
>
> D

TIA Received on Wed Jun 09 1999 - 12:31:39 CDT