Re: set markup html on

Hi,

which version of SQL*Plus do you use?
AFAIR, MARKUP option exists since 8.1.6 and works fine on my site.

Best regards,

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com


"ksmith" <NoSpam_at_erieplating.com> wrote in message
news:urvp586rl4jac9_at_corp.supernews.com...


> Oracle 8.1.6.1  on RedHat linux 7.2

> Windows Nt Workstation client runing SQLPlus.

>

> I am trying to have an sql script output to a html file. After looking at

an


> example, I tried to do something really simple like so:

>

> SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON -

> HEAD '<TITLE>Department Report</TITLE> <STYLE type="text/css"> <!-- BODY

> {background: yellow}</STYLE>' -

> BODY 'TEXT="#FF00FF"' -

> TABLE 'WIDTH="50%" BORDER="5"'

>

> COLUMN WORKORDERNUMBER HEADING "WO NUMBER" ENTMAP OFF

> SPOOL C:/test.html

>

> select workordernumber from workorders where workordernumber > 520800

> /

>

> SPOOL OFF

>

> I expected to get something totally different than what I wanted. (I am

new


> to this and am just trying to learn.), however I was not expecting this

> error:

>

>  unknown SET option "MARKUP"

>

> I also tried SET MARKUP HTML ON from the sql prompt  without success.

> I looked at http://tahiti.oracle.com and found syntax for the clause and

> don't understand why this part of my statement wont work.

> Is there another parameter I must set  in order to use the SET MARKUP HTML

> ON to work?

>

> Thanks in advance for any help.

>

>