<g> wrote in message news:nLudncIrmZMsQTbZRVny2g_at_bt.com...
> or try
> CREATE OR REPLACE procedure ADDXML_to_Messagelog(intype varchar2,myxml
clob)
> as
> begin
> INSERT INTO PAT.MESSAGETABLE (MESSAGE_ID, STATUS, TYPE,
> MESSAGE) VALUES ( message_id.nextval ,'NEW' , intype,myxml );
> end ;
> /
>
> <g> wrote in message news:g6Kdnfs2svfYRjbZRVnyvA_at_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.
> > >
> >
> >
>
>
Don't top post! Or the top post squad will be after you! ;-)
Received on Thu Jul 06 2006 - 05:34:05 CDT
