Insert large amount of XML documents using stored procedures

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

  1. Create two stored procedures
  2. Call both stored procedures