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

ID: 39468 User updated by: c_peruma at qualcomm dot com Reported By: c_peruma at qualcomm dot com Status: Bogus Bug Type: OCI8 related Operating System: Windows XP Professional PHP Version: 4.4.4 New Comment: The scenario we saw was OCIParse has returned false ..but there was no error reported by OCIParse. Next call after OCIParse is OCIExecute and OCIExecute failed with error. Thanks Savitha Previous Comments: ------------------------------------------------------------------------ [2006-11-13 22:29:49] tony2001@php.net 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. ------------------------------------------------------------------------ [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 ) ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/39468 -- Edit this bug report at http://bugs.php.net/?id=39468&edit=1