Go to End      

Bug No. 898051
Filed 25-MAY-1999 Updated 24-JUL-2002
Product SQL*Plus Product Version 8.0.5
Platform Microsoft Windows (32-bit) Platform Version 4.0 SP3
Database Version 8.0.5 Affects Platforms Generic
Severity Minimal Loss of Service Status Development to Q/A
Base Bug N/A Fixed in Product Version 10.0.0

Problem statement:

SPOOL DIRECTORY/FILENAME WITH SPACE FAILS AS ILLEGAL 

 
 
*** 05/25/99 11:46 am *** 
Problem Description 
-------------------- 
Using sqlplus and wants to save file in a certain directory 
If the directory has a space in it then it fails 
- Illegal Spool FIle Name:....bad character :' ' 
this worked in sqlplus 33 
. 
Keywords 
--------- 
Spool directory file name space illegal sqlplus 
. 
Testcase location 
----------------- 
Not required 
. 
Testcase step-by-step instructions 
----------------------------------- 
Create a directory with a space in it 
start sqlplus 
enter Spool directory/filename 
system returns above error 
. 
Generic/Port-specific findings 
----------------------------- 
Tested 8.0.5 
. 
Rep?   Platform   Client   Client Ver.   RDBMS Ver. 
----   --------   ------   -----------   ---------- 
Y      SUN         NT        8.0.4          7.3.4 
Y      SUN         NT        8.0.4          8.0.4 
Y      SUN         NT        8.0.5          7.3.4 
Y      SUN        SUN        8.0.4          8.0.4 
N      SUN         NT        3.3.4          7.3.4 
. 
Available workarounds 
---------------------- 
None 
. 
Related Bugs 
-------------- 
None 
. 
*** 07/24/02 09:12 pm *** (CHG: Asg->NEW OWNER) 
*** 07/24/02 09:25 pm *** (CHG: Sta->80) 
*** 07/24/02 09:25 pm *** (CHG: Fixed->10.0.0) 
*** 07/24/02 09:25 pm *** 
Fixed for 10.0.0 
On Windows platforms client will be able to spool into 
directory/filename with spaces in it 
*** 07/24/02 09:53 pm *** (CHG: Sta->11) 
*** 07/24/02 09:53 pm *** 
Is there a specific transaction that this problem is fixed 
in? If so, can you update this bug with the details please? 
Can this be backported to earlier release...etc....? 
*** 07/24/02 10:21 pm *** 
This fix was made as a part of spool append feature 
Can not be backported because new file name validation 
function uses backward compatibility check as per 
functional spec 
. 
TRANSACTION:  asouleim_spool_append 
PRODUCT:      sqlplus 
BRANCH:       asouleim_spool_append 
BASE LABEL:   SQLPLUS_MAIN_SOLARIS_020610 
*** 07/24/02 10:35 pm *** (CHG: Sta->80) 
*** 07/24/02 10:35 pm *** (CHG: Fixed->10.0.0)
.