#35973 [NEW]: Error ORA-24806 occur when trying to fetch a NCLOB field

From: webmaster at f1-timer dot de Operating system: Linux, Solaris PHP version: 5.1.1 PHP Bug Type: OCI8 related Bug description: Error ORA-24806 occur when trying to fetch a NCLOB field Description: ------------ Trying to fetch data from an Oracle 9i Database, the Table has a NCLOB field which cannot be read via PHP, a normal CLOB field however works. The table structure is: CREATE TABLE NCLOB_TEST ( MYCLOB NCLOB ); And it simply contains one line of text with content '12345' I've tested this behavour with PHP 5.1.1 (Linux and Solaris) and 4.1.1 (only Linux), always give the same result. Reproduce code: --------------- <?php $query = 'SELECT MYCLOB FROM NCLOB_TEST'; //oci_internal_debug(1); $sock = OCILogon('SCOTT','TIGER'); $stmt = OCIParse($sock,$query); OCIExecute($stmt,OCI_DEFAULT); OCIFetchInto($stmt,$resultarray,OCI_ASSOC+OCI_RETURN_NULLS+OCI_RETURN_LOBS); print_r($resultarray); // Now try to load the clob with descriptor: OCIExecute($stmt,OCI_DEFAULT); OCIFetchInto($stmt,$resultarray,OCI_ASSOC); print_r($resultarray); $lobcontent = $resultarray['MYCLOB']->load(); OCIFreeStatement($stmt); print_r($lobcontent); OCILogoff($sock); exit; ?> Expected result: ---------------- Array ( [MYCLOB] => '12345' ) Array ( [MYCLOB] => '12345' ) Actual result: -------------- PHP Warning: ocifetchinto(): OCILobRead: ORA-24806: LOB-Formfehlanpassung in /spare/html/private/PHP-Classes/OCI8/bugzilla_php.php on line 8 Warning: ocifetchinto(): OCILobRead: ORA-24806: LOB-Formfehlanpassung in /spare/html/private/PHP-Classes/OCI8/bugzilla_php.php on line 8 Array ( [MYCLOB] => ) Array ( [MYCLOB] => OCI-Lob Object ( [descriptor] => Resource id #8 ) ) PHP Warning: OCI-Lob::load(): OCILobRead: ORA-24806: LOB-Formfehlanpassung in /spare/html/private/PHP-Classes/OCI8/bugzilla_php.php on line 16 Warning: OCI-Lob::load(): OCILobRead: ORA-24806: LOB-Formfehlanpassung in /spare/html/private/PHP-Classes/OCI8/bugzilla_php.php on line 16 PS: The Error is in english "LOB form mismatch" and is described from Oracle as below: netra:/opt/apache2/conf# oerr ora 24806 24806, 00000, "LOB form mismatch" // *Cause: When reading from or writing into LOBs, the character set // form of the user buffer should be same as that of the LOB. // *Action: Make sure that the buffer you are using to read or write // has the same form as that of the LOB. -- Edit bug report at http://bugs.php.net/?id=35973&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=35973&r=trysnapshot44 Try a CVS snapshot (PHP 5.1): http://bugs.php.net/fix.php?id=35973&r=trysnapshot51 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=35973&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=35973&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=35973&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=35973&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=35973&r=needscript Try newer version: http://bugs.php.net/fix.php?id=35973&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=35973&r=support Expected behavior: http://bugs.php.net/fix.php?id=35973&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=35973&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=35973&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=35973&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=35973&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=35973&r=dst IIS Stability: http://bugs.php.net/fix.php?id=35973&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=35973&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=35973&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=35973&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=35973&r=mysqlcfg