Re: Bug #13594 [NEW]: db2_fetch_both: Problems fetching CLOB fields

Hi, I am not able to reproduce the problem that you have mentioned. Will you please provide me following information on this issue: CLI Trace of the sample program. SQLSTATE SQLCODE The query that you used. (like create table, insert and select sql statements). Thanks, IBM OpenSource Application Development Team India Software Labs, Bangalore (India) "eacosta at openware dot biz" <pecl-dev@lists.php.net> 05/04/2008 00:47 To Open Source Application Development/Lenexa/IBM@IBMUS cc Subject [PECL-BUG] Bug #13594 [NEW]: db2_fetch_both: Problems fetching CLOB fields From: eacosta at openware dot biz Operating system: OpenSUSE 10.2 Package version: 1.6.5 PHP version: 4.4.8 Package: ibm_db2 Bug Type: Bug Bug description: db2_fetch_both: Problems fetching CLOB fields Description: ------------ Hello, I've been facing difficulties with walk a big number of records from a result set. I am using the function db2_fetch_both in a method of a database adapter class to retrieve just one record at a time. The total number of records are: 5647 and when I reach record number 1600 the function crashed generating the below message in "Actual result" field. I am copying table's description next: TMP_TABLE ----------------------------------------------------------------- | ID | TYPE | SIZE | NULL | ----------------------------------------------------------------- | ID | INTEGER | 4 | NO | | SERVICE | VARCHAR | 30 | NO | | ID_v | VARCHAR | 30 | NO | | INFORMATION | CLOB | 65536 | YES | | EXP_LEVEL | INTEGER | 4 | NO | | IP4B | BIGINT | 8 | NO | | MODIFIED | INTEGER | 4 | YES | | DETAIL | VARCHAR | 200 | YES | | FALSPOS | INTEGER | 4 | YES | ----------------------------------------------------------------- I would like to notice you this database class adapter's method comes from "CodeCharge Studio 3.1" (http://www.codecharge.com) a well-know PHP Rapid Development Programme. I can't give you more details about our PHP Server configuration for security reasons. I hope you understand it. Thank you, -- Esteban Acosta Villafañe R+D Department http://www.openware.biz Linkein Profile: http://www.linkedin.com/in/estebanav Reproduce code: --------------- function next_record() { if (!$this->Query_ID) return 0; $this->Record = db2_fetch_both($this->Query_ID) ; $this->Row += 1; $stat = is_array($this->Record); if (!$stat && $this->Auto_Free) { $this->free_result(); } return $stat; } Expected result: ---------------- Return true or false and assign a record to Record instance property and incremented 1 Row instance property. Actual result: -------------- db2_fetch_array() [function.db2-fetch-array]: Fetch Failure -- Edit bug report at http://pecl.php.net/bugs/bug.php?id=13594&edit=1 --