Home » SQL & PL/SQL » Client Tools » SP2-0310
SP2-0310 [message #313283] Fri, 11 April 2008 05:41 Go to next message
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
Re: SP2-0310 [message #313288 is a reply to message #313283] Fri, 11 April 2008 05:48 Go to previous messageGo to next message
ThomasG
Messages: 3189
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?
Re: SP2-0310 [message #313289 is a reply to message #313288] Fri, 11 April 2008 05:55 Go to previous messageGo to next message
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.
Re: SP2-0310 [message #313291 is a reply to message #313288] Fri, 11 April 2008 05:56 Go to previous messageGo to next message
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 ??

Re: SP2-0310 [message #313294 is a reply to message #313283] Fri, 11 April 2008 05:59 Go to previous message
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
Previous Topic: new tool
Next Topic: TOAD i don't know how to load .dat file
Goto Forum:
  


Current Time: Mon Dec 05 12:46:40 CST 2016

Total time taken to generate the page: 0.08650 seconds