[CLOSED for now] Displaying the contents of a CLOB field

A customer uses a CLOB field in an Oracle database to store some XML.
He would like to display the XML on his screen as if coming from a notepad file: he wants to see all the tags.
Any ideas?

This message has been edited. Last edited by: Danny-SRL,

Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006

ABT

Master

posted

Hide Post

i think you'll have to replace the greater than tags with & gt ; and less thans with & lt ; to get it to display and not interpret. either that or change the http header to infer that it's a text output and not to be interpreted.

- ABT

------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro

Posts: 561 | Registered: February 03, 2010

Ignored post by ABT posted

Show Post

Danny-SRL

Virtuoso

posted

Hide Post

quote:
change the http header to infer that it's a text output and not to be interpreted

What would the header look like?

Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006

Ignored post by Danny-SRL posted

Show Post

ABT

Master

posted

Hide Post

quote:
Originally posted by Danny-SRL:
What would the header look like?

I have experience doing this in ASP, but not in WebFOCUS, so I'm sort of shooting from the hip. Seems like switching the output to text\plain should allow it to come through as plain text.

See the ASP implementation: http://www.w3schools.com/asp/prop_contenttype.asp

See this WebFOCUS documentation: http://www.csueastbay.edu/FOCU...79.htm#d10sec1094378

- ABT

Posts: 561 | Registered: February 03, 2010

Ignored post by ABT posted

Show Post

Danny-SRL

Virtuoso

posted

Hide Post

This is a description of where I am now:
I defined the CLOB with format A32000.
I issue a TABLE command and PRINT my CLOB.
If I understand you correctly, I should issue before the TABLE command something like

  
-HTMLFORM BEGIN
-* here a content-type which would say plain/text or something to that effect
-HTMLFORM END

So my question is what exactly do I put between the -HTMLFORM command?

Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006

Ignored post by Danny-SRL posted

Show Post

Alan B

Virtuoso

posted

Hide Post

The only way I know of easily getting tagged XML into the browser is to use a textarea:

TABLE FILE fn
PRINT XML
ON TABLE SAVE
END
-RUN
-HTMLFORM BEGIN
<html>
<head>
<style type="text/css"> textarea { overflow: auto; border: none; width:110%; height:100%;} </style>
</head>
<body>
<textarea>
!IBI.FIL.SAVE;
</textarea>
</body>
</html>
-HTMLFORM END

The browsers tend to always want to interpret the XML no matter how you try and present it.

Alan.
WF 7.705/8.007

Posts: 1451 | Location: Portugal | Registered: February 07, 2007

Ignored post by Alan B posted

Show Post

Mighty Max

Guru

posted

Hide Post

Does this post help at all? [SOLVED] Display XML file stored in SQL Table

WebFOCUS 8.1.05M Unix Self-Service/MRE/Report Caster - Outputs Excel, PDF, HTML, Flat Files

Posts: 320 | Location: Memphis, TN | Registered: February 12, 2008