In order to obtain a reasonable performance number, we are going to insert XML docume nts into both the XML and CLOB columns in bulk.
The script on the right defines two stored procedures to insert 1000 XML documents into 'out_patient_data_PDD1' table as XML and 'out_patient_data_CLOB' table as CLOB.
Operation