ID:          40787
 Comment by:  markus at computino dot de
 Reported By: jarismar at adplabs dot com dot br
 Status:      Open
 Bug Type:    PDO related
 PHP Version: 5.2.1
 Assigned To: wez
 New Comment:

Still a valid bug, cost me multiple hours trying to work it out before
I found the bug report. Now using adodb/oci8.


Previous Comments:
------------------------------------------------------------------------

[2009-04-30 19:57:19] jarismar at adplabs dot com dot br

Status changed to open again.

------------------------------------------------------------------------

[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] j...@php.net

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?

------------------------------------------------------------------------

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

Reply via email to