PEAR, oci8 and CLOBS

From: Date: Mon, 29 Oct 2001 17:41:29 +0000
Subject: PEAR, oci8 and CLOBS
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-446@lists.php.net to get a copy of this message
Hi there, I've been using the PEAR DB libs for a while now and I have just come across a problem. Does anyone know how PEAR deals with LOBS (or more specifically CLOBS) in Oracle? I have noticed that when I try and insert data into a CLOB field I can only insert upto 4000 characters. Prepared statements also fail. The only work around I have seen so far is to use the OCI calls directly. But this then makes coding for multi platforms and databases a hassle. Does anyone have any experience with this type of problem? ------------------------------------------------------------ Paul Edmondson, Software Engineer Yospace: Creating Value for Wireless 7 The Courtyard, High Street, Staines, UK, TW18 4DR Tel: +44 1784 466388 Fax: +44 1784 466387 http://www.yospace.com

« previous php.pear.general (#446) next »