Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Can't create spool file

461742Oct 21 2005 — edited Oct 24 2005
Hi,
I've problems in creating spool file. I've some PL-SQL scripts, running monthly with sqlplus on Windows 2000, that have always generated spool file using the statements "spool filename.log".
Two days ago, I run this scripts and I noticed that they didn't create the log file, but nothing has been changed.

I noticed that changing the script with "spool c:\filename.log" the spool file is correctly generated.

I run the script using sqlplus user/pwd@db @c:\script.sql and in the body of the script there is:
whenever oserror exit SQL.OSCODE rollback
whenever sqlerror exit SQL.SQLCODE rollback

spool faXXXXX_X.log

Set autocommit off timing on echo on feedback on termout on serveroutput on

set escape ^

DECLARE
...

Why "spool filename.log" suddenly stop to work? There is some enviroment variable who determine the default directory of spooled file?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 21 2005
Added on Oct 21 2005
5 comments
5,959 views