SP2-0310 [message #313283] |
Fri, 11 April 2008 05:41 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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?
|
|
|
|
Re: SP2-0310 [message #313291 is a reply to message #313288] |
Fri, 11 April 2008 05:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
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: "C:\Documents and Settings\Administrator
\Desktop\learn_html_reports.html" (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
|
|
|