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!

Oracle 9 feature not available in Oracle 10

102327Nov 24 2004

The following query does work in Oracle 9.2.0.4 (and 9.2.0.5), but does not work in Oracle 10.1.0.2 (Linux)

SELECT *
FROM MEDIA_CONTENT
WHERE EXISTSNODE
(MCON_XML,
'/rdf:RDF/rdf:Description[ora:contains(dc:title,"Whale")>0]',
'xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:ora="http://xmlns.oracle.com/xdb"')

The error message

ORA-29913: error in executing contains callout
ORA-15198: operation [contains with non-leaf node] is not yet available

indicates, that this feature is not yet available in Oracle 10.1.0.2

Does anybody know, when this feature is available in Oracle 10, too ? Already in 10.1.0.3 ?

Thanks,

Ulf

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 22 2004

Added on Nov 24 2004

#performance-availability, #xml-db

0 comments

179 views