Re: Oracle XMLTYPE column truncates
| From: | Mikey | Date: | Thu, 08 Mar 2007 15:52:17 +0000 |
| Subject: | Re: Oracle XMLTYPE column truncates | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-250076@lists.php.net to get a copy of this message | ||
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. RobertoHi Roberto, thanks for your reply - any pointers to resources for dealing with CLOBS? Mikey