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 -> Re: generate big XML pages with DBMS_XMLGEN and PL/SQL Web Toolkit

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

From: Tony_Miller <NoWayToday_at_yahoo.com>
Date: Sat, 27 Oct 2007 23:06:48 -0500
Message-ID: <47240af5$0$20607$4c368faf@roadrunner.com>


Why not look at Application Express?? You can do this in it and a whole lot more reporting stuff...

<mpacheco_brazil_at_hotmail.com> wrote in message news:1193324910.845733.154540_at_t8g2000prg.googlegroups.com... On Oct 25, 7:32 am, codadilupo <codadil..._at_operamail.com> wrote:
> 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)

Check the procedure "wpg_docload.download_file". You can output a BLOB so it is
just a matter of converting the data type. Received on Sat Oct 27 2007 - 23:06:48 CDT

Original text of this message

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