Re: Bug #7943

Jessie Hernandez wrote:

Hi Wez, Have you gotten a chance to look at this bug yet (PDO_OCI: Cannot insert CLOB into table, http://pecl.php.net/bugs/bug.php?id=7943)? I submitted a patch for it more than a year ago, and I've seen several users reporting this error when I did a search on Google. This is a serious issue with the PDO_OCI driver, and I'm currently involved in a large project that uses CLOB columns for several tables. I know you're probably still busy with Unicode support, but if you are not able to review the patch, can you assign someone else to review/commit (or grant me a CVS account and I'll do it :-) ) ?

There's no status change on this. Any PDO_OCI changes (from me at least) are pending a well defined specification for PDO. LOB support in PDO is one area that turns out to need extra careful thought to minimize the differences between databases. No discussions on how that can be acheived have been started. My recommendation is to use OCI8, which has features for performance and scalability that aren't even designed into PDO. Chris -- Christopher Jones, Oracle Email: christopher.jones@oracle.com Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/ Free PHP Book: http://tinyurl.com/f8jad