ID: 17908 Updated by: [EMAIL PROTECTED] Reported By: ThorpeJ at gao dot gov -Status: Feedback +Status: No Feedback Bug Type: OCI8 related Operating System: Linux 7.1 PHP Version: 4.0CVS-2002-06-21 Assigned To: maxim New Comment:
No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. Previous Comments: ------------------------------------------------------------------------ [2003-10-14 21:01:27] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip ------------------------------------------------------------------------ [2002-10-20 15:33:55] [EMAIL PROTECTED] true, actually, what i noticed is that if you do a fetch *before* calling OCIColumnIsNULL() you then get the right results. /******************************************************/ $conn = OCILogon($user, $pwd, $db); $stmt = OCIParse($conn, "select * from $table"); OCIExecute($stmt); $nrows = OCIFetchStatement($stmt, $res); // adding this $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 } /******************************************************/ Will go to fix that. ------------------------------------------------------------------------ [2002-06-21 14:20:29] ThorpeJ at gao dot gov 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 this bug report at http://bugs.php.net/?id=17908&edit=1
