Printable View
Hi,
I want to save my spool file into a html.When I checked out on the forum, It says that I have to
SQL> set markup html on spool on
However, I get the following error.
unknown SET option "markup"
Sam, says I have to install pl/sql tool kit.
How/from where do i install pl/sql tool kit
Badrinath
What SQL*Plus release are you using? SET MARKUP setting is available only in newer releases...
I am using the latest version of the sql *plus.
JServer Release 8.1.7.0.0 - Production
Badrinath
Your post show the version of the JSERVER - ** PLEASE ** be sure of using the last version of SQL*PLUS :
===>> SQL*Plus: Release 8.1.7.0.0 - Production on Tue Oct 16 10:43:08 2001
(c) Copyright 2000 Oracle Corporation. All rights reserved.
IF you are using the last version of sql*plus , so :
Your post show the version of the JSERVER - ** PLEASE ** be sure of using the last version of SQL*PLUS :
===>> SQL*Plus: Release 8.1.7.0.0 - Production on Tue Oct 16 10:43:08 2001
(c) Copyright 2000 Oracle Corporation. All rights reserved.
(I have a feeling that you are using an OLDER version of sql*plus against the 8i database).
IF you double-checked, and you are using the last version of sql*plus , type :
SQL>set sqlprompt '' [ENTER]
set markup HTML on spool on [ENTER]
spool c:\result.html[ENTER]
select * from dept;[ENTER]
exit[ENTER]
At the end of this, open the RESULT.HTML with any browser - I just did it and it works.
==>> OF course, you may want to disable the sql*plus formatting, line size, the nn lines text after the selected data, and so on. To know how to do it, check the sql*plus reference manual.
[]s
Chiappa
