Re: put_line: any way to have nonbuffered output?
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Sat, 08 Oct 2011 00:29:06 +0200
Message-ID: <4e8f7cfb$0$5034$ba620e4c_at_news.skynet.be>
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_thread/thread/e6c013a6cbe45873/bf0cbe8adfc68e27
>
> But that's ok, even some US presidents can't say "nuclear."
>
> :-D
Date: Sat, 08 Oct 2011 00:29:06 +0200
Message-ID: <4e8f7cfb$0$5034$ba620e4c_at_news.skynet.be>
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_thread/thread/e6c013a6cbe45873/bf0cbe8adfc68e27
>
> 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. Received on Fri Oct 07 2011 - 17:29:06 CDT