#29444 [Fbk->Opn]: Crash attemping to connect Oracle via oci8 when database is not mounted

ID: 29444 User updated by: oguilloux at sopragroup dot com Reported By: oguilloux at sopragroup dot com -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: Windows 2000 SP4 PHP Version: 5.0.0 Assigned To: tony2001 New Comment: Thank's ! It's work well now with the new distribution on my "crash" script test (using OCIParse function). But, when I use my real PHP site using "AdoDB for PHP" to connect to Oracle with oci8, it's still crash PHP.exe. I will look about it and search why and where it crashed. Previous Comments: ------------------------------------------------------------------------ [2004-08-13 17:43:34] tony2001@php.net Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip ------------------------------------------------------------------------ [2004-08-03 15:41:41] oguilloux at sopragroup dot com 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); ------------------------------------------------------------------------ [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] tony2001@php.net Yes, probably other suggestions will appear when I can reproduce it myself. ATM I can see only predictable warning and nothing more. ------------------------------------------------------------------------ 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