Re: Oracle XMLTYPE column truncates
| From: | Mikey | Date: | Thu, 08 Mar 2007 16:24:36 +0000 |
| Subject: | Re: Oracle XMLTYPE column truncates | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-250080@lists.php.net to get a copy of this message | ||
Mikey wrote:
Roberto Mansfield wrote:STFW worked for a change - this is so unlike Oracle ;o) http://www.oracle.com/technology/pub/articles/oracle_php_cookbook/fuecks_lobs.htmlHi 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. RobertoHi Roberto, thanks for your reply - any pointers to resources for dealing with CLOBS? Mikey