Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> generate big XML pages with DBMS_XMLGEN and PL/SQL Web Toolkit
Hello, Oracle DB 9.0.1 and AS 9.0.4 here. I would like to use the
DBMS_XMLGEN package for converting a query into XML and printing it on
the web via PL/SQL Web Toolkit.
Something along the lines of:
procedure xml is
dsql varchar2(32767) ;
ctx dbms_xmlgen.ctxHandle;
xml clob ;
begin
dsql := 'select ... from ... where ... order by ... ' ;
ctx := dbms_xmlgen.newContext (dsql);
xml := dbms_xmlgen.getXML (ctx);
dbms_xmlgen.closeContext (ctx);
owa_util.mime_header('text/xml',true,'iso-8859-1') ; htp.print(xml);
end ;
The problem is that htp.print accept a varchar2 as a parameter, so it dones't work if the length of the clob is more than 32767 characters.
Is there a way to print out a clob via PL/SQL Web Toolkit?
Thank you. Kind regards,
-- « Se la pena è necessaria, non la si deve cancellare ; se non è necessaria, non la si deve pronunziare. » (Jeremy Bentham)Received on Thu Oct 25 2007 - 09:32:02 CDT
![]() |
![]() |