Re: Avoiding spooling to empty files

On Jan 30, 6:27 pm, CenturionX <darwinbaldr...@xxxxxxxxx> wrote:
Thanks Joel,

Actually it is very usefull.

I'll try to implement it.

The only inconvinient is that i'm migrating a lot of scripts that
worked fine (generated zero-lenght files when no data found).

So i'll still need the trick for Oracle.

Thanks.

set trimspool on

That causes SQL*Plus to 'trim' the trailing spaces, and it may just
fix your 'problem'.


David Fitzjarrell
.

Relevant Pages

  • Re: Avoiding spooling to empty files
    ... The only inconvinient is that i'm migrating a lot of scripts that ... worked fine (generated zero-lenght files when no data found). ...
    (comp.databases.oracle.misc)
  • Printer Script... what does this part do?
    ... We've been migrating our printers over to a new server recently and ... SET PRINTERS = NET.ENUMPRINTERCONNECTIONS ... scripts don't seem to be running properly. ...
    (microsoft.public.windows.server.scripting)
  • Re: Conditionally Mail If Script Returns Something
    ... On 2004-10-16, Buck Turgidson wrote: ... > My preference is to keep scripts to a minimum, since it is less to account ... > for when migrating to a new system. ... Just copy all your scripts. ...
    (comp.os.linux.misc)
  • Re: Help! windows scripting host
    ... ChrisR wrote: ... > I've got a large number of scripts for NT and now some of ... > the users are migrating to XP - Does XP still support this ... WinXP comes with WSH 5.6 ...
    (microsoft.public.windowsxp.security_admin)