Oracle XML data

[eluser]atomp3[/eluser]
Hello

How to retrieve xml data from Oracle table?

Tried

Code:

select MSG_DATA.getClobVal()
from CCGW_MSG_XMLDATA
where LOG_ID = 123

but getting error. Is there a way for CI to show exact query error?

Thanks.

[eluser]Relexx[/eluser]
try running the query in Oracle first, does that succeed?

[eluser]atomp3[/eluser]
Yes it does, grab all xml data (xml tags).

If you run in PHP without getClobVal(), get array without keys only values.