Re: put_line: any way to have nonbuffered output?
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Wed, 05 Oct 2011 21:33:01 +0200
Message-ID: <4e8cb0b9$0$5038$ba620e4c_at_news.skynet.be>
geos wrote:
> put_line places data into buffer. this data is displayed as soon as pl/sql code is finished and
> control returns to invoking environment (eg. sqlplus). in some sense the display via put_line is
> delayed compared to the moment of data availability.
>
> is there any other way in oracle, built-in or via third party methods/packages, that controls
> display from pl/sql code without using the "display buffer", ie. immediately after the data is
> available?
>
> I would greatly appreciate your help and explanations.
> thank you,
> geos
>
Date: Wed, 05 Oct 2011 21:33:01 +0200
Message-ID: <4e8cb0b9$0$5038$ba620e4c_at_news.skynet.be>
geos wrote:
> put_line places data into buffer. this data is displayed as soon as pl/sql code is finished and
> control returns to invoking environment (eg. sqlplus). in some sense the display via put_line is
> delayed compared to the moment of data availability.
>
> is there any other way in oracle, built-in or via third party methods/packages, that controls
> display from pl/sql code without using the "display buffer", ie. immediately after the data is
> available?
>
> I would greatly appreciate your help and explanations.
> thank you,
> geos
>
There used to be something called dbms_pipe. Received on Wed Oct 05 2011 - 14:33:01 CDT