Re: dbms_output(' ') does nothing?

From: Sean Stasica <v045101_at_procyon.stortek.com>
Date: Tue, 21 Jun 1994 17:01:16 GMT
Message-ID: <CrrBA5.9Gp_at_stortek.com>


Todd Helfter (tmh_at_staff.cc.purdue.edu) wrote:
> Keywords:
 

>Has anyone noticed a problem with the dbms_output.put_line(' ') statement
 

>I am having difficulty getting any whitespace printed at the beginning of a line
>of any blank lines at all.
 

> Oracle 7 on a IBM/risc6000
 

> All other output seems okay.

This is fairly consistent with the fact that message(' '); in forms does not work either (it just ignores it). What you may want to do is concatenate whitespace at the beginning of a line, such as:

 dbms_output.put_line(' '||var_name);

Although I would agree that ignoring a blank message in forms or PL/SQL is not a very standard implementation, one would think that a put(' ') followed by a put_line(var_name) would output the contents of var_name with a space in front...

I also noticed you use a put_line() instead of a put... I don't know if this is a typo on your part, but it sounded like you were using put() to print whitespace at the beginning of a line. put_line() immediately outputs the text, whereas put() will wait until a put_line() is received.

  • - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Sean_Stasica_at_stortek.com
  • - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Received on Tue Jun 21 1994 - 19:01:16 CEST

Original text of this message