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!

extractvalue returns value of only one node

Mark ReichmanAug 2 2007 — edited May 8 2009

9.2.0.5.0

I have a working view that extractsvalue() from a clob column containing xml. When I select more than one record or select * from the view, for a few records, I get "ora-19025 extractvalue returns value of only one node". The problem is the error message doesnt give me hints as to what record or element is causing the problem? Is there a way to determine which records or which elemment is the culprit when only a few records in the clob column are causing this to happen?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 5 2009

Added on Aug 2 2007

#performance-availability, #xml-db

6 comments

17,421 views