import java.sql.*;
import oracle.xml.sql.dml.OracleXMLSave;
public class testXMLSave
{
   public static void main(String argv[])
     throws SQLException
  {
      Connection conn = getConnection("scott","tiger");
      OracleXMLSave sav = new OracleXMLSave(conn, "scott.emp");

      sav.insertXML("<?xml version='1.0'?><ROWSET><ROW num=\"1\">
                    <EMPNO>1</EMPNO>
                    <ENAME>O&apos;Connor</ENAME>
                    <JOB>CLERK</JOB>
                    <MGR>7902</MGR>
                    <HIREDATE>12/17/1980 0:0:0</HIREDATE>
                    <SAL>1800</SAL>
                    <DEPTNO>20</DEPTNO>
                    </ROW></ROWSET>");
      sav.close();
   }

    private static Connection getConnection(String user, String passwd)
      throws SQLException
    {
      DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
      Connection conn =
          DriverManager.getConnection("jdbc:oracle:thin:@db",user,passwd);
     return conn;
   }
}