#39468 [Opn->Fbk]: PHP throws ociexecute(): supplied arg is not a valid OCI8-Stmt resource

ID: 39468 Updated by: tony2001@php.net Reported By: c_peruma at qualcomm dot com -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: Windows XP Professional PHP Version: 4.4.4 New Comment: Without this typo your code works just fine, so please provide a real reproduce code. Previous Comments: ------------------------------------------------------------------------ [2006-11-13 18:19:10] c_peruma at qualcomm dot com Sorry that was a typo . I am using $qHandle=OCIParse($ORACLE,$szType); Your help in regard to this problem would be appreciated. Thanks Savitha ------------------------------------------------------------------------ [2006-11-11 00:51:35] tony2001@php.net http://php.net/oci_parse resource oci_parse ( resource connection, string query ) and not resource oci_parse ( string query, resource connection ) ------------------------------------------------------------------------ [2006-11-11 00:36:21] c_peruma at qualcomm dot com Description: ------------ Our application page loads with an OCI error. After this the application froze and We try to re-login the page gets loaded properly.But we are not able to reproduce the problem. But it happens at very frequently, but dont know what causes the problem. Error seen was: Warning: ociexecute(): supplied argument is not a valid OCI8-Statement resource Fatal error: Call to a member function on a non-object. The piece of code giving the error is : // Create a collecting type in Oracle // that can hold around 10000 Phone numbs. $szType="CREATE OR REPLACE TYPE PHONELIST AS VARRAY(10000) OF VARCHAR(15)"; $qHandle=OCIParse($szType,$ORACLE); OCIExecute($qHandle); // Insert the Selected Phone numbers $collection = OciNewCollection($ORACLE,"PHONELIST"); for($i=1 ; $i <= $nCount ; $i++) { $collection->append($szMIN[$i]); } We get error in the OCIExecute line . No error was reported for Oracle Connection made by OCINLogon.It seems that oracle parse has failed. But parse is not giving any error though. And followed by fatal error in OCINewCollection(). I found this related to the bug information found in. http://bugs.php.net/bug.php?id=3910 Expected result: ---------------- Page should get loaded properly. Actual result: -------------- Error seen was: Warning: ociexecute(): supplied argument is not a valid OCI8-Statement resource Fatal error: Call to a member function on a non-object. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=39468&edit=1