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.
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