ID: 40787 User updated by: jarismar at adplabs dot com dot br Reported By: jarismar at adplabs dot com dot br -Status: Feedback +Status: Open Bug Type: PDO related PHP Version: 5.2.1 Assigned To: wez New Comment:
Status changed to open again. Previous Comments: ------------------------------------------------------------------------ [2009-04-30 19:44:03] jarismar at gmail dot com Infortunately this error persists, it still occurs. Tested with PHP Version : 5.2.10-dev Build Date : Apr 26 2009 23:39:22 ------------------------------------------------------------------------ [2009-04-25 14:44:07] [email protected] Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows: http://windows.php.net/snapshots/ ------------------------------------------------------------------------ [2009-01-09 16:41:59] inbox at trevorbramble dot com I am experiencing the same error as charles at crh-systems dot com, however I'm trying to enter a string into a varchar2(4000) column. I've gone through a lot in the course of diagnosing this problem so I can't recall exactly what changed, but originally I was getting this error: ORA-01460: unimplemented or unreasonable conversion requested The resolution has been to define the length for that parameter: $stmt->bindParam( ':notes', $this->notes, PDO::PARAM_STR, 4000 ); Why this fixes the problem is still a mystery. None of the inserted data is lost, so there don't appear to have really been too many bytes in the string to insert. I'm not experiencing the same problem with any of the smaller columns (a string of 4 or more characters will insert into a column defined varchar2(10), for example). ------------------------------------------------------------------------ [2008-04-01 03:28:49] charles at crh-systems dot com I am having the same problem, OCIStmtExecute: ORA-01461: can bind a LONG value only for insert into a LONG column I can only get 1333 chars to insert into a clob field no matter which connection charset I use. 4000 / 3 = 1333.333 ...any fixes? ------------------------------------------------------------------------ [2007-03-12 18:27:14] jarismar at adplabs dot com dot br Many thanks for the faster reply, I've tested with suggested snapshot PHP Version: 5.2.2-dev Build Date : Mar 12 2007 16:05:36 But the problem still occurs. It seems that PDO get wrong data type for the CLOB column. I can just insert up to 4000 bytes into the CLOB column, because the extension thinks its handling a LONG column. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/40787 -- Edit this bug report at http://bugs.php.net/?id=40787&edit=1
