Bug #72524 [Com]: Binding null values triggers ORA-24816 error
Edit report at https://bugs.php.net/bug.php?id=72524&edit=1
ID: 72524
Comment by: peter dot lukan at outlook dot com
Reported by: deeky666 at googlemail dot com
Summary: Binding null values triggers ORA-24816 error
Status: Closed
Type: Bug
Package: OCI8 related
Operating System: Ubuntu 15.10
PHP Version: 7.0.8
Block user comment: N
Private report: N
New Comment:
I saw that this bugfix has been commited, when it will be available to the "release" for
public use?
In case this is not in reasonable time ... I need a suggestion how to install a version of OCI8 with
this hotfix included.
Can I clone this repo and build it myself? Or maybe is there a "beta channel releases"
available?
Previous Comments:
------------------------------------------------------------------------
[2016-08-07 00:04:29] sixd@php.net
Automatic comment on behalf of christopher.jones@oracle.com
Revision: http://git.php.net/?p=php-src.git;a=commit;h=b601dc5b29147bb1402d78e7f33a90981a2f94f5
Log: Fix bug #72524 (Binding null values triggers ORA-24816 error)
------------------------------------------------------------------------
[2016-08-07 00:04:14] sixd@php.net
Automatic comment on behalf of christopher.jones@oracle.com
Revision: http://git.php.net/?p=php-src.git;a=commit;h=b601dc5b29147bb1402d78e7f33a90981a2f94f5
Log: Fix bug #72524 (Binding null values triggers ORA-24816 error)
------------------------------------------------------------------------
[2016-08-07 00:03:54] sixd@php.net
Automatic comment on behalf of christopher.jones@oracle.com
Revision: http://git.php.net/?p=php-src.git;a=commit;h=b601dc5b29147bb1402d78e7f33a90981a2f94f5
Log: Fix bug #72524 (Binding null values triggers ORA-24816 error)
------------------------------------------------------------------------
[2016-07-29 09:03:09] soyuka at gmail dot com
Indeed, adding a length works well. Should it be added to the docs? Is there a reason why it worked
in php5?
------------------------------------------------------------------------
[2016-07-26 05:41:06] sixd@php.net
There are a couple of workarounds. You could try reordering the bind parameters:
$stmt = oci_parse($conn, 'INSERT INTO mytable ("varchar2_col",
"clob_col") VALUES (:varchar2_col, :clob_col)');
or giving a size when binding:
oci_bind_by_name($stmt, ':varchar2_col', $varchar2, 1);
------------------------------------------------------------------------
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
https://bugs.php.net/bug.php?id=72524
--
Edit this bug report at https://bugs.php.net/bug.php?id=72524&edit=1
Thread (6 messages)