LiveReport limitation?

Hi,

I built a nice Oracle query that generates a xml file from a folders structure (see http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions220.htm).

My problem is that I need this xml file to be created in Content Server. Generally I use a Livereport and a Webreport. In that case the Livereport returns only 1 row and 1 column. All date are in one cell. Due to a limitation the livereport truncates the result and the xml file is incomplete.

Is there a way to remove this limitation?

Thanks,

Find more posts tagged with

Comments

eLink User

Hi,

How large a quantity of data are we talking about here? I just tested loading 3MB of XML data into a single LiveReport cell and didn’t see any truncation.

Also, is there any particular reason you need to build up the XML using a SQL query rather than passing the raw data to the WebReport and then building up the XML there in a similar way to the SpreadsheetML template?

Regards

Ian Whitfield
Senior Support Analyst | Resonate KT

Phone:	+44 (118) 984 8358
Mobile:	+44 (782) 470 9641
LinkedIn:	http://www.linkedin.com/profile/view?id=38592772
Twitter:	@OpenText
Website:	www.opentext.com

This email message is confidential, may be privileged, and is intended for the exclusive use of the addressee. Any other person is strictly prohibited from disclosing or reproducing it. If the addressee cannot be reached or is unknown to you, please inform the sender by return email and delete this email message and all copies immediately.

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 30 January 2014 16:14
To: eLink Recipient
Subject: LiveReport limitation?

LiveReport limitation?

Posted byjean_philippe.forti@givaudan.com (Forti, Jean-Philippe) On 01-30-2014 11:01

Hi,

I built a nice Oracle query that generates a xml file from a folders structure (seehttp://docs.oracle.com/cd/B19306_01/server.102/b14200/functions220.htm).

Is there a way to remove this limitation?

Thanks,

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

image001.gif

Jean Philippe Forti

Hi Ian,

The xml file in my example is not very large, see attachment. I don't expect it to reach 20kb.

The idea there is to benefit from Oracle xml capabilities. See my query at the end of this post.

Using a Webreport to produce the xml is possible but the algorithm is complex to maintain. I have to count the open xml tags in order to close them correctly. If I want the Webreport code to be readable, the xml file I generated is full of space and carriage returns.

I tried with another folder structure and this is working in CS10 and LES971. I think my problem is related to the encoding of the &

Regards,

My magic query:

SELECT XMLELEMENT
("items",
(SELECT DBMS_XMLGEN.getxmltype
(DBMS_XMLGEN.newcontextfromhierarchy
('SELECT
level,
XMLElement("item",
XMLATTRIBUTES(dataid, name,subtype))
FROM dtree
where subtype in (0, 3030202, 202)
CONNECT BY PRIOR dataid = parentid
START WITH dataid = 7582377
order SIBLINGS by name'))
FROM DUAL)) xmldoc
FROM DUAL;