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)

.