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

From: <smfrank_at_my-deja.com>
Date: Fri, 11 Jun 1999 19:18:30 GMT
Message-ID: <7jrne0$nld$1@nnrp1.deja.com>

The easiest way to determine where a procedure gets hung up is to use DBMS_OUTPUT to put an output line on the screen...This is the easiest way to debug.

Good luck,
SF

In article <928904575.15279.0.pluto.d4ee154e_at_news.demon.nl>, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> look at v$open_cursor from a second session.
> You will need to get the sid for the first session
> by something like
> select sid, program from v$session
> where type = 'USER' and schemaname = '<your schema>'
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> Dogan Cibiceli wrote in message <375DB1F8.60D590EB_at_gwl.com>...
> >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
> >
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jun 11 1999 - 14:18:30 CDT