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.
> >
>
>
Received on Wed Jul 05 2006 - 10:36:25 CDT
