Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with SPOOL OUT function (7.3)
"Andre de Wit" <a.de.wit_at_eindhoven.nl> wrote in message
news:3B8F2D1E.92EEFF50_at_eindhoven.nl...
> I want to print a report, but the SPOOL OUT has no effect.
> Spool c:\temp\opp works fine (see code below)
> But at the end SPOOL OUT (see code below) send nothing to
> the (existing, default) printer
>
> clear screen
> accept wijkcode number -
> Prompt "Geef wijkcode: "
> spool c:\temp\opp
> set linesize 70
> set pagesize 60
> set newpage 1
> ttitle "OVERZICHT|Oppervlaktecontrole"
> column Som_Nieuw heading "Opp.|onderdeel"
> column Som_Nieuw FORMAT 9999990
> column Som_Oud heading "Opp.|element"
> column Som_Oud FORMAT 9999990
> column Totaal heading Opp.|totaal
> column Totaal FORMAT 9999990
> column Opp_Voorz heading Opp.|voorz.
> column Opp_Voorz FORMAT 9999990
> column IDVZ heading IDVZ|waarde
> column wijk heading Wijk|code
> column verschil heading procent.|verschil
> select voorz.wijkcode WIJK, voorz.idvz "IDVZ",
> nvl(sum(voorz.opp),0) Opp_Voorz, nvl(sum(elem.opp),0)
> Som_Oud, nvl(sum(ond.opp),0) Som_Nieuw,
> nvl(sum(elem.opp),0)+nvl(sum(ond.opp),0) Totaal,
> nvl(trunc(abs((100-(sum(elem.opp)+sum(ond.opp)) / (voorz.opp
>
> / 100))) + 0.5),0) verschil
> from geo.att_voorziening voorz,
> ( select b.idvz,sum(b.opp) opp
> from geo.att_voorziening voorz, geo.att_element b
> where voorz.idvz=b.idvz
> group by b.idvz) elem,
> (select c.idvz,sum(c.opp) opp
> from geo.att_voorziening voorz, geo.att_onderdeel c
> where voorz.idvz=c.idvz
> group by c.idvz) ond
> where voorz.idvz=elem.idvz(+)
> and voorz.idvz=ond.idvz(+)
> and voorz.wijkcode='&Wijkcode'
> group by voorz.wijkcode, voorz.idvz, voorz.opp
> having trunc(abs((100-(sum(elem.opp)+sum(ond.opp)) /
> (voorz.opp / 100))) + 0.5) > 4;
> spool out
>
> with regards.
>
> André
>
I have a feeling it *might* work, when the printer is defined as LPT1,
however I have the same experience as you, and I never really tried to get
it working.
7.3 has been desupped, though given the number of 7.3 installations in the
Netherlands, (and some government departments still using 7.3.2 (supported
by Oracle)), that news might not have reached everyone.
I'm making this remark, because for 90 percent of my time, I still have to
deal with 7.3 installations, and this is quite frustrating.
Hth,
Sybrand Bakker, Senior Oracle DBA, Amsterdam Received on Fri Aug 31 2001 - 01:42:52 CDT