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
설명
resource ora_plogon
( string $user
, string $password
)
Establishes a persistent connection between PHP and an Oracle database.
매개변수
- user
-
The user name.
- password
-
The password associated with user .
반환값
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
