 | |
put_line: any way to have nonbuffered output?
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: put_line: any way to have nonbuffered output? -
10-07-2011
, 12:01 PM
|
On Oct 6, 4:35*pm, "Gerard H. Pille" <g... (AT) skynet (DOT) be> wrote: Mark D Powell wrote: On Oct 6, 2:26 am, geos<g... (AT) nowhere (DOT) 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/B.../b14251/adfns_... Thanks. *I wonder how long I have been doing that. |
http://groups.google.com/group/comp....0cbe8adfc68e27
But that's ok, even some US presidents can't say "nuclear."
:-D
jg
--
@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/new...aims_ lawsuit
#12
| |||
| |||
|
|
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/B.../b14251/adfns_... Thanks. I wonder how long I have been doing that. At least since 2005: http://groups.google.com/group/comp....0cbe8adfc68e27 But that's ok, even some US presidents can't say "nuclear." :-D |
#13
| |||
| |||
|
|
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 quotedtext - - Show quoted text - Yes. *http://download.oracle.com/docs/cd/B.../b14251/adfns_... Thanks. *I wonder how long I have been doing that. At least since 2005: http://groups.google.com/group/comp....sc/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. |
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
--
@home.com is bogus.
http://twitter.com/#!/OfficialPhreshy/status/123427514809978881
#14
| |||
| |||
|
|
On Oct 7, 3:29*pm, "Gerard H. Pille" <g... (AT) skynet (DOT) 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/B.../b14251/adfns_... Thanks. *I wonder how long I have been doing that. At least since 2005: http://groups.google.com/group/comp....sc/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 -- @home.com is bogus.http://twitter.com/#!/OfficialPhreshy/status/123427514809978881- Hide quoted text - - Show quoted text - |
composed in Word to get the benfit of spellcheck then copied and
pasted my replies, but some how I still managed to make spelling and
obvious typo's. This isn't the worse.
HTH -- Mark D Powell --
#15
| |||
| |||
|
|
I swear I proof read what I post most of the time. For a while I even composed in Word to get the benfit of spellcheck then copied and pasted my replies, but some how I still managed to make spelling and obvious typo's. This isn't the worse. HTH -- Mark D Powell -- |
"always look on the bright side of life"
i agree with Joel
best regards
Kay
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.