When using the persistent login, php obviously does not disconnect, and therefore does not commit any changes you have made to the database. This results in Oracle either locking up, or returning ORA-01554 (Out of transaction slots in transaction tables).
To resolve this, be sure to end your page with ora_commit($connection) (passing in your $connection id).
ora_plogon
(PHP 4, PHP 5 <= 5.0.5)
ora_plogon — 持続的な Oracle接続をオープンする
説明
resource ora_plogon ( string user, string password )指定したユーザ名およびパスワードを用いて PHPとOracleデータベース の間に持続的な接続を確立します。
ora_logon()も参照ください。
ora_plogon
digitalCoffee at zdnetonebox dot com
04-Oct-2000 11:16
04-Oct-2000 11:16