ID: 29608
Comment by: niall at mcphillips dot net
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:
PHP5.0.2 / Apache 1.3.33 / Oracle 9.2.0.5 / RHES 3.0
Both oci_connect and ocilogin fail with:
Warning: ociexecute() [function.ociexecute]: OCIStmtExecute: ORA-24324:
service handle not initialized in /www/htdocs/oratest.php on line 8
oci_new_connect works but appears to force a new connection each time
(overhead?).
Is this a bug?
Previous Comments:
------------------------------------------------------------------------
[2004-09-09 15:10:42] artmotion at nurfuerspam dot de
oci_new_connect did the job!
One of those things that must be documented much better and brought to
the developer's attention.
------------------------------------------------------------------------
[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".
------------------------------------------------------------------------
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
