Skip to Main Content

Oracle Database Discussions

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 9i feature not available in Oracle 10g

102327Jan 23 2005
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.3 (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.3

Does anybody know, when this feature is available in Oracle 10, too ? Already in 10.1.0.4 ? Or in Oracle 10g Release 2 ?

Thanks,

Ulf
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2005
Added on Jan 23 2005
0 comments
94 views