Re: put_line: any way to have nonbuffered output?
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Thu, 06 Oct 2011 00:37:07 +0200
Message-ID: <4e8cdbde$0$5039$ba620e4c_at_news.skynet.be>
geos wrote:
> Gerard H. Pille wrote:
>> There used to be something called dbms_pipe.
>
> yes, but his is what I wanted to do (modified example from Feuerstein/Pribyl book, page 111:
> http://tinyurl.com/6funmrc)
>
> session 1: http://geos2005.republika.pl/sesja1.sql
> session 2: http://geos2005.republika.pl/sesja2.sql
>
> pl/sql (2) can "communicate" with pl/sql (1) but the latter one can't display until it is finished.
>
> thanks,
> geos
Date: Thu, 06 Oct 2011 00:37:07 +0200
Message-ID: <4e8cdbde$0$5039$ba620e4c_at_news.skynet.be>
geos wrote:
> Gerard H. Pille wrote:
>> There used to be something called dbms_pipe.
>
> yes, but his is what I wanted to do (modified example from Feuerstein/Pribyl book, page 111:
> http://tinyurl.com/6funmrc)
>
> session 1: http://geos2005.republika.pl/sesja1.sql
> session 2: http://geos2005.republika.pl/sesja2.sql
>
> pl/sql (2) can "communicate" with pl/sql (1) but the latter one can't display until it is finished.
>
> thanks,
> geos
The reading side of dbms_pipe should be handled by a PRO*C or Java program, and spool output immediately. Received on Wed Oct 05 2011 - 17:37:07 CDT