Re: set markup html on

"Roman Mirzaitov" <rmirzaitov_at_kt.kg> wrote in message news:apqcju$3vo2n$1_at_ID-127142.news.dfncis.de...
> 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.
> >
> >

I am using version 8.1.5.0.0 Maybe this is the problem? I will look into it and see what I can find out. Thanks for the time.

Kevin Received on Thu Oct 31 2002 - 06:36:41 CST