Bug #17908: Can't retrieve info using OCIColumnIsNULL()

From: ThorpeJ@gao.gov Operating system: Linux 7.1 PHP version: 4.0CVS-2002-06-21 PHP Bug Type: OCI8 related Bug description: Can't retrieve info using OCIColumnIsNULL() I've tried using OCIColumnIsNULL() to retrieve info on which fields were NULL/NOT NULL in an Oracle database table, and the function did not return anything (using OCIColumnName, OCIColumnType, and OCIColumnSize in the same program worked fine). The script below is a simple example: /******************************************************/ $conn = OCILogon($user, $pwd, $db); $stmt = OCIParse($conn, "select * from $table"); OCIExecute($stmt); $ncols = OCINumCols($stmt); for ( $i = 1; $i <= $ncols; $i++ ) { echo "NAME: " . OCIColumnName($stmt,$i) . "<BR>"; echo "TYPE: " . OCIColumnType($stmt,$i) . "<BR>"; echo "SIZE: " . OCIColumnSize($stmt,$i) . "<BR>"; echo "ISNULL: " . OCIColumnIsNULL($stmt,$i) . "<P>"; //Function does not return any information } /******************************************************/ -- Edit bug report at http://bugs.php.net/?id=17908&edit=1 -- Fixed in CVS: http://bugs.php.net/fix.php?id=17908&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=17908&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=17908&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=17908&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=17908&r=support Expected behavior: http://bugs.php.net/fix.php?id=17908&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=17908&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=17908&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=17908&r=globals