Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> generate big XML pages with DBMS_XMLGEN and PL/SQL Web Toolkit

generate big XML pages with DBMS_XMLGEN and PL/SQL Web Toolkit

From: codadilupo <codadilupo_at_operamail.com>
Date: Thu, 25 Oct 2007 16:32:02 +0200
Message-ID: <4720a8e2$0$21214$5fc30a8@news.tiscali.it>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US