The directory name is created in script at run time. I need to handle the spaces in SPOOL.
Please suggest a way
Just place the path and file name in double quotes:
c:\>mkdir "with spaces"
c:\>sqlplus chris/chris@db
SQL*Plus: Release 12.1.0.2.0 Production on Mon Mar 21 16:36:23 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Mon Mar 21 2016 16:33:44 +00:00
Connected to:
Oracle Database 12c EE Extreme Perf Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics
and Real Application Testing options
SQL> spool "c:\with spaces\out.log"
SQL> select 'just quote it!' from dual;
'JUSTQUOTEIT!'
--------------
just quote it!
Elapsed: 00:00:00.33
SQL> spool off
SQL> exit
Disconnected from Oracle Database 12c EE Extreme Perf Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics
and Real Application Testing options
c:\>type "c:\with spaces\out.log"
SQL> select 'just quote it!' from dual;
'JUSTQUOTEIT!'
--------------
just quote it!
Elapsed: 00:00:00.33
SQL> spool off