From: smelban at norwood dot com
Operating system: Windows 2003 Enterprise Server
PHP version: 5.2.6
PHP Bug Type: Oracle related
Bug description: OCI get number column length returns zero (0)
Description:
------------
We just recently upgraded from Oracle 10g to Oracle 11g. Since that move
the ocicolumnscale and ocicolumnprecision functions have stopped returning
the column length.
Windows 2003 Enterprise Server
Zend Core 2.5.0
PHP 5.2.5
Reproduce code:
---------------
// mynumber field is a 10,4 decimal
$sql = "SELECT mynumber FROM TABLENAME";
$R = OCIParse($c, $sql);
OCIExecute($R);
while (OCIFetch($R)) {
$column_type = ocicolumntype($R, $i);
if( $column_type == "NUMBER" )
{
print ocicolumnscale($R, $i ) . "\n";
print ocicolumnprecision($R, $i ) . "\n";
}
}
Expected result:
----------------
Should Return
10
4
Actual result:
--------------
Returns
0
0
--
Edit bug report at http://bugs.php.net/?id=45039&edit=1
--
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=45039&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=45039&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=45039&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=45039&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=45039&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=45039&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=45039&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=45039&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=45039&r=support
Expected behavior: http://bugs.php.net/fix.php?id=45039&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=45039&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=45039&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=45039&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=45039&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=45039&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=45039&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=45039&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=45039&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=45039&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=45039&r=mysqlcfg
