Save an XML in table using PL/SQL

[vishal172]

I have an table containing a CLOB column. I want to save my generated XML in that table. The procedure which i am using is :-\[code\] DECLARE xdata XMLTYPE; CURSOR xmlcur IS SELECT xmlelement("Employee", ,xmlelement("EmployeeNumber",e.employee_id) ,xmlelement("EmployeeName",e.first_name) ,xmlelement("Department", xmlelement("DepartmentName",d.department_name) ,xmlelement("Location",d.location_id) ) ) FROM employees e ,departments d WHERE e.department_id=d.department_id; l_clob clob; BEGIN dbms_lob.createtemporary( l_clob, true ); OPEN xmlcur; LOOP FETCH xmlcur INTO xdata; EXIT WHEN xmlcur%notfound; l_clob := l_clob || xdata.getClobVal(); END LOOP; -----INSERT into TABLE_XML (ID, XML_COLUMN) VALUES(1, myXML.xml); CLOSE xmlcur; END;\[/code\]How am i going to save an XML in table?