OraFAQ Forum: Client Tools

Home » Other » Client Tools » set heading (10.2.0.3 ,Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

set heading [message #588033]

Thu, 20 June 2013 06:22

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'> -
 -
</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

Report message to a moderator

Re: set heading [message #588034 is a reply to message #588033]

Thu, 20 June 2013 06:31

Littlefoot
Messages: 21823
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)?

Report message to a moderator

Re: set heading [message #588036 is a reply to message #588034]

Thu, 20 June 2013 06:37

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 .

Report message to a moderator

Re: set heading [message #588039 is a reply to message #588036]

Thu, 20 June 2013 07:07

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: set heading [message #588045 is a reply to message #588039]

Thu, 20 June 2013 08:01

FrancescoIt
Messages: 4
Registered: June 2013
Location: Italy

Junior Member

excuse me for error in the previous message .

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

[mod-edit: messaged inserted into message body by bb\]

Attachment: mio.JPG
(Size: 26.95KB, Downloaded 3055 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

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What do you expect from us?

Regards
Michel

Report message to a moderator

Re: set heading [message #588047 is a reply to message #588046]

Thu, 20 June 2013 08:18

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 .

Report message to a moderator

Re: set heading [message #588048 is a reply to message #588047]

Thu, 20 June 2013 08:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

file a Bug Report with Oracle

Report message to a moderator

Re: set heading [message #588049 is a reply to message #588047]

Thu, 20 June 2013 08:40

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: set heading [message #589465 is a reply to message #588049]

Sat, 06 July 2013 16:54

Barbara Boehmer
Messages: 9104
Registered: November 2002
Location: California, USA

Senior Member

You are probably missing the SQL*Plus command:

SET HEADING ON

Report message to a moderator

Previous Topic:	PlSql Development IDE
Next Topic:	Toad in MacOS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 13:25:45 CST 2025