Re: put_line: any way to have nonbuffered output?
From: joel garry <joel-garry_at_home.com>
Date: Mon, 10 Oct 2011 10:21:27 -0700 (PDT)
Message-ID: <dc2f960d-4b3d-4ddc-85dd-3e3ac04cc035_at_l30g2000pro.googlegroups.com>
On Oct 7, 3:29 pm, "Gerard H. Pille" <g..._at_skynet.be> wrote:
> joel garry wrote:
> >>>> 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_thre...
>
> > But that's ok, even some US presidents can't say "nuclear."
>
> > :-D
>
> I just couldn't stand all those people laughing behind Mark's back.
Date: Mon, 10 Oct 2011 10:21:27 -0700 (PDT)
Message-ID: <dc2f960d-4b3d-4ddc-85dd-3e3ac04cc035_at_l30g2000pro.googlegroups.com>
On Oct 7, 3:29 pm, "Gerard H. Pille" <g..._at_skynet.be> wrote:
> joel garry wrote:
> >>>> 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_thre...
>
> > But that's ok, even some US presidents can't say "nuclear."
>
> > :-D
>
> I just couldn't stand all those people laughing behind Mark's back.
We're all laughing with him! Mark has been most helpful for decades in many fora, without descending into the nastiness that enveloped several authors. Everyone makes mistakes, and these are worldwide public ones, picayune but humorous. Thank you for everything Mark!
jg
-- _at_home.com is bogus. http://twitter.com/#!/OfficialPhreshy/status/123427514809978881Received on Mon Oct 10 2011 - 12:21:27 CDT