note 29596 added to ref.oci8
| From: | ben-at--onshop__dot_co___uk at rack1 dot php dot net | Date: | Tue, 18 Feb 2003 16:22:58 +0000 |
| Subject: | note 29596 added to ref.oci8 | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-44162@lists.php.net to get a copy of this message | ||
Further to the previous comment regarding the browser page hanging when PHP scripts perform
transactions on Oracle and the 'PHP Warning: OCI8 Recursive call!' problem:
On further investigation I discovered with the help of our Oracle DBA that I had created a lock on
the table.
In order to test the effect of different values with my PHP scripts, I was doing UPDATE SQL
statements in SQLPLUS from a telnet session on the webserver on the same record that the PHP script
was trying to update. The SQLPLUS session had locked out the PHP script so it was unable to perform
the transaction. Remedying the problem was simply a case of closing my SQLPLUS session and running
the PHP script again.
--
http://www.php.net/manual/en/ref.oci8.php
http://master.php.net/manage/user-notes.php?action=edit+29596
http://master.php.net/manage/user-notes.php?action=delete+29596
http://master.php.net/manage/user-notes.php?action=reject+29596