ID: 29608 Comment by: symedeot at yahoo dot fr Reported By: tomek at matrox dot pl Status: No Feedback Bug Type: OCI8 related Operating System: W2k, Red Hat PHP Version: 5.0.0 New Comment:
I have exactly the same problem ! If works sometimes, sometime not. If you ask the same page again, it should work or not... Warning: oci_execute() [function.oci-execute]: OCIStmtExecute: ORA-24324: descripteur de service non initialisé in ... Warning: ocifetch() [function.ocifetch]: OCIFetch: ORA-24338: descripteur d'instruction non exécuté in... Just try to access Oracle like this : $conn = OCILogon("GPE", "gpe","PLSE"); $stmt = OCIParse($conn,$myrequest); OCI_Execute($stmt,OCI_DEFAULT); while ( OCIFetch($stmt) ) { } OCIFreeStatement($stmt); OCILogoff($conn); Oracle 9.i under RedHat 9, php 5.00 and 5.01(same), any Apache 2 version. Everything fine on same server when using PHP 4.3x It is clearly a bug ! And we are quite a lot to report it ! Previous Comments: ------------------------------------------------------------------------ [2004-08-19 01:00:08] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2004-08-12 11:02:53] izhekov at ppartner dot com I've tried to reproduce this problem. I've installed 2 apache services on different ports 80 and 81 - first of them using PHP5 and the other using PHP4 then I restarted the system. When first I access my scripts using PHP5 on port 80 everythings goes fine. Running scripts afterthat with PHP4 on port 81 also worked fine. When I tried to access again scripts on apache service running on 80 port, errors occured again: --------- Warning: ociexecute() [function.ociexecute]: OCIStmtExecute: ORA-24324: service handle not initialized in C:\SERVER\HTTPD\htdocs\service\db_modul.php on line 21 Warning: ocifetch() [function.ocifetch]: OCIFetch: ORA-24338: statement handle not executed in C:\SERVER\HTTPD\htdocs\service\db_modul.php on line 27 ---------- ------------------------------------------------------------------------ [2004-08-12 10:09:03] izhekov at ppartner dot com I migrate from PHP 4 to PHP 5 on my Windows 2003 server. Everything goes fine, but when I try to use an PHP application that uses Oracle database I receive the error mentioned above. I restarted the Oracle server but that not helped me. Other applications and PHP 4 works fine with my Oracle server, but PHP 5 did not. Last night the power supply goes down unexpectally and both Oracle server and web server was restarted. Now everything seems to be fine, but I'm sure the problem exists and many people will have the same problems also. Searching in Google for: http://www.google.com/search?hl=bg&ie=UTF-8&q=%22service+handle+not+initialized+in%22+%2Bwarning&lr= shows many sites with the same problem. ------------------------------------------------------------------------ [2004-08-11 17:43:31] [EMAIL PROTECTED] >I think the OCI8 functions did not work at all in PHP 5. you're wrong. OCI8 functions work for most of the people. Perhaps you're misusing them or having some problems with Oracle client/Oracle server. I still need more info to find out what happens and/or to reproduce your situation. Feel free to provide this info and open the bug report again. ------------------------------------------------------------------------ [2004-08-11 16:34:48] izhekov at ppartner dot com I have the same problem. If you search in google for this error, you'll find some sites that have the same problem. I'm using Windows 2003 Server. I think this bug is fatal for many people. I think the OCI8 functions did not work at all in PHP 5. ------------------------------------------------------------------------ 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/29608 -- Edit this bug report at http://bugs.php.net/?id=29608&edit=1