OraFAQ Forum: Client Tools

Home » Other » Client Tools » SP2-0310

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SP2-0310 [message #313283]

Fri, 11 April 2008 05:41

sdhanuka
Messages: 173
Registered: March 2008

Senior Member

Hi i am getting this error when i run the following command


SQL> start C:\Documents and Settings\Administrator\Desktop\sql projects\reports_trial.sql
SP2-0310: unable to open file "C:\Documents.sql"

the reports_trial.sql contains:

set MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON
spool C:\Documents and Settings\Administrator\Desktop\learn_html_reports.html
select * from emp where rownum<10;
spool off

thanks

Report message to a moderator

Re: SP2-0310 [message #313288 is a reply to message #313283]

Fri, 11 April 2008 05:48

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

There doesn't seem to be a "C:\Documents.sql" file.

Hint :

Does a

notepad C:\Documents and Settings\Administrator\Desktop\sql projects\reports_trial.sql

from the command line work or does it not?

Report message to a moderator

Re: SP2-0310 [message #313289 is a reply to message #313288]

Fri, 11 April 2008 05:55

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

SQL*Plus is funny about spaces in paths.
Try putting " " around the path.

Report message to a moderator

Re: SP2-0310 [message #313291 is a reply to message #313288]

Fri, 11 April 2008 05:56

sdhanuka
Messages: 173
Registered: March 2008

Senior Member

yes u can open a new file from the CLI using


notepad C:\documents and settings\admin..\desktop\...

am not understanding why is this error being thrown??

should i change the file location and put it in some other file and then run ??

Report message to a moderator

Re: SP2-0310 [message #313294 is a reply to message #313283]

Fri, 11 April 2008 05:59

sdhanuka
Messages: 173
Registered: March 2008

Senior Member

Hi,

Thanks jrow..ya we have to put it in quotes


SQL> start "C:\Documents and Settings\Administrator\Desktop\sql projects\trial_r
eports.sql"
SP2-0333: Illegal spool file name: &quot;C:\Documents and Settings\Administrator
\Desktop\learn_html_reports.html&quot; (bad character: ' ')
<br>
<p>
<table border='1' width='90%' align='center' summary='Script output'>
<tr>
<th scope="col">
EMPNO
</th>
<th scope="col">
ENAME
</th>
<th scope="col">
JOB
</th>
<th scope="col">
MGR
</th>
<th scope="col">
HIREDATE
</th>
<th scope="col">
SAL
</th>
<th scope="col">
COMM
</th>
<th scope="col">
DEPTNO
</th>
</tr>
<tr>
<td align="right">
      7369
</td>
<td>
SMITH
</td>
<td>
CLERK
</td>
<td align="right">
      7902
</td>
<td>

to get a more formatted ouput we need to set other parameters right?.

Thanks all

Report message to a moderator

Previous Topic:	new tool
Next Topic:	TOAD i don't know how to load .dat file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 12 00:09:19 CST 2025