Re: put_line: any way to have nonbuffered output?

From: geos <geos_at_nowhere.invalid>
Date: Wed, 05 Oct 2011 20:40:46 +0200
Message-ID: <j6i8bc$cns$2_at_news.task.gda.pl>



Mladen Gogala wrote:
> So, the answer to your question is no. You cannot asynchronously check
> the content of the line buffer because Oracle session can execute only a
> single SQL (or PL/SQL) unit at any given time. If you describe V$SESSION,
> you will see only the entries describing the current and the previous
> SQL.
> That wouldn't be possible, if there was a possibility to have 2 or more
> simultaneous statements that could be executed by the same session.

thanks for this expanded answer!

cheers,
geos Received on Wed Oct 05 2011 - 13:40:46 CDT

Original text of this message