"ksmith" <NoSpam_at_erieplating.com> wrote in message
news:us291t49q6f948_at_corp.supernews.com...
> "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
This is exactly the problem. Set markup ... was introduced in version 8.1.6.
I'm afraid your original post rather led me to assume that you were using
8.1.6 (since that was the version number you quoted) though rereading it I
see that you only gave the server version number. Anyway an upgrade of the
client should give you what you need.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Thu Oct 31 2002 - 07:32:59 CST
