DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Cannot set -set markup html

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    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

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    What SQL*Plus release are you using? SET MARKUP setting is available only in newer releases...
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Jan 2001
    Posts
    642
    I am using the latest version of the sql *plus.


    JServer Release 8.1.7.0.0 - Production


    Badrinath

  4. #4
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    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 :


  5. #5
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width