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