#27149 [Asn->Csd]: Saving of CLOBS does not work in RC2 but works fine in RC1

ID: 27149 Updated by: tony2001@php.net Reported By: webmaster at f1-timer dot de -Status: Assigned +Status: Closed Bug Type: OCI8 related Operating System: Suse Linux 8.1 PHP Version: 4.3.5RC2 Assigned To: tony2001 New Comment: This bug has been fixed in CVS. Snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. Thank you for the report, and for helping us make PHP better. It was my fault =( Already fixed in CVS, thanks for reporting. Previous Comments: ------------------------------------------------------------------------ [2004-02-04 19:11:49] sniper@php.net Antony, please check this out..some MFH broke this or what? ------------------------------------------------------------------------ [2004-02-04 13:19:29] webmaster at f1-timer dot de Description: ------------ I have many pages here that uses CLOB columns for storing large amount of text. In 4.3.5RC1 everything works fine, clobs are correctly saved. However I have today updated to 4.3.5RC2 and now the same code does not work anymore, Oracle complains about ORA-24801: ebola:/usr/src/php-4.3.5RC2 # oerr ORA 24801 24801, 00000, "illegal parameter value in OCI lob function" // *Cause: One of the parameter values in the OCI lob function is illegal. // *Action: Check every parameter in the OCI Lob function call to make sure // they are correct. Offsets should be greater than or equal to one. Here is my configure line: /configure' '--with-apxs2=/opt/apache2/bin/apxs' '--enable-bcmath' '--with-openssl=/opt/openssl' '--enable-sigchild' '--with-pear=/html/PEAR' '--enable-libgcc' '--with-config-file-path=/opt/apache2/conf' '--with-pdflib=/usr/local' '--with-oci8' '--with-gd' '--with-ttf=/usr' '--with-freetype-dir=/usr' '--enable-gd-imgstrttf' '--enable-gd-native-ttf' '--with-jpeg-dir=/usr' '--with-png-dir=/usr' '--with-xpm-dir=/usr' '--with-t1lib=/usr' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg' '--disable-debug' '--disable-ctype' '--with-mysql=/opt/mysql4' '--with-zlib=/usr' '--enable-track-vars' '--enable-calendar' '--enable-ftp' '--enable-sockets' '--with-gmp' '--disable-trans-sid' '--enable-shmop' '--without-msql' '--with-mcal=/usr' '--with-gettext' '--with-bz2=/usr' '--without-dom' '--enable-exif' '--with-mm=/usr' '--enable-mbstring' '--enable-mbregex' '--enable-mime-magic' '--enable-dbx' '--enable-dio' '--with-mcrypt=/usr/local' '--with-tsrm-pthreads' '--with-readline' '--with-ncurses' '--enable-dba' '--with-mhash=/usr' '--with-gdbm=/usr' '--with-dbm=/usr' '--with-db4=/usr' '--with-libxml-dir=/opt/libxml2' The Database is Oracle 9.2.0.4 EE Reproduce code: --------------- The code to reproduce is actually 76 Lines long, so here is the URL to it: http://www.in-ovation.de/clobtest.txt Expected result: ---------------- printing out "done." Actual result: -------------- Warning: save(): OCILobWrite: ORA-24801: Unzulässiger Parameterwert in OCI-LOB-Funktion in /html/private/clobtest.php on line 62 Unable to add CLOB text to database! done. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=27149&edit=1