note 29596 deleted from ref.oci8 by maxim
| From: | maxim@php.net | Date: | Fri, 16 May 2003 01:11:34 +0000 |
| Subject: | note 29596 deleted from ref.oci8 by maxim | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-48070@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.