Re: OracleXMLSave problem + abstract datatypes

From: Steve Muench <smuench_at_us.oracle.com>
Date: Fri, 1 Dec 2000 14:08:49 -0800
Message-ID: <arVV5.70$5B2.20383@inet16.us.oracle.com>

The problem is that XML SQL is looking for the XML to be in its canonical ROWSET/ROW format.

> <item>
> <header>
> <name>Chris</name>
> <id>1</id>
> </header>
> <body>
> <description>perturbed</description>
> <part>2</part>
> </body>
> </item>
>
>
> The error that I receive is this:
>
> Exception in thread "main" oracle.xml.sql.OracleXMLSQLException: No
> rows to modify -- the row enclosing tag missing. Specify the correct
> row enclosing tag.

You need the document to look like:

      <header>
        <name>Chris</name>
        <id>1</id>
      </header>
      <body>
        <description>perturbed</description>
        <part>2</part>
      </body>

</item>
</ROW>
</ROWSET>

and remember to call setIgnoreCase(true) if you want the tag names to not be case-sensitive.

Steve Muench, Lead XML Evangelist & Consulting Product Manager BC4J & XSQL Servlet Development Teams, Oracle Rep to XSL WG Author "Building Oracle XML Applications", O'Reilly http://www.oreilly.com/catalog/orxmlapp/ Received on Fri Dec 01 2000 - 16:08:49 CST