Re: Convert DomDocument to clob

From: <g>
Date: Wed, 5 Jul 2006 16:30:20 +0100
Message-ID: <g6Kdnfs2svfYRjbZRVnyvA@bt.com>

this should help
give you an idea
CREATE OR REPLACE procedure ADDXML_to_Messagelog2(intype varchar2,myxml varchar) as

c_clob clob;

begin

dbms_lob.createtemporary(C_CLOB,FALSE,DBMS_LOB.CALL);
dbms_lob.OPEN(C_CLOB,dbms_lob.lob_readwrite);
dbms_lob.writeAppend( C_CLOB, LENGTH( myxml),myxml);

INSERT INTO PAT.MESSAGETABLE (MESSAGE_ID, STATUS, TYPE,    MESSAGE) VALUES ( message_id.nextval ,'NEW' , intype,c_clob );    end ;
/

<was79_at_wanadoo.fr> wrote in message
news:1152111875.430497.147900_at_75g2000cwc.googlegroups.com...
> Hi,
>
> I'm Using Oracle 9 , i have a domdocument but i would like to convert
> it into a clob.
>
> Thanks for your help.
>
Received on Wed Jul 05 2006 - 10:30:20 CDT