xml document to oracle table

I am attemptimg to convert an xml document to an oracle table.
I am using the following java program to try to achieve this task.

import oracle.xml.sql.dml.*;
import java.sql.*;
import oracle.jdbc.driver.*;
import oracle.jdbc.*;
import java.net.*;

public class xmltest
{
  public static void main(String args[]) throws SQLException
  {
    String tabname = "TRILOAD"; // Table into which to insert xml data
    String filename = "c:\\pa_tri.xml\\"; // xml document filename
    DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

    // Initialize a JDBC connection
    Connection conn = DriverManager.getConnection
      ("jdbc:oracle:thin:@epen02:1535:DEVDWH","TRI_DBA","TEST");

    // Insert XML data from file (filename) into
    // database table (tabname)
    OracleXMLSave save = new OracleXMLSave(conn, tabname);

    URL url = save.createURL(filename);
System.out.println("display :" + filename);
    int rowCount = save.insertXML(url);
System.out.println("display :" + url);

    System.out.println(" successfully inserted "+rowCount+
                       " rows into "+ tabname);
    conn.close();
System.exit(0);
  }
 }

The program compiles fine, however when attempting to run it I get the
following error message.

Exception in thread "main" oracle.xml.sql.OracleXMLSQLException: No rows to
mo
fy -- the row enclosing tag missing.  Specify the correct row enclosing tag.
        at oracle.xml.sql.dml.OracleXMLSave.saveXML(OracleXMLSave.java:2532)
        at oracle.xml.sql.dml.OracleXMLSave.saveXML(OracleXMLSave.java:2402)
        at oracle.xml.sql.dml.OracleXMLSave.insertXML
(OracleXMLSave.java:1365)
        at xmltest.main(xmltest.java:25)


Anyone have any suggestions on what the problem is.
Any ideas would be appreciated.

-----------------------------------------------------
xml-interest: A list for discussing XML technologies in the Java Platform.
To post, mailto:[email protected]
Archives at: http://archives.java.sun.com/xml-interest.html
To unsubscribe, mailto:[email protected] the following message;
signoff xml-interest.