Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle xmlDOM API: new "feature"?

312985Sep 26 2002

I am manipulating a DOM document in a stored procedure:

Initial database content:
<Transmission xsi:noNamespaceSchemaLocation="transmission.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Xmit>x</Xmit>
<SysTGr>y</SysTGr>
<TrStat>?</TrStat>
<TrStatD>?</TrStatD>
</Transmission>

After performing replaceChild(<Xmit>y</Xmit>):
<Transmission xsi:noNamespaceSchemaLocation="transmission.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Xmit>y</Xmit>
<SysTGr>y</SysTGr>
<TrStat>?</TrStat>
<TrStatD>?</TrStatD>
</Transmission>

After performing replaceChild(<TrStatD>er</TrStatD>):
<Transmission xsi:noNamespaceSchemaLocation="transmission.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Xmit>x</Xmit>
<SysTGr>z</SysTGr>
<TrStat>?</TrStat>
<TrStatD>er</TrStatD>
</>

ERROR at line 1:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00231: invalid character 62 ('>') found in a Name or Nmtoken
Error at line 7
ORA-06512: at "SYS.XMLTYPE", line 0
ORA-06512: at "STAGINGDEV.P_WRITE_TRANSMISSION", line 70
ORA-06512: at "STAGINGDEV.P_WRITE_TRANSMISSION", line 279
ORA-06512: at line 6

Whatever I do with the last child that is in the database: it changes the end element tag of the parent! How can I avoid this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 24 2002

Added on Sep 26 2002

#performance-availability, #xml-db

0 comments

135 views