spool output of @script.sql

[antzzz]

I tried to do the following in sqlplus:

SQL> spool output.txt
SQL> @script.sql

<results of script.sql>
.
.
.

SQL> spool off

but when I check output.txt, it only contains the ff:

SQL>@script.sql

Appreciate any advise.

Thanks

 

[SantaMufasa]

Antzz,

It's difficult to get a definitive answer without knowing what might be happening within "script.sql". Is is too large to post? Also, is there a reason that the "spool output.txt" and "spool off" are not inside the script?

Mufasa
(aka Dave of Sandy, Utah, USA)
@ 22:28 (28Oct04) UTC (aka "GMT" and "Zulu"),
@ 15:28 (28Oct04) Mountain Time

 

[antzzz]

Actually, these are scripts that the vendor wants me to run to build various database objects, etc.

I received some errors while running some of those scripts and the vendor says I should have spooled the output while running them.

I believe some of them are quite large.

Since they are vendor scripts, we usually don't touch or play around with them.

 

[SantaMufasa]

Antzz,

Granted you don't want to modify the vendor scripts. But what you are telling me is very ambiguous: you tell me that "I received some errors while running some of those scripts," yet your spool file is empty. How do you account for that anomaly? If errors display on the screen while you are spooling, they will be in the spool file, right?

Mufasa
(aka Dave of Sandy, Utah, USA)
@ 07:12 (30Oct04) UTC (aka "GMT" and "Zulu"),
@ 00:12 (30Oct04) Mountain Time