note 12169 deleted from function.ora-bind by philip
| From: | philip@php.net | Date: | Fri, 18 Apr 2008 05:05:06 +0000 |
| Subject: | note 12169 deleted from function.ora-bind by philip | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-138450@lists.php.net to get a copy of this message | ||
Note Submitter: mukund at ziplip dot com
----
Inputting integers using ORA_BIND.
There is a potential problem in binding oracle integers using php. PHP supports only 32 bit
integers where as oracle supports 128. so when you are trying to bind an 128 bit oracle integer,
php only interprets the first 32 bits. This results in undesired behaviour. The easiest way around
it is not to use bind operations and instead do the whole conversion during the parsing phase. This
means you have to parse for each input. A more optimal solution would be to change the oracle inputs
to be varchar2 and let oracle deal with the type conversions.