Forum Stats

  • 3,839,347 Users
  • 2,262,484 Discussions
  • 7,900,945 Comments

Discussions

SET MARKUP HTML fails

Syswizard
Syswizard Member Posts: 54
edited Mar 28, 2014 1:42PM in SQL & PL/SQL

Sorry to bring this up in this sub-forum, but the SQL-Plus forum is somewhat dead.

I am attempting to create an Excel file using HTML output.

However, SQL Plus constantly denies this statement:

line 8: SQLPLUS Command Skipped: set MARKUP HTML ON ENTMAP ON SPOOL ON PREFORMAT OFF

Apparently there are other settings needed to make this work.

Here is the entire script:

SET LINESIZE 4000

SET VERIFY   OFF

SET FEEDBACK OFF

SET PAGESIZE 99999

SET MARKUP HTML ON ENTMAP ON SPOOL ON PREFORMAT OFF

SET TERMOUT OFF ECHO OFF

-- SET MARKUP HTML ON TABLE ""

-- ENTMAP ON SPOOL ON PREFORMAT OFF

SPOOL C:\temp\test_xls.xls

SELECT    object_type ObjType   

,         SUBSTR( object_name, 1, 30 ) ObjectName

,         created        

,         last_ddl_time  

,         status        

FROM      user_objects

ORDER BY  1, 2

;

SPOOL OFF

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

SET MARKUP HTML OFF ENTMAP OFF SPOOL OFF PREFORMAT ON

SET LINESIZE 2000 VERIFY ON FEEDBACK ON PAGESIZE 60 TERMOUT ON

Answers

This discussion has been closed.