SQLcl unable to set spool to file

Question

In SQLcl setting spool to file gives error "SP2-0556: Invalid File Name". There are no whitespaces in file name, and the path is correct (folder C:\Temp does exist). Have tried;

spool load_data.sql
spool C:\Temp\load_data.sql
spool "C:\Temp\load_data.sql"

Using SQLcl 17.2.0 on Win10, OracleXE11. From sqlplus spool-ing works OK. How can I set SQLcl to spool to file?

Answer 1

There's a bug right now in sqlcl -- seems to be there up through version 17.3 This workaround appears to fix the problem in most o/ses

set encoding UTF-8
spool load_data.sql

... in windows try this ...

set encoding windows-1252