Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: printing out of Pl/SQL

RE: printing out of Pl/SQL

From: Gogala, Mladen <>
Date: Fri, 27 Jun 2003 14:45:04 -0700
Message-ID: <>

The "spool out" command goes directly to the default printer, while "spool off"

stops spooling.
Mladen Gogala <FONT face=Arial
size=2>Oracle DBA Phone:(203) 459-6855

<FONT face=Tahoma

  size=2>-----Original Message-----From: Igor Neyman   [mailto:[EMAIL PROTECTED]Sent: Friday, June 27, 2003 5:30   PMTo: Multiple recipients of list ORACLE-LSubject: RE:   printing out of Pl/SQL   


  style="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt">Isn&#8217;t it: &#8220;spool   off&#8221;?

  style="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt">    


  style="COLOR: navy; FONT-SIZE: 10pt">Igor Neyman, OCP DBA

  style="COLOR: navy; FONT-SIZE: 10pt">[EMAIL PROTECTED]

  style="COLOR: navy; FONT-SIZE: 10pt"> 

  style="COLOR: navy; FONT-FAMILY: Arial; FONT-SIZE: 10pt"> 

  style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">-----Original   Message-----From:
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] <SPAN   style="FONT-WEIGHT: bold">On Behalf Of Jamadagni,   RajendraSent: Friday, June
  27, 2003 4:15 PMTo: Multiple
  recipients of list ORACLE-L<SPAN
  style="FONT-WEIGHT: bold">Subject: RE: printing out of   Pl/SQL
<FONT face="Times New Roman"


<FONT color=blue

  face="Courier New" size=2><SPAN
  style="COLOR: blue; FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt">oops ... it   should be <SPAN
  style="FONT-FAMILY: 'Courier New'">"spool   out"   

<FONT face="Times New Roman"


<FONT color=blue

  face="Courier New" size=2><SPAN
  style="COLOR: blue; FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt">Raj   

<FONT face="Courier New"


  style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt">-------------------------------------------------------------------------------- 


  style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt">Rajendra dot Jamadagni at   nospamespn dot com <SPAN
  style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 10pt">All Views expressed in   this email are strictly personal. <FONT face="Courier New"   size=2>QOTD: Any
  clod can have facts, having an opinion is an art !   

    <P class=MsoNormal
    style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 0.5in; MARGIN-RIGHT: 0in"><FONT     face=Tahoma size=2><SPAN
    style="FONT-FAMILY: Tahoma; FONT-SIZE: 10pt">-----Original     Message-----From:
    Jamadagni, Rajendra Sent:
    Friday, June 27, 2003 4:55 PM<SPAN
    style="FONT-WEIGHT: bold">To: Multiple recipients of list     ORACLE-LSubject: RE:
    printing out of Pl/SQL
    style="FONT-SIZE: 10pt">Are you using sqlplus?     <SPAN

    style="FONT-SIZE: 10pt">spool on <SPAN 
    style="FONT-SIZE: 10pt">... <SPAN 
    style="FONT-SIZE: 10pt">do some work <SPAN 
    style="FONT-SIZE: 10pt">spoo out 

    style="FONT-SIZE: 10pt">will that work for you? Just a guess ... it     might <SPAN
    style="FONT-SIZE: 10pt">Raj <SPAN
    style="FONT-SIZE: 10pt">-------------------------------------------------------------------------------- 
    Rajendra dot Jamadagni at
    nospamespn dot com <SPAN
    style="FONT-SIZE: 10pt">All Views expressed in this email are strictly     personal. QOTD:
    Any clod can have facts, having an opinion is an art !     <FONT face="Times New Roman"
    style="FONT-SIZE: 10pt">-----Original Message----- <FONT     size=2>From: Foelz.Frank [<A
    href="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]]     Sent: Friday, June 27, 2003
    11:40 AM To:
    Multiple recipients of list ORACLE-L <SPAN     style="FONT-SIZE: 10pt">Subject: AW: printing out of Pl/SQL     

    <FONT face="Times New Roman"
    style="FONT-SIZE: 10pt">sounds like some Unix/Linux     <SPAN
    style="FONT-SIZE: 10pt">I am on NT / Oracle 8.0.6     <SPAN
    style="FONT-SIZE: 10pt">> Frank <
    <FONT face="Times New Roman"
    style="FONT-SIZE: 10pt">>-----Ursprüngliche Nachricht-----     >Von: Gogala, Mladen [<A

    href="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]] 
    >Gesendet am: Freitag, 27. 
    Juni 2003 16:14 <SPAN 

    style="FONT-SIZE: 10pt">>An: Multiple recipients of list     ORACLE-L <SPAN
    style="FONT-SIZE: 10pt">>Betreff: RE: printing out of     Pl/SQL <SPAN
    style="FONT-SIZE: 10pt">> <SPAN
    style="FONT-SIZE: 10pt">>dd if=<your file>     of=/dev/lpt1 <SPAN
    style="FONT-SIZE: 10pt">> <SPAN
    style="FONT-SIZE: 10pt">>Mladen Gogala <FONT     size=2>>Oracle DBA <FONT
    size=2>>Phone:(203) 459-6855
    style="FONT-SIZE: 10pt">>Email:[EMAIL PROTECTED] <FONT     size=2>-- <SPAN
    style="FONT-SIZE: 10pt">Please see the official ORACLE-L FAQ: <A     href=""
    target=_blank> <SPAN     style="FONT-SIZE: 10pt">-- <SPAN
    style="FONT-SIZE: 10pt">Author: Foelz.Frank <FONT     size=2>  INET:
    style="FONT-SIZE: 10pt">Fat City Network Services    --     858-538-5051 <A href=""     target=_blank> <FONT     size=2>San Diego,
    California        -- Mailing list and web     hosting services <SPAN
    style="FONT-SIZE: 10pt">--------------------------------------------------------------------- 
    To REMOVE yourself from this
    mailing list, send an E-Mail message <SPAN     style="FONT-SIZE: 10pt">to: [EMAIL PROTECTED] (note EXACT spelling of     'ListGuru') and in <SPAN
    style="FONT-SIZE: 10pt">the message BODY, include a line containing: UNSUB     ORACLE-L (or
    the name of mailing list you want to be removed from).  You     may also send
    the HELP command for other information (like subscribing).    Received on Fri Jun 27 2003 - 16:45:04 CDT

Original text of this message