Edit report at https://bugs.php.net/bug.php?id=63265&edit=1
ID: 63265 Updated by: s...@php.net Reported by: s...@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] s...@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
