My Oracle Support Banner

Oracle.Xml.Sql.Oraclexmlsqlexception: No Rows To Modify (Doc ID 280784.1)

Last updated on APRIL 29, 2020

Applies to:

Oracle XML SQL Utility (XSU) - Version 8.1.7.4 and later
Information in this document applies to any platform.

Symptoms

 Attempting to use the OracleXML command line functionality with the putXML command results in the
following error:

Error:
-------
java OracleXML putXML -user "scott/tiger" -conn "jdbc:oracle:thin:@myServer:1521:s9203" -filename
<filename> <table>
oracle.xml.sql.OracleXMLSQLException: No rows to modify -- the row enclosing tag
missing. Specify the correct row enclosing tag.
at oracle.xml.sql.dml.OracleXMLSave.saveXML(OracleXMLSave.java:2389)
at oracle.xml.sql.dml.OracleXMLSave.saveXML(OracleXMLSave.java:2261)
at oracle.xml.sql.dml.OracleXMLSave.insertXML(OracleXMLSave.java:1349)
at OracleXML.Put_XML(OracleXML.java:480)
at OracleXML.ExecutePutXML(OracleXML.java:398)
at OracleXML.main(OracleXML.java:182)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.