#39468 [Opn->Bgs]: 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: Bogus Bug Type: OCI8 related Operating System: Windows XP Professional PHP Version: 4.4.4 New Comment: No, if you receive false from oci_execute(), then there was an error, which should have been reported. I don't think it's a problem of PHP, but nevertheless I recommend you to use OCI8 from PECL with PHP4 instead of the bundled one. Previous Comments: ------------------------------------------------------------------------ [2006-11-13 22:24:44] c_peruma at qualcomm dot com The code works fine at my end too. This piece of code is in a session enabled PHP page. But At some point, we are hitting this problem . I found a bug related to this http://bugs.php.net/bug.php?id=3910 where the pages shuttle between working and non-working pages. The problem is not consistent and even we are not able to reproduce. Please clarify whether any problem with PHP - Oracle could cause this error . Thanks Savitha ------------------------------------------------------------------------ [2006-11-13 18:24:16] tony2001@php.net Without this typo your code works just fine, so please provide a real reproduce code. ------------------------------------------------------------------------ [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