note 12169 deleted from function.ora-bind by philip

From: 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.

« previous php.notes (#138450) next »