Skip to Main Content

DevOps, CI/CD and Automation

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!

XML Query on a CLOB Column

326809Dec 21 2010 — edited Dec 21 2010
I am trying to query a column which is of CLOB data type,in Oracle, and My Data is stored something like this

<Result><Institution>XXX</Institution><Application>XXX</Application><ID>123123123</ID><SequenceID>MSGID123123</SequenceID><DateTime></DateTime></Result>

I am trying to run the xquery on this like this

SELECT Message FROM LOGS
('for $i in ora:view("LOGS")
where $i/Result/Institution/ = 'XXX'
return $i/Result/Institution/
PASSING :Institution AS 'XXX').

I either get exception that "missing right parenthesis" or doesnt execute at all.

My Table "LOGS" as the Columns Message as CLOB.

Any Ideas how to query on this kind of columns in a table in Oracle using XQuery?
Cheers
Sridhar
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 18 2011
Added on Dec 21 2010
2 comments
3,379 views