ID: 46519 Updated by: [EMAIL PROTECTED] Reported By: murgesan dot s at ge dot com -Status: Open +Status: Feedback Bug Type: PDO related Operating System: Windows XP PHP Version: 5.2.6 New Comment:
Thank you for this bug report. To properly diagnose the problem, we need a backtrace to see what is happening behind the scenes. To find out how to generate a backtrace, please read http://bugs.php.net/bugs-generating-backtrace.php for *NIX and http://bugs.php.net/bugs-generating-backtrace-win32.php for Win32 Once you have generated a backtrace, please submit it to this bug report and change the status back to "Open". Thank you for helping us make PHP better. Previous Comments: ------------------------------------------------------------------------ [2008-11-07 19:11:21] murgesan dot s at ge dot com Description: ------------ Hi When i use CLOB column getting the following error pop-up. Apache HTTP Server has encountered a problem and needs to close. We are sorry for the inconvenience. with two buttons Semd error report and Don't send. When i dont have CLOB column in resultst, code perfectly works Please help me out. $sql='SELECT * FROM TABLE(GEGIS_KEDB_PKG.FN_VIEW_COMMENTS(:p1,:p2))'; is just querying the pipelined oracle function I dont have any problem in the function, as when i execute the same query in PL/SQL Developer , ite giving me correct result. Thanks, Murugesan.S Reproduce code: --------------- $db=new DBConfig(); $dbconn = new Zend_Db_Adapter_Pdo_Oci($db->getConfArray()); $sql='SELECT * FROM TABLE(GEGIS_KEDB_PKG.FN_VIEW_COMMENTS(:p1,:p2))'; $statement = new Zend_Db_Statement_Pdo($dbconn, $sql); $statement->bindParam('p1',$ke_error_id,PDO::PARAM_STR,20); $statement->bindParam('p2',$ke_error_type,PDO::PARAM_STR,20); $statement->execute(); $comments = fopen("comments.txt", "wb"); $statement->bindColumn(1, $commentId,PDO::PARAM_STR, 32); $statement->bindColumn(2, $errorId,PDO::PARAM_STR, 32); $statement->bindColumn(3, $comments,PDO::PARAM_LOB); $statement->bindColumn(4, $createdBy,PDO::PARAM_STR, 32); $statement->bindColumn(5, $createdDateTime,PDO::PARAM_STR, 32); while($statement->fetch(PDO::FETCH_BOUND)) { print_r($commentId); print_r($errorId); print_r($createdBy); print_r($createdDateTime); print_r(fpassthru($comments)); } Expected result: ---------------- Get printed all the values from the resultset. Actual result: -------------- Getting Following error in error.log: [Fri Nov 07 23:59:00 2008] [notice] Child 516: Starting thread to listen on port 8082. [Sat Nov 08 00:19:27 2008] [notice] Parent: child process exited with status 3221225477 -- Restarting. PHP Warning: PHP Startup: Unable to load dynamic library 'C:\\Program Files\\PHP\\ext\\php_java.dll' - The specified module could not be found.\r\n in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'C:\\Program Files\\PHP\\ext\\php_apc.dll' - The specified module could not be found.\r\n in Unknown on line 0 [Sat Nov 08 00:19:27 2008] [notice] Apache/2.2.9 (Win32) PHP/5.2.6 configured -- resuming normal operations [Sat Nov 08 00:19:27 2008] [notice] Server built: Jun 13 2008 04:04:59 [Sat Nov 08 00:19:27 2008] [notice] Parent: Created child process 2628 PHP Warning: PHP Startup: Unable to load dynamic library 'C:\\Program Files\\PHP\\ext\\php_java.dll' - The specified module could not be found.\r\n in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'C:\\Program Files\\PHP\\ext\\php_apc.dll' - The specified module could not be found.\r\n in Unknown on line 0 [Sat Nov 08 00:19:27 2008] [notice] Child 2628: Child process is running [Sat Nov 08 00:19:27 2008] [notice] Child 2628: Acquired the start mutex. [Sat Nov 08 00:19:27 2008] [notice] Child 2628: Starting 64 worker threads. [Sat Nov 08 00:19:27 2008] [notice] Child 2628: Starting thread to listen on port 8082. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=46519&edit=1
