SPOOLing Problem in SQL*Plus

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 which I call sqlplus, I can't spool!

To be more precise, in sqlplus, when I say,

> spool junk
> select * from tablename;

I get thrown out of sqlplus with:

Spooling error: No such file or directory Disconnected from ORACLE RDBMS V6.0.34.2.1, transaction processing option - Prod uction
PL/SQL V1.0.34.0.1 - Production

But the "junk.lst" file IS created and contains only

SQL> select * from leistung;

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

Is this behavior normal? If so, does it mean I have to delete login.sqli whenever I want to spool? Or is there another solution?

Thanks in advance!

Karen Schillinger
rz34_at_hp850.rz.uni-karlsruhe.de Received on Fri Nov 27 1992 - 09:48:18 CET