ID: 29608 Comment by: artmotion at nurfuerspam dot de 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:
oci_new_connect did the job! One of those things that must be documented much better and brought to the developer's attention. Previous Comments: ------------------------------------------------------------------------ [2004-09-01 10:40:18] marcus dot schuelke at juj dot de This Bug is caused by PHP 5 to fix the problem use oci_new_connect ( username,password, db) instead of ocilogon(); hope that will fix your problem.. ------------------------------------------------------------------------ [2004-09-01 02:51:44] cnichols at nmu dot edu Same problem over here. Running PHP 5.0.1 with Apache2 and Oracle 10g. I found a site saying that errmsg has to do with a soon-to-expire password, but I doubt that's the case for all of you :) ------------------------------------------------------------------------ [2004-08-30 10:21:46] symedeot at yahoo dot fr 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 ! ------------------------------------------------------------------------ [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 ---------- ------------------------------------------------------------------------ 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