Re: SPOOLing Problem in SQL*Plus

In article <1992Dec1.113320.28548_at_zeus.swindon.rtsg.mot.com>, longleye_at_aztec.Berkeley.EDU (Edward Longley) writes:
|> In article <1992Nov27.084818.16065_at_rz.uni-karlsruhe.de>,
|> rz34_at_rz.uni-karlsruhe.de (Schillinger) writes:
|> > We're running ORACLE v. 6.0.34.2.1 and SQL*Plus v. 3.0.11.1.1
|> > on a HP/UX 9000 Series 800.
|> >
|> > I've just noticed that when I have a login.sql file in the directory
|> > from wh...........
 

|> > So, the problem is not with the privileges in Unix (I *can* write in the
|> > directory). When I delete login.sql, I can spool just fine! By the way,
|> > in my login.sql is usually something like
|> >
|> > set pagesize
|> > set pause on
|> >
|>
|> Shouldn't your "set pagesize" line have a number at the end????
|> This may be causing your problem.
|>
|> Regards, ----- /
|> Ed / /
|> /____ _____/
Sorry, Ed, that was just a typo! (It should say "set pagesize 24".)

Actually, as I was informed by another netter, this is Bug # 69818 and there should be a patch for it. The problem is with "Set pause on". So, when I "Set pause off" again, spool works just fine. I haven't bothered to ask about the patch as we are planning to upgrade soon.

Karen Schillinger
rz34_at_hp850.rz.uni-karlsruhe.de Received on Wed Dec 02 1992 - 08:24:54 CET