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 — Open a persistent Oracle connection
Description
resource ora_plogon
( string $user
, string $password
)
Establishes a persistent connection between PHP and an Oracle database.
Parameters
- user
-
The user name.
- password
-
The password associated with user .
Return Values
Returns a persistent connection identifier, or FALSE on error.
ora_plogon
digitalCoffee at zdnetonebox dot com
04-Oct-2000 07:16
04-Oct-2000 07:16
