ID: 29444
User updated by: oguilloux at sopragroup dot com
Reported By: oguilloux at sopragroup dot com
Status: Open
Bug Type: OCI8 related
Operating System: Windows 2000 SP4
PHP Version: 5.0.0
New Comment:
With this code (below) only, my PHP5 (cli version) doesn't terminate
properly. (The program did not finish, it seem to wait about something
that never happens).
=> It's seem to be "OCIParse" which doesn't work. When I use comments
on this line code, the script finish and not when I use the command.
$argDatabasename = 'PNGRS24';
$todo =
"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RS24.PA.SOPRA)(PORT=1542))(CONNECT_DATA=(SID=$argDatabasename)))";
$cn = OCILogon('SYSTEM','MANAGER', $todo);
$stmt = OCIParse($cn,"select * from cols");
$res = OCIExecute($stmt);
ocilogoff($cn);
Previous Comments:
------------------------------------------------------------------------
[2004-08-03 02:12:27] cjbj at hotmail dot com
Can the filer give a better testcase? Does the DB have to
be unmounted? Does ADOdb have to be used?
------------------------------------------------------------------------
[2004-07-29 17:53:44] oguilloux at sopragroup dot com
There's a strange stuff : If I only use, the function oci8 "oci_logon"
even if the database is not connected, it's works. But when I combine
pure oci8 functions with ADO-DB (http://php.weblogs.com) for PHP (which
is useful to be database independant).
I use the "version V3.00 6 Jan 2003" of PHP AdoDB. May be, with the new
Object feature, it could be create some problems ? The most strange
thing is that "oracle" functions work good.
I have tested the AdoDB 4.51 for PHP, but PHP still crash.
------------------------------------------------------------------------
[2004-07-29 16:01:25] [EMAIL PROTECTED]
Yes, probably other suggestions will appear when I can reproduce it
myself.
ATM I can see only predictable warning and nothing more.
------------------------------------------------------------------------
[2004-07-29 15:33:25] oguilloux at sopragroup dot com
Thank's !
sorry, but why it works with oci8/PHP4 and not with oci8/PHP5 ? I don't
believe that the cause is my Oracle client. I often do EXP, IMP and
SQLPLUS with my oracle 8 on oracle 9 database without any troubles.
I restore my config to works with PHP4/oci8 and my web site works
without any problem. The only change was to reconfig apache to use
PHP4.
The more strange feature is that PHP5/oracle extention works better
than oci8.
Have you another suggestion to try ?
Thank's !
------------------------------------------------------------------------
[2004-07-29 15:24:30] [EMAIL PROTECTED]
>My oracle client is 8.1.7 and I wish connected to a Oracle 9.2.0.4
database.
That's weird and can be the reason.
Try to update your client - I can't reproduce this under WIn2k, Oracle
9.2.0.4/Client 9.2.0.4.
------------------------------------------------------------------------
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/29444
--
Edit this bug report at http://bugs.php.net/?id=29444&edit=1
