Wishlist: Default SPOOL directory

[CTzen]

I know, I can control it by setting working directory for shortcut.

But, can we have as an option ?-)

Also, it would be nice to be able to set value from command window, something like

set spool_directory c:\tmp\

 

[Joachim Rupik]

Yes, it would be nice!

Joachim Rupik

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[RobertK]

is this available now (in 6.0.6) ?

 

[CTzen]

Robert,

it was added in version 7.0, here is excerpt from the what's new file:

The SET SPOOLDIRECTORY command can be used to specify the default location for SPOOL files. This only affects SPOOL commands where no absolute path is specified.

 

[Bernhard S]

Looks like there's a typo in the pl-sql-developer 7.1 help about this. There it says:
SET SPOOL*DIRECTORY [Directory]

THE "*" should be removed there. Should also be mentioned that when you have a path with blanks you can put the [Directory] between double quotes, the same as with spool filenames or path with blanks.

 

[Bernhard S]

This is still documented wrongly in the current 9.0 version as well!

 

[Marco Kalter]

Fixed for 10.0.