Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Cannot close spool file
Leslie Carter <leslie.carter_at_lmco.com> wrote on article
<32E90BD1.167E_at_lmco.com>...
> Perhaps your output is going into well_id.lst.lst.
>
> I did:
>
> spool junk
> select sysdate from dual;
> spool off
>
> The output goes into the file, junk.lst.
>
As matter of fact, SQL*Plus only append an extention to your spool file if you don't specify one yourself.
So you would get a well_id.lst.lst if you specify such one.
Aram Meguerian aram_at_unisys.com.br ------------------------------------------------------------------- "There's no such a thing as a free lunch in the Universe." Lazarus Long Notebook's, Lazarus Long from Time enough for love, by Robert A. Heinlein -------------------------------------------------------------------I don't work at Unisys, it is just my Internet Provider, so don't blame it for anything I have just said.
![]() |
![]() |