How to insert Clob column from a table to xmltype column in a other table
Hi
I have to copy the content of an xml file that is in a clob column of a table to a xmltype column in a other table in a pl/ sql Procedure.
How can I do this ?
The following code works if the content in my clob field isn't to large (2203 byte), but if I try the same with a 25 MB File it don't work.
I think the problem is the 32767 byte restriction in pl/sql
INSERT INTO XML_STAGING
(ID, CONTENT)
(SELECT XML_INFILES.ID, XMLTYPE( XML_INFILES.CONTENT)
FROM "XML_INFILES WHERE XML_INFILES.ID = 1 );
One way would be to write it to a file and the load it again, but is there a smarter way ?
Thank you in advance for your help,
Regards.