|   | php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login | 
| 
  [2004-08-11 09:44 UTC] tomek at matrox dot pl
 Description:
------------
I wrote my site using PHP 4.3.8, W2k and Apache in both version 2 and 1.3.x. Everything was all right until the day when I decided to change my php version (now I have 5.0.0)
Scripts which executes oracle queries sometimes works sometimes not. I've notice 2 kinds of situations:
First : apache reports :
Warning: ociexecute() [function.ociexecute]: OCIStmtExecute: ORA-24324: service handle not initialized in /usr/local/apache/htdocs/dupa1.php on line 5 
Second : apache child process is killed
I thought that problem is in OS. I tried to run my site on Red Hat with apache 1.3.31 and php 5.0.0 and problem is still the same.
Changes in version of Oracle client also doesn't resolve the problem.
Reproduce code:
---------------
$query = 'SELECT * FROM opal_sesje';
$conn = ocilogon('xxx','xxx','xxx');
$stmt = OCIParse($conn, $query); 
OCIexecute($stmt, OCI_DEFAULT);
$error = OCIError($stmt);
print_r($error);
Expected result:
----------------
just blank page
Actual result:
--------------
blank page or OCI warning or no result
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits             | |||||||||||||||||||||||||||||||||||||
|  Copyright © 2001-2025 The PHP Group All rights reserved. | Last updated: Fri Oct 31 12:00:01 2025 UTC | 
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 !