Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> SPOOLing Problem in SQL*Plus

SPOOLing Problem in SQL*Plus

From: Schillinger <rz34_at_rz.uni-karlsruhe.de>
Date: Fri, 27 Nov 1992 08:48:18 GMT
Message-ID: <1992Nov27.084818.16065@rz.uni-karlsruhe.de>

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 - 02:48:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US