Re: debug looping in pl/sql

From: Karen Abgarian <karen.abgarian_at_fmr.com>
Date: Mon, 30 Aug 1999 17:00:34 -0400
Message-ID: <37CAF0F2.D5731210@fmr.com>

Hi, Nanda,

Profiles/resources may be used to terminate a session if it hangs.

dbms_output.put_line does not return anything because SQLPlus does dbms_output.get_lines when it regains control. Try to call get_lines directly. You cannot display that information, of course, but you should

be able to use it in conditions.

But it is easier to detect endloops loops at the time of their creation...

Best regards,
Karen Abgarian.

Nandakumar wrote:

> is there an easy way to find out if the PL/SQL code is looping?
> if dbms output mesg is handled inside loops, it waits for the code to
> complete execution for getting printed on screen!
>
> any suggestion're welcome.
> --
> Nandakumar
> (N.Kumar_at_rocketmail.com)
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Aug 30 1999 - 16:00:34 CDT