PHP 4.0 Bug #5079: ORACLE8i database access : OCIExecute function return integer overflow
| From: | spinto at mobileway dot com | Date: | Fri, 16 Jun 2000 11:30:13 +0000 |
| Subject: | PHP 4.0 Bug #5079: ORACLE8i database access : OCIExecute function return integer overflow | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-21499@lists.php.net to get a copy of this message | ||
From: spinto@mobileway.com
Operating system: LINUX Redhat 6.2
PHP version: 4.0.0 Release
PHP Bug Type: Oracle related
Bug description: ORACLE8i database access : OCIExecute function return integer overflow
Script to reproduce the problem :
$query="select * from table_name where columnname_value>val1 and
columnname_value<val2";
$stmt=OCIParse($strConn,$query);
if (!OCIExecute($stmt)){
...
with [val1,val2] U [33377,34744] not null.
On ORACLE8i database, columnname_value is defined as NUMBER(15)
Error message :
"ORA-03120-two-task conversion routine : integer overflow."