Re: put_line: any way to have nonbuffered output?
From: joel garry <joel-garry_at_home.com>
Date: Fri, 7 Oct 2011 10:01:45 -0700 (PDT)
Message-ID: <1a1fbfbb-aa73-44b3-bc79-ced35bb7fe4d_at_k10g2000vbn.googlegroups.com>
On Oct 7, 6:32 am, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
> On Oct 6, 4:35 pm, "Gerard H. Pille" <g..._at_skynet.be> wrote:
>
>
>
> > Mark D Powell wrote:
> > > On Oct 6, 2:26 am, geos<g..._at_nowhere.invalid> wrote:
> > >> Gerard H. Pille wrote:
> > >>>> 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.
>
> > >>> The reading side of dbms_pipe should be handled by a PRO*C or Java
> > >>> program, and spool output immediately.
>
> > >> do I understand right, that Pro*C means running the compiled output as
> > >> system program, not "inside" sqlplus as it is with anonymous block, and
> > >> to display the messages appropriate Pro*C "display function" should be
> > >> used?
>
> > >> thank you,
> > >> geos
>
> > > The dbms_pipe package, which should generally not be used in a RAC
> > > environment, is a mean to pass data between two Oracle sessions. The
> > > first session packs the data into the pipe and the second session
> > > unpacks the data from the pipe. Depending on your version you can
> > > find information on this Oracle provided package in the PL/SQL
> > > Packages and Types manual or Supplied PL/SQL Packages and Types
> > > Reference.
>
> > > If you used dbms_pipe instead of dbms_output a pro*C program could
> > > unpack the pipe concurrently to the first session filling the pipe and
> > > write out the output or insert it into a table independently of the
> > > first session transaction.
>
> > > An alternate approach that work in a RAC environment would be to
> > > substitute a logging routine for dbms_output where the logging routine
> > > was written as an anonymous transaction; however, you would have to
> > > read the results from a separate session so neither of these
> > > approaches may be of any use if what you want is for the current
> > > session to see the dbms_output as it is generated on the current
> > > session screen.
>
> > > HTH -- Mark D Powell --
>
> > "anonymous transaction" being "autonomous transaction" ?- Hide quoted text -
>
> > - Show quoted text -
>
> Yes. http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_...
>
> Thanks. I wonder how long I have been doing that.
>
Date: Fri, 7 Oct 2011 10:01:45 -0700 (PDT)
Message-ID: <1a1fbfbb-aa73-44b3-bc79-ced35bb7fe4d_at_k10g2000vbn.googlegroups.com>
On Oct 7, 6:32 am, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
> On Oct 6, 4:35 pm, "Gerard H. Pille" <g..._at_skynet.be> wrote:
>
>
>
> > Mark D Powell wrote:
> > > On Oct 6, 2:26 am, geos<g..._at_nowhere.invalid> wrote:
> > >> Gerard H. Pille wrote:
> > >>>> 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.
>
> > >>> The reading side of dbms_pipe should be handled by a PRO*C or Java
> > >>> program, and spool output immediately.
>
> > >> do I understand right, that Pro*C means running the compiled output as
> > >> system program, not "inside" sqlplus as it is with anonymous block, and
> > >> to display the messages appropriate Pro*C "display function" should be
> > >> used?
>
> > >> thank you,
> > >> geos
>
> > > The dbms_pipe package, which should generally not be used in a RAC
> > > environment, is a mean to pass data between two Oracle sessions. The
> > > first session packs the data into the pipe and the second session
> > > unpacks the data from the pipe. Depending on your version you can
> > > find information on this Oracle provided package in the PL/SQL
> > > Packages and Types manual or Supplied PL/SQL Packages and Types
> > > Reference.
>
> > > If you used dbms_pipe instead of dbms_output a pro*C program could
> > > unpack the pipe concurrently to the first session filling the pipe and
> > > write out the output or insert it into a table independently of the
> > > first session transaction.
>
> > > An alternate approach that work in a RAC environment would be to
> > > substitute a logging routine for dbms_output where the logging routine
> > > was written as an anonymous transaction; however, you would have to
> > > read the results from a separate session so neither of these
> > > approaches may be of any use if what you want is for the current
> > > session to see the dbms_output as it is generated on the current
> > > session screen.
>
> > > HTH -- Mark D Powell --
>
> > "anonymous transaction" being "autonomous transaction" ?- Hide quoted text -
>
> > - Show quoted text -
>
> Yes. http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_...
>
> Thanks. I wonder how long I have been doing that.
>
At least since 2005:
http://groups.google.com/group/comp.databases.oracle.misc/browse_thread/thread/e6c013a6cbe45873/bf0cbe8adfc68e27
But that's ok, even some US presidents can't say "nuclear."
:-D
jg
-- _at_home.com is bogus. You do know how to whistle, don't you? You just pull your lips apart and talk. http://www.maximumpc.com/article/news/oracle_pay_nearly_200_million_settle_false_claims_lawsuitReceived on Fri Oct 07 2011 - 12:01:45 CDT