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 and later
Information in this document applies to any platform.


 Attempting to use the OracleXML command line functionality with the putXML command results in the
following 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(
at oracle.xml.sql.dml.OracleXMLSave.saveXML(
at oracle.xml.sql.dml.OracleXMLSave.insertXML(
at OracleXML.Put_XML(
at OracleXML.ExecutePutXML(
at OracleXML.main(


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.