Re: SQLPLUS variable length spooled records

Sorry for not reading your original post completely.

My VMS is both limited & rusty.

Can you set SYS$OUTPUT to be a file, and might trimout then have the desired effect?

Andy Bates wrote:

> Thanx Paul,
> tried that but it isn't supported in the older version of Oracle that I'm
> using.
> <sigh> bit of a pain huh!
>
> Paul Hennebry <paul_at_echofine.freeserve.co.uk> wrote in message
> news:37D1D6A2.664ACB56_at_echofine.freeserve.co.uk...
> > OK
> > From memory
> >
> > in sqlplus :
> > SET TRIMSPOOL ON
> >
> > This, I believe will get rid of trailing blanks in output spooled to a
> file.
> > Why this should differ from SET TRIMOUT ON for terminal output
> > is beyond me.
> >
> > Andy Bates wrote:
> >
> > > Let's try again!
> > >
> > > I'm spooling the results of a query where the records can vary from
> short
> > > (say 40 chars) to long (say 800 chars)
> > > I want the records in the file to be the same length as the query result
> for
> > > each row
> > > rather than blank padded to linesiz.
> > >
> > > This is using Oracle 7.1 on VMS. I've got a sqlplus manual from a later
> > > version which says that set trimspool on will do this, but it's not
> > > recognised by 7.1, which only has set trim but this doesn't affect
> spooled
> > > output.
> > >
> > > I can remember doing what I want to do in the past, but I no longer work
> at
> > > the company which had the sqlplus manuals!
> > >
> > > The solution to this would be appreciated, I need to find the right set
> of
> > > command for the older version that I'm using.
> > >
> > > Thanks in anticipation
> > > Andy.
> >
Received on Sun Sep 05 1999 - 03:02:46 CDT