ID: 14278
Updated by: pumuckel@metropolis.de
Reported By: pumuckel@metropolis.de
Status: No Feedback
Bug Type: OCI8 related
Operating System: Linux 2.2.19
PHP Version: 4.0.6
New Comment:
FYI: Has been fixed in OCI interface. Error was not null terminated
strings.
Previous Comments:
------------------------------------------------------------------------
[2002-05-14 00:00:04] php-bugs@lists.php.net
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
------------------------------------------------------------------------
[2002-04-13 09:02:35] thies@php.net
oops - closed to fast.
please send me a short _SELF_ contains script that shows the problem
(including the oci-calls)
------------------------------------------------------------------------
[2002-04-13 09:00:59] thies@php.net
all scalar values returned from PHP-OCI8 are strings.
------------------------------------------------------------------------
[2002-04-09 18:12:39] jimw@php.net
recategorizing as an oci8 issue.
------------------------------------------------------------------------
[2002-01-09 09:17:14] pumuckel@metropolis.de
After some more investigation on this bug I noticed following:
I have an OCI insert statement executed with a 'RETURNING INTO' clause.
The value which is returned is a oracle DB entry of type NUMBER. I
expected to have the returned value in PHP to be a number as well. BUT
it is a string!
Some more output I produced in my script is:
<? echo("$num (type: ".gettype($num)."[".strlen($num)."] -
".($num*1).")"); ?>
The result (when the error occures):
106851 (type: string[6] - 1068514)
As you can see the value of the $num variable changes while automatic
type casting from string to int is executed.
The reason for the NEW (bigger) value is possibly a not null terminated
string value returned by the OCI interface.
My suggestion: While typecasting from string to int an extra check
should be done (e.g. detect if there is a null terminated string and if
not: terminate it).
Thanks for your patch!
------------------------------------------------------------------------
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/14278--
Edit this bug report at http://bugs.php.net/?id=14278&edit=1