Re: SPOOLing Problem in SQL*Plus

From: Edward Longley <longleye_at_aztec.Berkeley.EDU>
Date: Tue, 1 Dec 1992 11:33:20 GMT
Message-ID: <1992Dec1.113320.28548_at_zeus.swindon.rtsg.mot.com>

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                                    /            /
                                             /____   _____/
Edward Longley                              /       /    /

Motorola Cellular Infrastructure Division /____ /____/ Swindon. England.
Tel. : 0793 545303
Mail : longleye_at_aztec.swindon.rtsg.mot.com

Weinberg's Second Law:

        If builders built buildings the way programmers wrote programs,
        then the first woodpecker that came along would destroy
        civilization.

Received on Tue Dec 01 1992 - 12:33:20 CET