Bug #63265 [Asn->Csd]: Add ORA-00028 to the PHP_OCI_HANDLE_ERROR macro
Edit report at https://bugs.php.net/bug.php?id=63265&edit=1
ID: 63265
Updated by: sixd@php.net
Reported by: sixd@php.net
Summary: Add ORA-00028 to the PHP_OCI_HANDLE_ERROR macro
-Status: Assigned
+Status: Closed
Type: Bug
Package: OCI8 related
Operating System: All
PHP Version: 5.4.7
Assigned To: sixd
Block user comment: N
Private report: N
New Comment:
Automatic comment on behalf of sixd
Revision: http://git.php.net/?p=php-src.git;a=commit;h=131dd88505d5a9588ede36b22206bf13965d9137
Log: Fixed bug #63265 (Add ORA-00028 to the PHP_OCI_HANDLE_ERROR macro)
Previous Comments:
------------------------------------------------------------------------
[2012-10-12 02:09:39] sixd@php.net
Description:
------------
The error ORA-00028 "your session has been killed" should be added to the
PHP_OCI_HANDLE_ERROR macro. This would allow a connection that was killed with
ALTER SYSTEM KILL SESSION to be directly marked for re-establishment.
Currently after getting ORA-00028, reusing the connection gives ORA-01012 which
causes the cleanup. Adding ORA-00028 would reduce the number of operations
needed to recover from a DBA killing a session: after getting ORA-00028 the next
connection reuse would "work" because OCI8 has reopened the connection.
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=63265&edit=1
Thread (2 messages)