Cannot set -set markup html

[badrinathn]

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

[jmodic]

What SQL*Plus release are you using? SET MARKUP setting is available only in newer releases...

[badrinathn]

I am using the latest version of the sql *plus.


JServer Release 8.1.7.0.0 - Production


Badrinath

[JChiappa]

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 :

[JChiappa]

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