Re: Oracle XMLTYPE column truncates

Mikey wrote: > Roberto Mansfield wrote: >> Hi Mikey, >> >> OCI doesn't directly support the XMLtype so you need to convert to >> string (if < 4k) or clob before retrieving. Use: >> >> select xml_metadata.getClobVal() ... OR >> select xml_metadata.getStringVal() ... >> >> If converting to clob, you get a clob object back and you'll need to run >> the load() method on it to get the text back. >> >> Roberto > > Hi Roberto, thanks for your reply - any pointers to resources for > dealing with CLOBS? > > Mikey Checkout http://www.oracle.com/technology/pub/articles/oracle_php_cookbook/fuecks_lobs.html and go to the section "Selecting a LOB". -Roberto