Stored Procedures for the xml insertion

CREATE TABLE RDCXMLFILES ( FILENAME VARCHAR2 (50), FILECONTENT XMLTYPE ) ;

CREATE OR REPLACE PROCEDURE spT1 (tmpBlob in out CLOB)ASdpBlob CLOB; BEGINDBMS_LOB.CREATETEMPORARY(dpBlob, False, 0);tmpBlob := dpBlob; END;/

create or replace procedure spInsertRDCXML(File_Name in varchar, File_Content in CLOB)ASv_FileName varchar(26);v_doc CLOB;v_xml XMLTYPE;BEGINv_FileName := File_Name;v_doc := File_Content ;v_xml := sys.xmltype.createXML(v_doc);INSERT INTO RDCXMLFILES VALUES (v_FileName, v_xml );END;/