Home » SQL & PL/SQL » Client Tools » set heading (10.2.0.3 ,Windows XP)
set heading [message #588033] Thu, 20 June 2013 06:22 Go to next message
FrancescoIt
Messages: 4
Registered: June 2013
Location: Italy
Junior Member
Hi,
i have a problem i've done a script sql with markup HTML ,but the version of oracle 9.2 give me a results different respetct a Oracle 10.2.0.3

The report don't show the header .
This code sql :


SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON -
HEAD "<TITLE>File Crif Istruttoria</TITLE> -
<STYLE type='text/css'> -
<!-- BODY {background: #FFFFC6} --> -
</STYLE>" -
BODY "TEXT='#000000'" -
TABLE "WIDTH='90%' BORDER='5'"
spool estrazione.htm
set HEADING ON
set pagesize 0
set feedback off
alter session set nls_date_format ='dd/mm/yyyy';
select *
from mytab
spool off
exit

Which is the error .
Thank's
Regards
Frankie
Re: set heading [message #588034 is a reply to message #588033] Thu, 20 June 2013 06:31 Go to previous messageGo to next message
Littlefoot
Messages: 19537
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
9.2 give me a results different respetct a Oracle 10.2.0.3

OK, but - what does that really mean? How does 9.2 output look like, and how 10.2 looks like? Which one do you prefer? None? Both? Only one (which one)?
Re: set heading [message #588036 is a reply to message #588034] Thu, 20 June 2013 06:37 Go to previous messageGo to next message
FrancescoIt
Messages: 4
Registered: June 2013
Location: Italy
Junior Member
this my output in version 9.2

CD_BCA DT_RIF CD_PRA_WEB CD_COD_FIS CD_P_IVA NM_COD_VAL CD_DES_VAL PC_DE CD DT_TAB_FNE DT_TAB_CAN CD_ CD_SOG NM_OPE
10680 14/03/2012 0041483995 03731700377 00655201200 1331 Bilanci: l¿impresa non è valutabile per incongruenze nei dati di bilancio UN 31/12/9999 GLM 0020037841


this a version in 10.2.0.2

10680 14/03/2012 0041483995 03731700377 00655201200 1331 Bilanci: l¿impresa non è valutabile per incongruenze nei dati di bilancio UN 31/12/9999 GLM 0020037841

there isn't a header .
Re: set heading [message #588039 is a reply to message #588036] Thu, 20 June 2013 07:07 Go to previous messageGo to next message
Michel Cadot
Messages: 58957
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not HTML.

Give us what there actually is.
Tell us how we can reproduce what you have and do in order ot diagnose the problem.

Also, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel
Re: set heading [message #588045 is a reply to message #588039] Thu, 20 June 2013 08:01 Go to previous messageGo to next message
FrancescoIt
Messages: 4
Registered: June 2013
Location: Italy
Junior Member
excuse me for error in the previous message .

The attachement explain my problem .
./fa/10908/0/


[mod-edit: messaged inserted into message body by bb\]
  • Attachment: mio.JPG
    (Size: 26.95KB, Downloaded 96 times)

[Updated on: Sat, 06 July 2013 16:52] by Moderator

Report message to a moderator

Re: set heading [message #588046 is a reply to message #588045] Thu, 20 June 2013 08:08 Go to previous messageGo to next message
Michel Cadot
Messages: 58957
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you expect from us?

Regards
Michel
Re: set heading [message #588047 is a reply to message #588046] Thu, 20 June 2013 08:18 Go to previous messageGo to next message
FrancescoIt
Messages: 4
Registered: June 2013
Location: Italy
Junior Member
solving my problem .

In the version 9.2 there is the header,while in the version 10 there isn't a header .
The sql stantment it's same .
Re: set heading [message #588048 is a reply to message #588047] Thu, 20 June 2013 08:19 Go to previous messageGo to next message
BlackSwan
Messages: 22726
Registered: January 2009
Senior Member
file a Bug Report with Oracle
Re: set heading [message #588049 is a reply to message #588047] Thu, 20 June 2013 08:40 Go to previous messageGo to next message
Michel Cadot
Messages: 58957
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Maybe some options changed.
What I can see is that if you just use "set markup html on" you have the header.
so start from this and add bit per bit what you have still you find which one removes the header then you will see what you can do.

Regards
Michel
Re: set heading [message #589465 is a reply to message #588049] Sat, 06 July 2013 16:54 Go to previous message
Barbara Boehmer
Messages: 7974
Registered: November 2002
Location: California, USA
Senior Member
You are probably missing the SQL*Plus command:

SET HEADING ON
Previous Topic: PlSql Development IDE
Next Topic: Toad in MacOS
Goto Forum:
  


Current Time: Tue Sep 02 08:11:50 CDT 2014

Total time taken to generate the page: 0.11658 seconds