Space in the path! [message #32086] |
Mon, 02 August 2004 04:19 |
Milly
Messages: 72 Registered: March 2004
|
Member |
|
|
Hi All!!
I have a problem when in my file.sql used for the spool there'e a space in the path....
How can I solve this problem?
Thanks!
|
|
|
Re: Space in the path! [message #32097 is a reply to message #32086] |
Mon, 02 August 2004 21:21 |
Jai Vrat Singh
Messages: 205 Registered: September 2002 Location: Singapore
|
Senior Member |
|
|
Even mine does not work. Whatever method i try , it gives error for space in file name.
As a workaround you can use
#!/bin/ksh
sqlplus user@dbsid/password > 'my file with space' <b><<STR
</b>
select sysdate from dual;
STR
I think it can work if we can change the SQLPLUS settings, rendering some other character as a separator. eg if we can set ~ as separator. Then we can issue the command as
SQL> spool~my file
SQL>
SQL> spool~off
So that ~ is now the separator and space (' ') is taken literally. Experts! is there any means to achieve this?
|
|
|
|
Re: Space in the path! [message #32099 is a reply to message #32097] |
Tue, 03 August 2004 00:32 |
Jai Vrat Singh
Messages: 205 Registered: September 2002 Location: Singapore
|
Senior Member |
|
|
This site has some problem with HTML tags. It has bug for if i put unix here cocument then it does not show the staring tag. I am trying to correct here.
#!/bin/ksh
sqlplus user@dbsid/password > 'my file with space' <<<b>STR</b>
select sysdate from dual;
STR
|
|
|