PHP  
 PHP: Test and Code Coverage Analysis
downloads | QA | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | my php.net 
 

LCOV - code coverage report
Current view: top level - ext/oci8 - oci8.c (source / functions) Hit Total Coverage
Test: PHP Code Coverage Lines: 809 1004 80.6 %
Date: 2014-10-24 Functions: 45 45 100.0 %
Legend: Lines: hit not hit

          Line data    Source code
       1             : /*
       2             :    +----------------------------------------------------------------------+
       3             :    | PHP Version 5                                                        |
       4             :    +----------------------------------------------------------------------+
       5             :    | Copyright (c) 1997-2014 The PHP Group                                |
       6             :    +----------------------------------------------------------------------+
       7             :    | This source file is subject to version 3.01 of the PHP license,      |
       8             :    | that is bundled with this package in the file LICENSE, and is        |
       9             :    | available through the world-wide-web at the following url:           |
      10             :    | http://www.php.net/license/3_01.txt                                  |
      11             :    | If you did not receive a copy of the PHP license and are unable to   |
      12             :    | obtain it through the world-wide-web, please send a note to          |
      13             :    | license@php.net so we can mail you a copy immediately.               |
      14             :    +----------------------------------------------------------------------+
      15             :    | Authors: Stig Sæther Bakken <ssb@php.net>                            |
      16             :    |          Thies C. Arntzen <thies@thieso.net>                         |
      17             :    |          Maxim Maletsky <maxim@maxim.cx>                             |
      18             :    |                                                                      |
      19             :    | Collection support by Andy Sautins <asautins@veripost.net>           |
      20             :    | Temporary LOB support by David Benson <dbenson@mancala.com>          |
      21             :    | ZTS per process OCIPLogon by Harald Radi <harald.radi@nme.at>        |
      22             :    |                                                                      |
      23             :    | Redesigned by: Antony Dovgal <antony@zend.com>                       |
      24             :    |                Andi Gutmans <andi@zend.com>                          |
      25             :    |                Wez Furlong <wez@omniti.com>                          |
      26             :    +----------------------------------------------------------------------+
      27             : */
      28             : 
      29             : /* $Id: cdb1302d3784cf3ece95ed7e5f70998212164e52 $ */
      30             : 
      31             : #ifdef HAVE_CONFIG_H
      32             : #include "config.h"
      33             : #endif
      34             : 
      35             : #include "php.h"
      36             : #include "ext/standard/info.h"
      37             : #include "php_ini.h"
      38             : #include "ext/standard/php_smart_str.h"
      39             : 
      40             : #ifdef HAVE_STDINT_H
      41             : #include <stdint.h>
      42             : #endif
      43             : #ifdef PHP_WIN32
      44             : #include "win32/php_stdint.h"
      45             : #endif
      46             : 
      47             : #if HAVE_OCI8
      48             : 
      49             : #if PHP_MAJOR_VERSION > 5
      50             : #error This version of the PHP OCI8 extension is not compatible with PHP 6 or later
      51             : #elif PHP_MAJOR_VERSION < 5
      52             : #ifdef ZTS
      53             : #error The PHP OCI8 extension does not support ZTS mode in PHP 4
      54             : #endif
      55             : #endif
      56             : 
      57             : #include "php_oci8.h"
      58             : #include "php_oci8_int.h"
      59             : #include "zend_hash.h"
      60             : 
      61             : #if defined(HAVE_STDINT_H) || defined(PHP_WIN32)
      62             : #define OCI8_INT_TO_PTR(I)  ((void *)(intptr_t)(I))
      63             : #define OCI8_PTR_TO_INT(P)  ((int)(intptr_t)(P))
      64             : #else
      65             : #define OCI8_INT_TO_PTR(I)  ((void *)(I))
      66             : #define OCI8_PTR_TO_INT(P)  ((int)(P))
      67             : #endif
      68             : 
      69             : ZEND_DECLARE_MODULE_GLOBALS(oci)
      70             : #if (PHP_MAJOR_VERSION == 5 && PHP_MINOR_VERSION > 1) || (PHP_MAJOR_VERSION > 5)
      71             : /* This "if" allows PECL builds from this file to be portable to older PHP releases */
      72             : static PHP_GINIT_FUNCTION(oci);
      73             : static PHP_GSHUTDOWN_FUNCTION(oci);
      74             : #endif
      75             : 
      76             : /* Allow PHP 5.3 branch to be used in PECL for 5.x compatible builds */
      77             : #ifndef Z_ADDREF_P
      78             : #define Z_ADDREF_P(x) ZVAL_ADDREF(x)
      79             : #endif
      80             : 
      81             : /* For a user friendly message about environment setup */
      82             : #if defined(PHP_WIN32)
      83             : #define PHP_OCI8_LIB_PATH_MSG "PATH"
      84             : #elif defined(__APPLE__)
      85             : #define PHP_OCI8_LIB_PATH_MSG "DYLD_LIBRARY_PATH"
      86             : #elif defined(_AIX)
      87             : #define PHP_OCI8_LIB_PATH_MSG "LIBPATH"
      88             : #elif defined(__hpux)
      89             : #define PHP_OCI8_LIB_PATH_MSG "SHLIB_PATH"
      90             : #else
      91             : #define PHP_OCI8_LIB_PATH_MSG "LD_LIBRARY_PATH"
      92             : #endif
      93             : 
      94             : /* True globals, no need for thread safety */
      95             : int le_connection;
      96             : int le_pconnection;
      97             : int le_statement;
      98             : int le_descriptor;
      99             : int le_psessionpool;
     100             : int le_collection;
     101             : 
     102             : zend_class_entry *oci_lob_class_entry_ptr;
     103             : zend_class_entry *oci_coll_class_entry_ptr;
     104             : 
     105             : #ifndef SQLT_BFILEE
     106             : #define SQLT_BFILEE 114
     107             : #endif
     108             : #ifndef SQLT_CFILEE
     109             : #define SQLT_CFILEE 115
     110             : #endif
     111             : 
     112             : #ifdef OCI_ERROR_MAXMSG_SIZE2
     113             : /* Bigger size is defined from 11.2.0.3 onwards */
     114             : #define PHP_OCI_ERRBUF_LEN OCI_ERROR_MAXMSG_SIZE2
     115             : #else
     116             : #define PHP_OCI_ERRBUF_LEN OCI_ERROR_MAXMSG_SIZE
     117             : #endif 
     118             : 
     119             : #if ZEND_MODULE_API_NO > 20020429
     120             : #define ONUPDATELONGFUNC OnUpdateLong
     121             : #else
     122             : #define ONUPDATELONGFUNC OnUpdateInt
     123             : #endif
     124             : 
     125             : #ifdef ZTS
     126             : #define PHP_OCI_INIT_MODE (OCI_DEFAULT | OCI_OBJECT | OCI_THREADED | OCI_NO_MUTEX)
     127             : #else
     128             : #define PHP_OCI_INIT_MODE (OCI_DEFAULT | OCI_OBJECT)
     129             : #endif
     130             : 
     131             : /* static protos {{{ */
     132             : static void php_oci_connection_list_dtor (zend_rsrc_list_entry * TSRMLS_DC);
     133             : static void php_oci_pconnection_list_dtor (zend_rsrc_list_entry * TSRMLS_DC);
     134             : static void php_oci_pconnection_list_np_dtor (zend_rsrc_list_entry * TSRMLS_DC);
     135             : static void php_oci_statement_list_dtor (zend_rsrc_list_entry * TSRMLS_DC);
     136             : static void php_oci_descriptor_list_dtor (zend_rsrc_list_entry * TSRMLS_DC);
     137             : static void php_oci_spool_list_dtor(zend_rsrc_list_entry *entry TSRMLS_DC);
     138             : static void php_oci_collection_list_dtor (zend_rsrc_list_entry * TSRMLS_DC);
     139             : 
     140             : static int php_oci_persistent_helper(zend_rsrc_list_entry *le TSRMLS_DC);
     141             : static int php_oci_connection_ping(php_oci_connection * TSRMLS_DC);
     142             : static int php_oci_connection_status(php_oci_connection * TSRMLS_DC);
     143             : static int php_oci_connection_close(php_oci_connection * TSRMLS_DC);
     144             : static void php_oci_spool_close(php_oci_spool *session_pool TSRMLS_DC);
     145             : 
     146             : static OCIEnv *php_oci_create_env(ub2 charsetid TSRMLS_DC);
     147             : static int php_oci_create_session(php_oci_connection *connection, php_oci_spool *session_pool, char *dbname, int dbname_len, char *username, int username_len, char *password, int password_len, char *new_password, int new_password_len, int session_mode TSRMLS_DC);
     148             : static int php_oci_old_create_session(php_oci_connection *connection, char *dbname, int dbname_len, char *username, int username_len, char *password, int password_len, char *new_password, int new_password_len, int session_mode TSRMLS_DC);
     149             : static php_oci_spool *php_oci_get_spool(char *username, int username_len, char *password, int password_len, char *dbname, int dbname_len, int charsetid TSRMLS_DC);
     150             : static php_oci_spool *php_oci_create_spool(char *username, int username_len, char *password, int password_len, char *dbname, int dbname_len, char *hash_key, int hash_key_len, int charsetid TSRMLS_DC);
     151             : static sword php_oci_ping_init(php_oci_connection *connection, OCIError *errh TSRMLS_DC);
     152             : /* }}} */
     153             : 
     154             : /* {{{ dynamically loadable module stuff */
     155             : #if defined(COMPILE_DL_OCI8) || defined(COMPILE_DL_OCI8_11G)
     156             : ZEND_GET_MODULE(oci8)
     157             : #endif /* COMPILE_DL */
     158             : /* }}} */
     159             : 
     160             : #ifdef ZEND_ENGINE_2
     161             : 
     162             : /* {{{ Function arginfo */
     163             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_define_by_name, 0, 0, 3)
     164             :         ZEND_ARG_INFO(0, statement_resource)
     165             :         ZEND_ARG_INFO(0, column_name)
     166             :         ZEND_ARG_INFO(1, variable)
     167             :         ZEND_ARG_INFO(0, type)
     168             : ZEND_END_ARG_INFO()
     169             : 
     170             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_bind_by_name, 0, 0, 3)
     171             :         ZEND_ARG_INFO(0, statement_resource)
     172             :         ZEND_ARG_INFO(0, column_name)
     173             :         ZEND_ARG_INFO(1, variable)
     174             :         ZEND_ARG_INFO(0, maximum_length)
     175             :         ZEND_ARG_INFO(0, type)
     176             : ZEND_END_ARG_INFO()
     177             : 
     178             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_bind_array_by_name, 0, 0, 4)
     179             :         ZEND_ARG_INFO(0, statement_resource)
     180             :         ZEND_ARG_INFO(0, column_name)
     181             :         ZEND_ARG_INFO(1, variable)
     182             :         ZEND_ARG_INFO(0, maximum_array_length)
     183             :         ZEND_ARG_INFO(0, maximum_item_length)
     184             :         ZEND_ARG_INFO(0, type)
     185             : ZEND_END_ARG_INFO()
     186             : 
     187             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_free_descriptor, 0, 0, 1)
     188             :         ZEND_ARG_INFO(0, lob_descriptor)
     189             : ZEND_END_ARG_INFO()
     190             : 
     191             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_save, 0, 0, 2)
     192             :         ZEND_ARG_INFO(0, lob_descriptor)
     193             :         ZEND_ARG_INFO(0, data)
     194             :         ZEND_ARG_INFO(0, offset)
     195             : ZEND_END_ARG_INFO()
     196             : 
     197             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_import, 0, 0, 2)
     198             :         ZEND_ARG_INFO(0, lob_descriptor)
     199             :         ZEND_ARG_INFO(0, filename)
     200             : ZEND_END_ARG_INFO()
     201             : 
     202             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_load, 0, 0, 1)
     203             :         ZEND_ARG_INFO(0, lob_descriptor)
     204             : ZEND_END_ARG_INFO()
     205             : 
     206             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_read, 0, 0, 2)
     207             :         ZEND_ARG_INFO(0, lob_descriptor)
     208             :         ZEND_ARG_INFO(0, length)
     209             : ZEND_END_ARG_INFO()
     210             : 
     211             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_eof, 0, 0, 1)
     212             :         ZEND_ARG_INFO(0, lob_descriptor)
     213             : ZEND_END_ARG_INFO()
     214             : 
     215             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_tell, 0, 0, 1)
     216             :         ZEND_ARG_INFO(0, lob_descriptor)
     217             : ZEND_END_ARG_INFO()
     218             : 
     219             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_rewind, 0, 0, 1)
     220             :         ZEND_ARG_INFO(0, lob_descriptor)
     221             : ZEND_END_ARG_INFO()
     222             : 
     223             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_seek, 0, 0, 2)
     224             :         ZEND_ARG_INFO(0, lob_descriptor)
     225             :         ZEND_ARG_INFO(0, offset)
     226             :         ZEND_ARG_INFO(0, whence)
     227             : ZEND_END_ARG_INFO()
     228             : 
     229             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_size, 0, 0, 1)
     230             :         ZEND_ARG_INFO(0, lob_descriptor)
     231             : ZEND_END_ARG_INFO()
     232             : 
     233             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_write, 0, 0, 2)
     234             :         ZEND_ARG_INFO(0, lob_descriptor)
     235             :         ZEND_ARG_INFO(0, string)
     236             :         ZEND_ARG_INFO(0, length)
     237             : ZEND_END_ARG_INFO()
     238             : 
     239             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_append, 0, 0, 2)
     240             :         ZEND_ARG_INFO(0, lob_descriptor_to)
     241             :         ZEND_ARG_INFO(0, lob_descriptor_from)
     242             : ZEND_END_ARG_INFO()
     243             : 
     244             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_truncate, 0, 0, 1)
     245             :         ZEND_ARG_INFO(0, lob_descriptor)
     246             :         ZEND_ARG_INFO(0, length)
     247             : ZEND_END_ARG_INFO()
     248             : 
     249             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_erase, 0, 0, 1)
     250             :         ZEND_ARG_INFO(0, lob_descriptor)
     251             :         ZEND_ARG_INFO(0, offset)
     252             :         ZEND_ARG_INFO(0, length)
     253             : ZEND_END_ARG_INFO()
     254             : 
     255             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_flush, 0, 0, 1)
     256             :         ZEND_ARG_INFO(0, lob_descriptor)
     257             :         ZEND_ARG_INFO(0, flag)
     258             : ZEND_END_ARG_INFO()
     259             : 
     260             : ZEND_BEGIN_ARG_INFO_EX(arginfo_ocisetbufferinglob, 0, 0, 2)
     261             :         ZEND_ARG_INFO(0, lob_descriptor)
     262             :         ZEND_ARG_INFO(0, mode)
     263             : ZEND_END_ARG_INFO()
     264             : 
     265             : ZEND_BEGIN_ARG_INFO_EX(arginfo_ocigetbufferinglob, 0, 0, 1)
     266             :         ZEND_ARG_INFO(0, lob_descriptor)
     267             : ZEND_END_ARG_INFO()
     268             : 
     269             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_copy, 0, 0, 2)
     270             :         ZEND_ARG_INFO(0, lob_descriptor_to)
     271             :         ZEND_ARG_INFO(0, lob_descriptor_from)
     272             :         ZEND_ARG_INFO(0, length)
     273             : ZEND_END_ARG_INFO()
     274             : 
     275             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_is_equal, 0, 0, 2)
     276             :         ZEND_ARG_INFO(0, lob_descriptor)
     277             :         ZEND_ARG_INFO(0, lob_descriptor)
     278             : ZEND_END_ARG_INFO()
     279             : 
     280             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_export, 0, 0, 2)
     281             :         ZEND_ARG_INFO(0, lob_descriptor)
     282             :         ZEND_ARG_INFO(0, filename)
     283             :         ZEND_ARG_INFO(0, start)
     284             :         ZEND_ARG_INFO(0, length)
     285             : ZEND_END_ARG_INFO()
     286             : 
     287             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_new_descriptor, 0, 0, 1)
     288             :         ZEND_ARG_INFO(0, connection_resource)
     289             :         ZEND_ARG_INFO(0, type)
     290             : ZEND_END_ARG_INFO()
     291             : 
     292             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_rollback, 0, 0, 1)
     293             :         ZEND_ARG_INFO(0, connection_resource)
     294             : ZEND_END_ARG_INFO()
     295             : 
     296             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_commit, 0, 0, 1)
     297             :         ZEND_ARG_INFO(0, connection_resource)
     298             : ZEND_END_ARG_INFO()
     299             : 
     300             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_field_name, 0, 0, 2)
     301             :         ZEND_ARG_INFO(0, statement_resource)
     302             :         ZEND_ARG_INFO(0, column_number)
     303             : ZEND_END_ARG_INFO()
     304             : 
     305             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_field_size, 0, 0, 2)
     306             :         ZEND_ARG_INFO(0, statement_resource)
     307             :         ZEND_ARG_INFO(0, column_number_or_name)
     308             : ZEND_END_ARG_INFO()
     309             : 
     310             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_field_scale, 0, 0, 2)
     311             :         ZEND_ARG_INFO(0, statement_resource)
     312             :         ZEND_ARG_INFO(0, column_number)
     313             : ZEND_END_ARG_INFO()
     314             : 
     315             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_field_precision, 0, 0, 2)
     316             :         ZEND_ARG_INFO(0, statement_resource)
     317             :         ZEND_ARG_INFO(0, column_number)
     318             : ZEND_END_ARG_INFO()
     319             : 
     320             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_field_type, 0, 0, 2)
     321             :         ZEND_ARG_INFO(0, statement_resource)
     322             :         ZEND_ARG_INFO(0, column_number)
     323             : ZEND_END_ARG_INFO()
     324             : 
     325             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_field_type_raw, 0, 0, 2)
     326             :         ZEND_ARG_INFO(0, statement_resource)
     327             :         ZEND_ARG_INFO(0, column_number)
     328             : ZEND_END_ARG_INFO()
     329             : 
     330             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_field_is_null, 0, 0, 2)
     331             :         ZEND_ARG_INFO(0, statement_resource)
     332             :         ZEND_ARG_INFO(0, column_number_or_name)
     333             : ZEND_END_ARG_INFO()
     334             : 
     335             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_internal_debug, 0, 0, 1)
     336             :         ZEND_ARG_INFO(0, mode)
     337             : ZEND_END_ARG_INFO()
     338             : 
     339             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_execute, 0, 0, 1)
     340             :         ZEND_ARG_INFO(0, statement_resource)
     341             :         ZEND_ARG_INFO(0, mode)
     342             : ZEND_END_ARG_INFO()
     343             : 
     344             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_cancel, 0, 0, 1)
     345             :         ZEND_ARG_INFO(0, statement_resource)
     346             : ZEND_END_ARG_INFO()
     347             : 
     348             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_fetch, 0, 0, 1)
     349             :         ZEND_ARG_INFO(0, statement_resource)
     350             : ZEND_END_ARG_INFO()
     351             : 
     352             : ZEND_BEGIN_ARG_INFO_EX(arginfo_ocifetchinto, 0, 0, 2)
     353             :         ZEND_ARG_INFO(0, statement_resource)
     354             :         ZEND_ARG_INFO(1, result)
     355             :         ZEND_ARG_INFO(0, mode)
     356             : ZEND_END_ARG_INFO()
     357             : 
     358             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_fetch_all, 0, 0, 2)
     359             :         ZEND_ARG_INFO(0, statement_resource)
     360             :         ZEND_ARG_INFO(1, output)
     361             :         ZEND_ARG_INFO(0, skip)
     362             :         ZEND_ARG_INFO(0, maximum_rows)
     363             :         ZEND_ARG_INFO(0, flags)
     364             : ZEND_END_ARG_INFO()
     365             : 
     366             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_fetch_object, 0, 0, 1)
     367             :         ZEND_ARG_INFO(0, statement_resource)
     368             : ZEND_END_ARG_INFO()
     369             : 
     370             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_fetch_row, 0, 0, 1)
     371             :         ZEND_ARG_INFO(0, statement_resource)
     372             : ZEND_END_ARG_INFO()
     373             : 
     374             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_fetch_assoc, 0, 0, 1)
     375             :         ZEND_ARG_INFO(0, statement_resource)
     376             : ZEND_END_ARG_INFO()
     377             : 
     378             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_fetch_array, 0, 0, 1)
     379             :         ZEND_ARG_INFO(0, statement_resource)
     380             :         ZEND_ARG_INFO(0, mode)
     381             : ZEND_END_ARG_INFO()
     382             : 
     383             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_free_statement, 0, 0, 1)
     384             :         ZEND_ARG_INFO(0, statement_resource)
     385             : ZEND_END_ARG_INFO()
     386             : 
     387             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_close, 0, 0, 1)
     388             :         ZEND_ARG_INFO(0, connection_resource)
     389             : ZEND_END_ARG_INFO()
     390             : 
     391             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_new_connect, 0, 0, 2)
     392             :         ZEND_ARG_INFO(0, username)
     393             :         ZEND_ARG_INFO(0, password)
     394             :         ZEND_ARG_INFO(0, connection_string)
     395             :         ZEND_ARG_INFO(0, character_set)
     396             :         ZEND_ARG_INFO(0, session_mode)
     397             : ZEND_END_ARG_INFO()
     398             : 
     399             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_connect, 0, 0, 2)
     400             :         ZEND_ARG_INFO(0, username)
     401             :         ZEND_ARG_INFO(0, password)
     402             :         ZEND_ARG_INFO(0, connection_string)
     403             :         ZEND_ARG_INFO(0, character_set)
     404             :         ZEND_ARG_INFO(0, session_mode)
     405             : ZEND_END_ARG_INFO()
     406             : 
     407             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_pconnect, 0, 0, 2)
     408             :         ZEND_ARG_INFO(0, username)
     409             :         ZEND_ARG_INFO(0, password)
     410             :         ZEND_ARG_INFO(0, connection_string)
     411             :         ZEND_ARG_INFO(0, character_set)
     412             :         ZEND_ARG_INFO(0, session_mode)
     413             : ZEND_END_ARG_INFO()
     414             : 
     415             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_error, 0, 0, 0)
     416             :         ZEND_ARG_INFO(0, connection_or_statement_resource)
     417             : ZEND_END_ARG_INFO()
     418             : 
     419             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_num_fields, 0, 0, 1)
     420             :         ZEND_ARG_INFO(0, statement_resource)
     421             : ZEND_END_ARG_INFO()
     422             : 
     423             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_parse, 0, 0, 2)
     424             :         ZEND_ARG_INFO(0, connection_resource)
     425             :         ZEND_ARG_INFO(0, sql_text)
     426             : ZEND_END_ARG_INFO()
     427             : 
     428             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_set_prefetch, 0, 0, 2)
     429             :         ZEND_ARG_INFO(0, statement_resource)
     430             :         ZEND_ARG_INFO(0, number_of_rows)
     431             : ZEND_END_ARG_INFO()
     432             : 
     433             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_set_client_identifier, 0, 0, 2)
     434             :         ZEND_ARG_INFO(0, connection_resource)
     435             :         ZEND_ARG_INFO(0, client_identifier)
     436             : ZEND_END_ARG_INFO()
     437             : 
     438             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_set_edition, 0, 0, 1)
     439             :         ZEND_ARG_INFO(0, edition_name)
     440             : ZEND_END_ARG_INFO()
     441             : 
     442             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_set_module_name, 0, 0, 2)
     443             :         ZEND_ARG_INFO(0, connection_resource)
     444             :         ZEND_ARG_INFO(0, module_name)
     445             : ZEND_END_ARG_INFO()
     446             : 
     447             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_set_action, 0, 0, 2)
     448             :         ZEND_ARG_INFO(0, connection_resource)
     449             :         ZEND_ARG_INFO(0, action)
     450             : ZEND_END_ARG_INFO()
     451             : 
     452             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_set_client_info, 0, 0, 2)
     453             :         ZEND_ARG_INFO(0, connection_resource)
     454             :         ZEND_ARG_INFO(0, client_information)
     455             : ZEND_END_ARG_INFO()
     456             : 
     457             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_password_change, 0, 0, 4)
     458             :         ZEND_ARG_INFO(0, connection_resource_or_connection_string)
     459             :         ZEND_ARG_INFO(0, username)
     460             :         ZEND_ARG_INFO(0, old_password)
     461             :         ZEND_ARG_INFO(0, new_password)
     462             : ZEND_END_ARG_INFO()
     463             : 
     464             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_new_cursor, 0, 0, 1)
     465             :         ZEND_ARG_INFO(0, connection_resource)
     466             : ZEND_END_ARG_INFO()
     467             : 
     468             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_result, 0, 0, 2)
     469             :         ZEND_ARG_INFO(0, statement_resource)
     470             :         ZEND_ARG_INFO(0, column_number_or_name)
     471             : ZEND_END_ARG_INFO()
     472             : 
     473             : ZEND_BEGIN_ARG_INFO(arginfo_oci_client_version, 0)
     474             : ZEND_END_ARG_INFO()
     475             : 
     476             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_server_version, 0, 0, 1)
     477             :         ZEND_ARG_INFO(0, connection_resource)
     478             : ZEND_END_ARG_INFO()
     479             : 
     480             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_statement_type, 0, 0, 1)
     481             :         ZEND_ARG_INFO(0, statement_resource)
     482             : ZEND_END_ARG_INFO()
     483             : 
     484             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_num_rows, 0, 0, 1)
     485             :         ZEND_ARG_INFO(0, statement_resource)
     486             : ZEND_END_ARG_INFO()
     487             : 
     488             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_free_collection, 0, 0, 1)
     489             :         ZEND_ARG_INFO(0, collection)
     490             : ZEND_END_ARG_INFO()
     491             : 
     492             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_collection_append, 0, 0, 2)
     493             :         ZEND_ARG_INFO(0, collection)
     494             :         ZEND_ARG_INFO(0, value)
     495             : ZEND_END_ARG_INFO()
     496             : 
     497             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_collection_element_get, 0, 0, 2)
     498             :         ZEND_ARG_INFO(0, collection)
     499             :         ZEND_ARG_INFO(0, index)
     500             : ZEND_END_ARG_INFO()
     501             : 
     502             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_collection_assign, 0, 0, 2)
     503             :         ZEND_ARG_INFO(0, collection_to)
     504             :         ZEND_ARG_INFO(0, collection_from)
     505             : ZEND_END_ARG_INFO()
     506             : 
     507             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_collection_element_assign, 0, 0, 3)
     508             :         ZEND_ARG_INFO(0, collection)
     509             :         ZEND_ARG_INFO(0, index)
     510             :         ZEND_ARG_INFO(0, value)
     511             : ZEND_END_ARG_INFO()
     512             : 
     513             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_collection_size, 0, 0, 1)
     514             :         ZEND_ARG_INFO(0, collection)
     515             : ZEND_END_ARG_INFO()
     516             : 
     517             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_collection_max, 0, 0, 1)
     518             :         ZEND_ARG_INFO(0, collection)
     519             : ZEND_END_ARG_INFO()
     520             : 
     521             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_collection_trim, 0, 0, 2)
     522             :         ZEND_ARG_INFO(0, collection)
     523             :         ZEND_ARG_INFO(0, number)
     524             : ZEND_END_ARG_INFO()
     525             : 
     526             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_new_collection, 0, 0, 2)
     527             :         ZEND_ARG_INFO(0, connection_resource)
     528             :         ZEND_ARG_INFO(0, type_name)
     529             :         ZEND_ARG_INFO(0, schema_name)
     530             : ZEND_END_ARG_INFO()
     531             : /* }}} */
     532             : 
     533             : /* {{{ LOB Method arginfo */
     534             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_save_method, 0, 0, 1)
     535             :         ZEND_ARG_INFO(0, data)
     536             :         ZEND_ARG_INFO(0, offset)
     537             : ZEND_END_ARG_INFO()
     538             : 
     539             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_import_method, 0, 0, 1)
     540             :         ZEND_ARG_INFO(0, filename)
     541             : ZEND_END_ARG_INFO()
     542             : 
     543             : ZEND_BEGIN_ARG_INFO(arginfo_oci_lob_load_method, 0)
     544             : ZEND_END_ARG_INFO()
     545             : 
     546             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_read_method, 0, 0, 1)
     547             :         ZEND_ARG_INFO(0, length)
     548             : ZEND_END_ARG_INFO()
     549             : 
     550             : ZEND_BEGIN_ARG_INFO(arginfo_oci_lob_eof_method, 0)
     551             : ZEND_END_ARG_INFO()
     552             : 
     553             : ZEND_BEGIN_ARG_INFO(arginfo_oci_lob_tell_method, 0)
     554             : ZEND_END_ARG_INFO()
     555             : 
     556             : ZEND_BEGIN_ARG_INFO(arginfo_oci_lob_rewind_method, 0)
     557             : ZEND_END_ARG_INFO()
     558             : 
     559             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_seek_method, 0, 0, 1)
     560             :         ZEND_ARG_INFO(0, offset)
     561             :         ZEND_ARG_INFO(0, whence)
     562             : ZEND_END_ARG_INFO()
     563             : 
     564             : ZEND_BEGIN_ARG_INFO(arginfo_oci_lob_size_method, 0)
     565             : ZEND_END_ARG_INFO()
     566             : 
     567             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_write_method, 0, 0, 1)
     568             :         ZEND_ARG_INFO(0, string)
     569             :         ZEND_ARG_INFO(0, length)
     570             : ZEND_END_ARG_INFO()
     571             : 
     572             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_append_method, 0, 0, 1)
     573             :         ZEND_ARG_INFO(0, lob_descriptor_from)
     574             : ZEND_END_ARG_INFO()
     575             : 
     576             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_truncate_method, 0, 0, 0)
     577             :         ZEND_ARG_INFO(0, length)
     578             : ZEND_END_ARG_INFO()
     579             : 
     580             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_erase_method, 0, 0, 0)
     581             :         ZEND_ARG_INFO(0, offset)
     582             :         ZEND_ARG_INFO(0, length)
     583             : ZEND_END_ARG_INFO()
     584             : 
     585             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_flush_method, 0, 0, 0)
     586             :         ZEND_ARG_INFO(0, flag)
     587             : ZEND_END_ARG_INFO()
     588             : 
     589             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_setbuffering_method, 0, 0, 1)
     590             :         ZEND_ARG_INFO(0, mode)
     591             : ZEND_END_ARG_INFO()
     592             : 
     593             : ZEND_BEGIN_ARG_INFO(arginfo_oci_lob_getbuffering_method, 0)
     594             : ZEND_END_ARG_INFO()
     595             : 
     596             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_export_method, 0, 0, 1)
     597             :         ZEND_ARG_INFO(0, filename)
     598             :         ZEND_ARG_INFO(0, start)
     599             :         ZEND_ARG_INFO(0, length)
     600             : ZEND_END_ARG_INFO()
     601             : 
     602             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_lob_write_temporary_method, 0, 0, 1)
     603             :         ZEND_ARG_INFO(0, data)
     604             :         ZEND_ARG_INFO(0, type)
     605             : ZEND_END_ARG_INFO()
     606             : 
     607             : ZEND_BEGIN_ARG_INFO(arginfo_oci_lob_close_method, 0)
     608             : ZEND_END_ARG_INFO()
     609             : 
     610             : ZEND_BEGIN_ARG_INFO(arginfo_oci_free_descriptor_method, 0)
     611             : ZEND_END_ARG_INFO()
     612             : /* }}} */
     613             : 
     614             : /* {{{ Collection Method arginfo */
     615             : ZEND_BEGIN_ARG_INFO(arginfo_oci_collection_free_method, 0)
     616             : ZEND_END_ARG_INFO()
     617             : 
     618             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_collection_append_method, 0, 0, 1)
     619             :         ZEND_ARG_INFO(0, value)
     620             : ZEND_END_ARG_INFO()
     621             : 
     622             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_collection_element_get_method, 0, 0, 1)
     623             :         ZEND_ARG_INFO(0, index)
     624             : ZEND_END_ARG_INFO()
     625             : 
     626             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_collection_assign_method, 0, 0, 1)
     627             :         ZEND_ARG_INFO(0, collection_from)
     628             : ZEND_END_ARG_INFO()
     629             : 
     630             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_collection_element_assign_method, 0, 0, 2)
     631             :         ZEND_ARG_INFO(0, index)
     632             :         ZEND_ARG_INFO(0, value)
     633             : ZEND_END_ARG_INFO()
     634             : 
     635             : ZEND_BEGIN_ARG_INFO(arginfo_oci_collection_size_method, 0)
     636             : ZEND_END_ARG_INFO()
     637             : 
     638             : ZEND_BEGIN_ARG_INFO(arginfo_oci_collection_max_method, 0)
     639             : ZEND_END_ARG_INFO()
     640             : 
     641             : ZEND_BEGIN_ARG_INFO_EX(arginfo_oci_collection_trim_method, 0, 0, 1)
     642             :         ZEND_ARG_INFO(0, number)
     643             : ZEND_END_ARG_INFO()
     644             : /* }}} */
     645             : 
     646             : #else /* ZEND_ENGINE_2 */
     647             : /* {{{ Keep the old arginfo behavior when building with PHP 4 */
     648             : 
     649             : static unsigned char arginfo_ocifetchinto[]  = { 2, BYREF_NONE, BYREF_FORCE };
     650             : static unsigned char arginfo_oci_fetch_all[] = { 2, BYREF_NONE, BYREF_FORCE };
     651             : static unsigned char arginfo_oci_define_by_name[] = { 3, BYREF_NONE, BYREF_NONE, BYREF_FORCE };
     652             : static unsigned char arginfo_oci_bind_by_name[] = { 3, BYREF_NONE, BYREF_NONE, BYREF_FORCE };
     653             : static unsigned char arginfo_oci_bind_array_by_name[] = { 3, BYREF_NONE, BYREF_NONE, BYREF_FORCE };
     654             : 
     655             : #define arginfo_oci_free_descriptor                                             NULL
     656             : #define arginfo_oci_lob_save                                                    NULL
     657             : #define arginfo_oci_lob_import                                                  NULL
     658             : #define arginfo_oci_lob_load                                                    NULL
     659             : #define arginfo_oci_lob_read                                                    NULL
     660             : #define arginfo_oci_lob_eof                                                             NULL
     661             : #define arginfo_oci_lob_tell                                                    NULL
     662             : #define arginfo_oci_lob_rewind                                                  NULL
     663             : #define arginfo_oci_lob_seek                                                    NULL
     664             : #define arginfo_oci_lob_size                                                    NULL
     665             : #define arginfo_oci_lob_write                                                   NULL
     666             : #define arginfo_oci_lob_append                                                  NULL
     667             : #define arginfo_oci_lob_truncate                                                NULL
     668             : #define arginfo_oci_lob_erase                                                   NULL
     669             : #define arginfo_oci_lob_flush                                                   NULL
     670             : #define arginfo_ocisetbufferinglob                                              NULL
     671             : #define arginfo_ocigetbufferinglob                                              NULL
     672             : #define arginfo_oci_lob_copy                                                    NULL
     673             : #define arginfo_oci_lob_is_equal                                                NULL
     674             : #define arginfo_oci_lob_export                                                  NULL
     675             : #define arginfo_oci_new_descriptor                                              NULL
     676             : #define arginfo_oci_rollback                                                    NULL
     677             : #define arginfo_oci_commit                                                              NULL
     678             : #define arginfo_oci_field_name                                                  NULL
     679             : #define arginfo_oci_field_size                                                  NULL
     680             : #define arginfo_oci_field_scale                                                 NULL
     681             : #define arginfo_oci_field_precision                                             NULL
     682             : #define arginfo_oci_field_type                                                  NULL
     683             : #define arginfo_oci_field_type_raw                                              NULL
     684             : #define arginfo_oci_field_is_null                                               NULL
     685             : #define arginfo_oci_internal_debug                                              NULL
     686             : #define arginfo_oci_execute                                                             NULL
     687             : #define arginfo_oci_cancel                                                              NULL
     688             : #define arginfo_oci_fetch                                                               NULL
     689             : #define arginfo_oci_fetch_object                                                NULL
     690             : #define arginfo_oci_fetch_row                                                   NULL
     691             : #define arginfo_oci_fetch_assoc                                                 NULL
     692             : #define arginfo_oci_fetch_array                                                 NULL
     693             : #define arginfo_oci_free_statement                                              NULL
     694             : #define arginfo_oci_close                                                               NULL
     695             : #define arginfo_oci_new_connect                                                 NULL
     696             : #define arginfo_oci_connect                                                             NULL
     697             : #define arginfo_oci_pconnect                                                    NULL
     698             : #define arginfo_oci_error                                                               NULL
     699             : #define arginfo_oci_num_fields                                                  NULL
     700             : #define arginfo_oci_parse                                                               NULL
     701             : #define arginfo_oci_set_prefetch                                                NULL
     702             : #define arginfo_oci_set_client_identifier                               NULL
     703             : #define arginfo_oci_set_edition                                                 NULL
     704             : #define arginfo_oci_set_module_name                                             NULL
     705             : #define arginfo_oci_set_action                                                  NULL
     706             : #define arginfo_oci_set_client_info                                             NULL
     707             : #define arginfo_oci_password_change                                             NULL
     708             : #define arginfo_oci_new_cursor                                                  NULL
     709             : #define arginfo_oci_result                                                              NULL
     710             : #define arginfo_oci_client_version                                              NULL
     711             : #define arginfo_oci_server_version                                              NULL
     712             : #define arginfo_oci_statement_type                                              NULL
     713             : #define arginfo_oci_num_rows                                                    NULL
     714             : #define arginfo_oci_free_collection                                             NULL
     715             : #define arginfo_oci_collection_append                                   NULL
     716             : #define arginfo_oci_collection_element_get                              NULL
     717             : #define arginfo_oci_collection_assign                                   NULL
     718             : #define arginfo_oci_collection_element_assign                   NULL
     719             : #define arginfo_oci_collection_size                                             NULL
     720             : #define arginfo_oci_collection_max                                              NULL
     721             : #define arginfo_oci_collection_trim                                             NULL
     722             : #define arginfo_oci_new_collection                                              NULL
     723             : #define arginfo_oci_lob_size_method                                             NULL
     724             : #define arginfo_oci_lob_getbuffering_method                             NULL
     725             : #define arginfo_oci_lob_close_method                                    NULL
     726             : #define arginfo_oci_lob_save_method                                             NULL
     727             : #define arginfo_oci_lob_import_method                                   NULL
     728             : #define arginfo_oci_lob_read_method                                             NULL
     729             : #define arginfo_oci_lob_seek_method                                             NULL
     730             : #define arginfo_oci_lob_write_method                                    NULL
     731             : #define arginfo_oci_lob_append_method                                   NULL
     732             : #define arginfo_oci_lob_truncate_method                                 NULL
     733             : #define arginfo_oci_lob_erase_method                                    NULL
     734             : #define arginfo_oci_lob_flush_method                                    NULL
     735             : #define arginfo_oci_lob_setbuffering_method                             NULL
     736             : #define arginfo_oci_lob_export_method                                   NULL
     737             : #define arginfo_oci_lob_write_temporary_method                  NULL
     738             : #define arginfo_oci_lob_load_method                                             NULL
     739             : #define arginfo_oci_lob_tell_method                                             NULL
     740             : #define arginfo_oci_lob_rewind_method                                   NULL
     741             : #define arginfo_oci_lob_eof_method                                              NULL
     742             : #define arginfo_oci_free_descriptor_method                              NULL
     743             : #define arginfo_oci_collection_append_method                    NULL
     744             : #define arginfo_oci_collection_element_get_method               NULL
     745             : #define arginfo_oci_collection_assign_method                    NULL
     746             : #define arginfo_oci_collection_size_method                              NULL
     747             : #define arginfo_oci_collection_element_assign_method    NULL
     748             : #define arginfo_oci_collection_max_method                               NULL
     749             : #define arginfo_oci_collection_trim_method                              NULL
     750             : #define arginfo_oci_collection_free_method                              NULL
     751             : /* }}} */
     752             : #endif /* ZEND_ENGINE_2 */
     753             : 
     754             : /* {{{ extension function prototypes
     755             : */
     756             : PHP_FUNCTION(oci_bind_by_name);
     757             : PHP_FUNCTION(oci_bind_array_by_name);
     758             : PHP_FUNCTION(oci_define_by_name);
     759             : PHP_FUNCTION(oci_field_is_null);
     760             : PHP_FUNCTION(oci_field_name);
     761             : PHP_FUNCTION(oci_field_size);
     762             : PHP_FUNCTION(oci_field_scale);
     763             : PHP_FUNCTION(oci_field_precision);
     764             : PHP_FUNCTION(oci_field_type);
     765             : PHP_FUNCTION(oci_field_type_raw);
     766             : PHP_FUNCTION(oci_execute);
     767             : PHP_FUNCTION(oci_fetch);
     768             : PHP_FUNCTION(oci_cancel);
     769             : PHP_FUNCTION(ocifetchinto);
     770             : PHP_FUNCTION(oci_fetch_object);
     771             : PHP_FUNCTION(oci_fetch_row);
     772             : PHP_FUNCTION(oci_fetch_assoc);
     773             : PHP_FUNCTION(oci_fetch_array);
     774             : PHP_FUNCTION(ocifetchstatement);
     775             : PHP_FUNCTION(oci_fetch_all);
     776             : PHP_FUNCTION(oci_free_statement);
     777             : PHP_FUNCTION(oci_internal_debug);
     778             : PHP_FUNCTION(oci_close);
     779             : PHP_FUNCTION(oci_connect);
     780             : PHP_FUNCTION(oci_new_connect);
     781             : PHP_FUNCTION(oci_pconnect);
     782             : PHP_FUNCTION(oci_error);
     783             : PHP_FUNCTION(oci_free_descriptor);
     784             : PHP_FUNCTION(oci_commit);
     785             : PHP_FUNCTION(oci_rollback);
     786             : PHP_FUNCTION(oci_new_descriptor);
     787             : PHP_FUNCTION(oci_num_fields);
     788             : PHP_FUNCTION(oci_parse);
     789             : PHP_FUNCTION(oci_new_cursor);
     790             : PHP_FUNCTION(oci_result);
     791             : PHP_FUNCTION(oci_client_version);
     792             : PHP_FUNCTION(oci_server_version);
     793             : PHP_FUNCTION(oci_statement_type);
     794             : PHP_FUNCTION(oci_num_rows);
     795             : PHP_FUNCTION(oci_set_prefetch);
     796             : PHP_FUNCTION(oci_set_client_identifier);
     797             : PHP_FUNCTION(oci_set_edition);
     798             : PHP_FUNCTION(oci_set_module_name);
     799             : PHP_FUNCTION(oci_set_action);
     800             : PHP_FUNCTION(oci_set_client_info);
     801             : PHP_FUNCTION(oci_password_change);
     802             : PHP_FUNCTION(oci_lob_save);
     803             : PHP_FUNCTION(oci_lob_import);
     804             : PHP_FUNCTION(oci_lob_export);
     805             : PHP_FUNCTION(oci_lob_load);
     806             : PHP_FUNCTION(oci_lob_tell);
     807             : PHP_FUNCTION(oci_lob_write);
     808             : PHP_FUNCTION(oci_lob_append);
     809             : PHP_FUNCTION(oci_lob_copy);
     810             : PHP_FUNCTION(oci_lob_truncate);
     811             : PHP_FUNCTION(oci_lob_erase);
     812             : PHP_FUNCTION(oci_lob_flush);
     813             : PHP_FUNCTION(ocisetbufferinglob);
     814             : PHP_FUNCTION(ocigetbufferinglob);
     815             : PHP_FUNCTION(oci_lob_is_equal);
     816             : PHP_FUNCTION(oci_lob_rewind);
     817             : PHP_FUNCTION(oci_lob_read);
     818             : PHP_FUNCTION(oci_lob_eof);
     819             : PHP_FUNCTION(oci_lob_seek);
     820             : PHP_FUNCTION(oci_lob_size);
     821             : PHP_FUNCTION(oci_lob_write_temporary);
     822             : PHP_FUNCTION(oci_lob_close);
     823             : PHP_FUNCTION(oci_new_collection);
     824             : PHP_FUNCTION(oci_free_collection);
     825             : PHP_FUNCTION(oci_collection_append);
     826             : PHP_FUNCTION(oci_collection_element_get);
     827             : PHP_FUNCTION(oci_collection_element_assign);
     828             : PHP_FUNCTION(oci_collection_assign);
     829             : PHP_FUNCTION(oci_collection_size);
     830             : PHP_FUNCTION(oci_collection_max);
     831             : PHP_FUNCTION(oci_collection_trim);
     832             : /* }}} */
     833             : 
     834             : /* {{{ extension definition structures
     835             : */
     836             : static
     837             : #if (PHP_MAJOR_VERSION == 5 && PHP_MINOR_VERSION > 2) || (PHP_MAJOR_VERSION > 5)
     838             : /* This "if" allows PECL builds from this file to be portable to older PHP releases */
     839             : const
     840             : #endif
     841             : zend_function_entry php_oci_functions[] = {
     842             :         PHP_FE(oci_define_by_name,                      arginfo_oci_define_by_name)
     843             :         PHP_FE(oci_bind_by_name,                        arginfo_oci_bind_by_name)
     844             :         PHP_FE(oci_bind_array_by_name,          arginfo_oci_bind_array_by_name)
     845             :         PHP_FE(oci_field_is_null,                       arginfo_oci_field_is_null)
     846             :         PHP_FE(oci_field_name,                          arginfo_oci_field_name)
     847             :         PHP_FE(oci_field_size,                          arginfo_oci_field_size)
     848             :         PHP_FE(oci_field_scale,                         arginfo_oci_field_scale)
     849             :         PHP_FE(oci_field_precision,                     arginfo_oci_field_precision)
     850             :         PHP_FE(oci_field_type,                          arginfo_oci_field_type)
     851             :         PHP_FE(oci_field_type_raw,                      arginfo_oci_field_type_raw)
     852             :         PHP_FE(oci_execute,                                     arginfo_oci_execute)
     853             :         PHP_FE(oci_cancel,                                      arginfo_oci_cancel)
     854             :         PHP_FE(oci_fetch,                                       arginfo_oci_fetch)
     855             :         PHP_FE(oci_fetch_object,                        arginfo_oci_fetch_object)
     856             :         PHP_FE(oci_fetch_row,                           arginfo_oci_fetch_row)
     857             :         PHP_FE(oci_fetch_assoc,                         arginfo_oci_fetch_assoc)
     858             :         PHP_FE(oci_fetch_array,                         arginfo_oci_fetch_array)
     859             :         PHP_FE(ocifetchinto,                            arginfo_ocifetchinto)
     860             :         PHP_FE(oci_fetch_all,                           arginfo_oci_fetch_all)
     861             :         PHP_FE(oci_free_statement,                      arginfo_oci_free_statement)
     862             :         PHP_FE(oci_internal_debug,                      arginfo_oci_internal_debug)
     863             :         PHP_FE(oci_num_fields,                          arginfo_oci_num_fields)
     864             :         PHP_FE(oci_parse,                                       arginfo_oci_parse)
     865             :         PHP_FE(oci_new_cursor,                          arginfo_oci_new_cursor)
     866             :         PHP_FE(oci_result,                                      arginfo_oci_result)
     867             :         PHP_FE(oci_client_version,                      arginfo_oci_client_version)
     868             :         PHP_FE(oci_server_version,                      arginfo_oci_server_version)
     869             :         PHP_FE(oci_statement_type,                      arginfo_oci_statement_type)
     870             :         PHP_FE(oci_num_rows,                            arginfo_oci_num_rows)
     871             :         PHP_FE(oci_close,                                       arginfo_oci_close)
     872             :         PHP_FE(oci_connect,                                     arginfo_oci_connect)
     873             :         PHP_FE(oci_new_connect,                         arginfo_oci_new_connect)
     874             :         PHP_FE(oci_pconnect,                            arginfo_oci_pconnect)
     875             :         PHP_FE(oci_error,                                       arginfo_oci_error)
     876             :         PHP_FE(oci_free_descriptor,                     arginfo_oci_free_descriptor)
     877             :         PHP_FE(oci_lob_save,                            arginfo_oci_lob_save)
     878             :         PHP_FE(oci_lob_import,                          arginfo_oci_lob_import)
     879             :         PHP_FE(oci_lob_size,                            arginfo_oci_lob_size)
     880             :         PHP_FE(oci_lob_load,                            arginfo_oci_lob_load)
     881             :         PHP_FE(oci_lob_read,                            arginfo_oci_lob_read)
     882             :         PHP_FE(oci_lob_eof,                                     arginfo_oci_lob_eof)
     883             :         PHP_FE(oci_lob_tell,                            arginfo_oci_lob_tell)
     884             :         PHP_FE(oci_lob_truncate,                        arginfo_oci_lob_truncate)
     885             :         PHP_FE(oci_lob_erase,                           arginfo_oci_lob_erase)
     886             :         PHP_FE(oci_lob_flush,                           arginfo_oci_lob_flush)
     887             :         PHP_FE(ocisetbufferinglob,                      arginfo_ocisetbufferinglob)
     888             :         PHP_FE(ocigetbufferinglob,                      arginfo_ocigetbufferinglob)
     889             :         PHP_FE(oci_lob_is_equal,                        arginfo_oci_lob_is_equal)
     890             :         PHP_FE(oci_lob_rewind,                          arginfo_oci_lob_rewind)
     891             :         PHP_FE(oci_lob_write,                           arginfo_oci_lob_write)
     892             :         PHP_FE(oci_lob_append,                          arginfo_oci_lob_append)
     893             :         PHP_FE(oci_lob_copy,                            arginfo_oci_lob_copy)
     894             :         PHP_FE(oci_lob_export,                          arginfo_oci_lob_export)
     895             :         PHP_FE(oci_lob_seek,                            arginfo_oci_lob_seek)
     896             :         PHP_FE(oci_commit,                                      arginfo_oci_commit)
     897             :         PHP_FE(oci_rollback,                            arginfo_oci_rollback)
     898             :         PHP_FE(oci_new_descriptor,                      arginfo_oci_new_descriptor)
     899             :         PHP_FE(oci_set_prefetch,                        arginfo_oci_set_prefetch)
     900             :         PHP_FE(oci_set_client_identifier,       arginfo_oci_set_client_identifier)
     901             :         PHP_FE(oci_set_edition,                         arginfo_oci_set_edition)
     902             :         PHP_FE(oci_set_module_name,                     arginfo_oci_set_module_name)
     903             :         PHP_FE(oci_set_action,                          arginfo_oci_set_action)
     904             :         PHP_FE(oci_set_client_info,                     arginfo_oci_set_client_info)
     905             :         PHP_FE(oci_password_change,                     arginfo_oci_password_change)
     906             :         PHP_FE(oci_free_collection,                     arginfo_oci_free_collection)
     907             :         PHP_FE(oci_collection_append,           arginfo_oci_collection_append)
     908             :         PHP_FE(oci_collection_element_get,      arginfo_oci_collection_element_get)
     909             :         PHP_FE(oci_collection_element_assign,   arginfo_oci_collection_element_assign)
     910             :         PHP_FE(oci_collection_assign,           arginfo_oci_collection_assign)
     911             :         PHP_FE(oci_collection_size,                     arginfo_oci_collection_size)
     912             :         PHP_FE(oci_collection_max,                      arginfo_oci_collection_max)
     913             :         PHP_FE(oci_collection_trim,                     arginfo_oci_collection_trim)
     914             :         PHP_FE(oci_new_collection,                      arginfo_oci_new_collection)
     915             : 
     916             :         PHP_FALIAS(oci_free_cursor,             oci_free_statement,             arginfo_oci_free_statement)
     917             :         PHP_FALIAS(ocifreecursor,               oci_free_statement,             arginfo_oci_free_statement)
     918             :         PHP_FALIAS(ocibindbyname,               oci_bind_by_name,               arginfo_oci_bind_by_name)
     919             :         PHP_FALIAS(ocidefinebyname,             oci_define_by_name,             arginfo_oci_define_by_name)
     920             :         PHP_FALIAS(ocicolumnisnull,             oci_field_is_null,              arginfo_oci_field_is_null)
     921             :         PHP_FALIAS(ocicolumnname,               oci_field_name,                 arginfo_oci_field_name)
     922             :         PHP_FALIAS(ocicolumnsize,               oci_field_size,                 arginfo_oci_field_size)
     923             :         PHP_FALIAS(ocicolumnscale,              oci_field_scale,                arginfo_oci_field_scale)
     924             :         PHP_FALIAS(ocicolumnprecision,  oci_field_precision,    arginfo_oci_field_precision)
     925             :         PHP_FALIAS(ocicolumntype,               oci_field_type,                 arginfo_oci_field_type)
     926             :         PHP_FALIAS(ocicolumntyperaw,    oci_field_type_raw,             arginfo_oci_field_type_raw)
     927             :         PHP_FALIAS(ociexecute,                  oci_execute,                    arginfo_oci_execute)
     928             :         PHP_FALIAS(ocicancel,                   oci_cancel,                             arginfo_oci_cancel)
     929             :         PHP_FALIAS(ocifetch,                    oci_fetch,                              arginfo_oci_fetch)
     930             :         PHP_FALIAS(ocifetchstatement,   oci_fetch_all,                  arginfo_oci_fetch_all)
     931             :         PHP_FALIAS(ocifreestatement,    oci_free_statement,             arginfo_oci_free_statement)
     932             :         PHP_FALIAS(ociinternaldebug,    oci_internal_debug,             arginfo_oci_internal_debug)
     933             :         PHP_FALIAS(ocinumcols,                  oci_num_fields,                 arginfo_oci_num_fields)
     934             :         PHP_FALIAS(ociparse,                    oci_parse,                              arginfo_oci_parse)
     935             :         PHP_FALIAS(ocinewcursor,                oci_new_cursor,                 arginfo_oci_new_cursor)
     936             :         PHP_FALIAS(ociresult,                   oci_result,                             arginfo_oci_result)
     937             :         PHP_FALIAS(ociserverversion,    oci_server_version,             arginfo_oci_server_version)
     938             :         PHP_FALIAS(ocistatementtype,    oci_statement_type,             arginfo_oci_statement_type)
     939             :         PHP_FALIAS(ocirowcount,                 oci_num_rows,                   arginfo_oci_num_rows)
     940             :         PHP_FALIAS(ocilogoff,                   oci_close,                              arginfo_oci_close)
     941             :         PHP_FALIAS(ocilogon,                    oci_connect,                    arginfo_oci_connect)
     942             :         PHP_FALIAS(ocinlogon,                   oci_new_connect,                arginfo_oci_new_connect)
     943             :         PHP_FALIAS(ociplogon,                   oci_pconnect,                   arginfo_oci_pconnect)
     944             :         PHP_FALIAS(ocierror,                    oci_error,                              arginfo_oci_error)
     945             :         PHP_FALIAS(ocifreedesc,                 oci_free_descriptor,    arginfo_oci_free_descriptor)
     946             :         PHP_FALIAS(ocisavelob,                  oci_lob_save,                   arginfo_oci_lob_save)
     947             :         PHP_FALIAS(ocisavelobfile,              oci_lob_import,                 arginfo_oci_lob_import)
     948             :         PHP_FALIAS(ociwritelobtofile,   oci_lob_export,                 arginfo_oci_lob_export)
     949             :         PHP_FALIAS(ociloadlob,                  oci_lob_load,                   arginfo_oci_lob_load)
     950             :         PHP_FALIAS(ocicommit,                   oci_commit,                             arginfo_oci_commit)
     951             :         PHP_FALIAS(ocirollback,                 oci_rollback,                   arginfo_oci_rollback)
     952             :         PHP_FALIAS(ocinewdescriptor,    oci_new_descriptor,             arginfo_oci_new_descriptor)
     953             :         PHP_FALIAS(ocisetprefetch,              oci_set_prefetch,               arginfo_oci_set_prefetch)
     954             :         PHP_FALIAS(ocipasswordchange,   oci_password_change,    arginfo_oci_password_change)
     955             :         PHP_FALIAS(ocifreecollection,   oci_free_collection,    arginfo_oci_free_collection)
     956             :         PHP_FALIAS(ocinewcollection,    oci_new_collection,             arginfo_oci_new_collection)
     957             :         PHP_FALIAS(ocicollappend,               oci_collection_append,  arginfo_oci_collection_append)
     958             :         PHP_FALIAS(ocicollgetelem,              oci_collection_element_get,             arginfo_oci_collection_element_get)
     959             :         PHP_FALIAS(ocicollassignelem,   oci_collection_element_assign,  arginfo_oci_collection_element_assign)
     960             :         PHP_FALIAS(ocicollsize,                 oci_collection_size,    arginfo_oci_collection_size)
     961             :         PHP_FALIAS(ocicollmax,                  oci_collection_max,             arginfo_oci_collection_max)
     962             :         PHP_FALIAS(ocicolltrim,                 oci_collection_trim,    arginfo_oci_collection_trim)
     963             : #if (PHP_MAJOR_VERSION == 5 && PHP_MINOR_VERSION == 3 && PHP_RELEASE_VERSION >= 7) || (PHP_MAJOR_VERSION == 5 && PHP_MINOR_VERSION >= 4) || (PHP_MAJOR_VERSION > 5)
     964             :         PHP_FE_END
     965             : #else
     966             :         {NULL,NULL,NULL}
     967             : #endif
     968             : };
     969             : 
     970             : static
     971             : #if (PHP_MAJOR_VERSION == 5 && PHP_MINOR_VERSION > 2) || (PHP_MAJOR_VERSION > 5)
     972             : /* This "if" allows PECL builds from this file to be portable to older PHP releases */
     973             : const
     974             : #endif
     975             : zend_function_entry php_oci_lob_class_functions[] = {
     976             :         PHP_FALIAS(load,                oci_lob_load,                   arginfo_oci_lob_load_method)
     977             :         PHP_FALIAS(tell,                oci_lob_tell,                   arginfo_oci_lob_tell_method)
     978             :         PHP_FALIAS(truncate,    oci_lob_truncate,               arginfo_oci_lob_truncate_method)
     979             :         PHP_FALIAS(erase,               oci_lob_erase,                  arginfo_oci_lob_erase_method)
     980             :         PHP_FALIAS(flush,               oci_lob_flush,                  arginfo_oci_lob_flush_method)
     981             :         PHP_FALIAS(setbuffering,ocisetbufferinglob,             arginfo_oci_lob_setbuffering_method)
     982             :         PHP_FALIAS(getbuffering,ocigetbufferinglob,             arginfo_oci_lob_getbuffering_method)
     983             :         PHP_FALIAS(rewind,              oci_lob_rewind,                 arginfo_oci_lob_rewind_method)
     984             :         PHP_FALIAS(read,                oci_lob_read,                   arginfo_oci_lob_read_method)
     985             :         PHP_FALIAS(eof,                 oci_lob_eof,                    arginfo_oci_lob_eof_method)
     986             :         PHP_FALIAS(seek,                oci_lob_seek,                   arginfo_oci_lob_seek_method)
     987             :         PHP_FALIAS(write,               oci_lob_write,                  arginfo_oci_lob_write_method)
     988             :         PHP_FALIAS(append,              oci_lob_append,                 arginfo_oci_lob_append_method)
     989             :         PHP_FALIAS(size,                oci_lob_size,                   arginfo_oci_lob_size_method)
     990             :         PHP_FALIAS(writetofile, oci_lob_export,                 arginfo_oci_lob_export_method)
     991             :         PHP_FALIAS(export,              oci_lob_export,                 arginfo_oci_lob_export_method)
     992             :         PHP_FALIAS(import,              oci_lob_import,                 arginfo_oci_lob_import_method)
     993             :         PHP_FALIAS(writetemporary,      oci_lob_write_temporary,        arginfo_oci_lob_write_temporary_method)
     994             :         PHP_FALIAS(close,                       oci_lob_close,                          arginfo_oci_lob_close_method)
     995             :         PHP_FALIAS(save,                oci_lob_save,                   arginfo_oci_lob_save_method)
     996             :         PHP_FALIAS(savefile,    oci_lob_import,                 arginfo_oci_lob_import_method)
     997             :         PHP_FALIAS(free,                oci_free_descriptor,    arginfo_oci_free_descriptor_method)
     998             : #if (PHP_MAJOR_VERSION == 5 && PHP_MINOR_VERSION == 3 && PHP_RELEASE_VERSION >= 7) || (PHP_MAJOR_VERSION == 5 && PHP_MINOR_VERSION >= 4) || (PHP_MAJOR_VERSION > 5)
     999             :         PHP_FE_END
    1000             : #else
    1001             :         {NULL,NULL,NULL}
    1002             : #endif
    1003             : };
    1004             : 
    1005             : static
    1006             : #if (PHP_MAJOR_VERSION == 5 && PHP_MINOR_VERSION > 2) || (PHP_MAJOR_VERSION > 5)
    1007             : /* This "if" allows PECL builds from this file to be portable to older PHP releases */
    1008             : const
    1009             : #endif
    1010             : zend_function_entry php_oci_coll_class_functions[] = {
    1011             :         PHP_FALIAS(append,                oci_collection_append,                        arginfo_oci_collection_append_method)
    1012             :         PHP_FALIAS(getelem,               oci_collection_element_get,           arginfo_oci_collection_element_get_method)
    1013             :         PHP_FALIAS(assignelem,    oci_collection_element_assign,        arginfo_oci_collection_element_assign_method)
    1014             :         PHP_FALIAS(assign,                oci_collection_assign,                        arginfo_oci_collection_assign_method)
    1015             :         PHP_FALIAS(size,                  oci_collection_size,                          arginfo_oci_collection_size_method)
    1016             :         PHP_FALIAS(max,                   oci_collection_max,                           arginfo_oci_collection_max_method)
    1017             :         PHP_FALIAS(trim,                  oci_collection_trim,                          arginfo_oci_collection_trim_method)
    1018             :         PHP_FALIAS(free,                  oci_free_collection,                          arginfo_oci_collection_free_method)
    1019             : #if (PHP_MAJOR_VERSION == 5 && PHP_MINOR_VERSION == 3 && PHP_RELEASE_VERSION >= 7) || (PHP_MAJOR_VERSION == 5 && PHP_MINOR_VERSION >= 4) || (PHP_MAJOR_VERSION > 5)
    1020             :         PHP_FE_END
    1021             : #else
    1022             :         {NULL,NULL,NULL}
    1023             : #endif
    1024             : };
    1025             : 
    1026             : zend_module_entry oci8_module_entry = {
    1027             :         STANDARD_MODULE_HEADER,
    1028             :         "oci8",                                 /* extension name */
    1029             :         php_oci_functions,        /* extension function list */
    1030             :         PHP_MINIT(oci),           /* extension-wide startup function */
    1031             :         PHP_MSHUTDOWN(oci),       /* extension-wide shutdown function */
    1032             :         PHP_RINIT(oci),           /* per-request startup function */
    1033             :         PHP_RSHUTDOWN(oci),       /* per-request shutdown function */
    1034             :         PHP_MINFO(oci),           /* information function */
    1035             :         PHP_OCI8_VERSION,
    1036             : #if (PHP_MAJOR_VERSION == 5 && PHP_MINOR_VERSION > 1) || (PHP_MAJOR_VERSION > 5)
    1037             :         /* This check allows PECL builds from this file to be portable to older PHP releases */
    1038             :         PHP_MODULE_GLOBALS(oci),  /* globals descriptor */
    1039             :         PHP_GINIT(oci),                   /* globals ctor */
    1040             :         PHP_GSHUTDOWN(oci),               /* globals dtor */
    1041             :         NULL,                                     /* post deactivate */
    1042             :         STANDARD_MODULE_PROPERTIES_EX
    1043             : #else
    1044             :         STANDARD_MODULE_PROPERTIES
    1045             : #endif
    1046             : };
    1047             : /* }}} */
    1048             : 
    1049             : /* {{{ PHP_INI */
    1050             : PHP_INI_BEGIN()
    1051             :         STD_PHP_INI_ENTRY(      "oci8.max_persistent",                        "-1", PHP_INI_SYSTEM, ONUPDATELONGFUNC,       max_persistent,                 zend_oci_globals,       oci_globals)
    1052             :         STD_PHP_INI_ENTRY(      "oci8.persistent_timeout",            "-1", PHP_INI_SYSTEM, ONUPDATELONGFUNC,       persistent_timeout,             zend_oci_globals,       oci_globals)
    1053             :         STD_PHP_INI_ENTRY(      "oci8.ping_interval",                 "60", PHP_INI_SYSTEM, ONUPDATELONGFUNC,       ping_interval,                  zend_oci_globals,       oci_globals)
    1054             :         STD_PHP_INI_BOOLEAN("oci8.privileged_connect",                "0",  PHP_INI_SYSTEM, OnUpdateBool,           privileged_connect,             zend_oci_globals,       oci_globals)
    1055             :         STD_PHP_INI_ENTRY(      "oci8.statement_cache_size",  "20", PHP_INI_SYSTEM, ONUPDATELONGFUNC,       statement_cache_size,   zend_oci_globals,       oci_globals)
    1056             :         STD_PHP_INI_ENTRY(      "oci8.default_prefetch",              "100",        PHP_INI_SYSTEM, ONUPDATELONGFUNC,       default_prefetch,               zend_oci_globals,       oci_globals)
    1057             :         STD_PHP_INI_BOOLEAN("oci8.old_oci_close_semantics",   "0",  PHP_INI_SYSTEM, OnUpdateBool,           old_oci_close_semantics,zend_oci_globals,       oci_globals)
    1058             :         STD_PHP_INI_ENTRY(      "oci8.connection_class",              "",           PHP_INI_ALL,    OnUpdateString,         connection_class,               zend_oci_globals,       oci_globals)
    1059             :         STD_PHP_INI_BOOLEAN("oci8.events",                                    "0",  PHP_INI_SYSTEM, OnUpdateBool,           events,                                 zend_oci_globals,       oci_globals)
    1060             : PHP_INI_END()
    1061             : /* }}} */
    1062             : 
    1063             : /* {{{ startup, shutdown and info functions
    1064             : */
    1065             : 
    1066             : /* {{{  php_oci_init_global_handles()
    1067             :  *
    1068             :  * Initialize global handles only when they are needed
    1069             :  */
    1070         487 : static void php_oci_init_global_handles(TSRMLS_D)
    1071             : {
    1072             :         sword errstatus;
    1073         487 :         sb4   ora_error_code = 0;
    1074             :         text  tmp_buf[OCI_ERROR_MAXMSG_SIZE];  /* Use traditional smaller size: non-PL/SQL errors should fit and it keeps the stack smaller */
    1075             : 
    1076         487 :         errstatus = OCIEnvNlsCreate(&OCI_G(env), PHP_OCI_INIT_MODE, 0, NULL, NULL, NULL, 0, NULL, 0, 0);
    1077             : 
    1078         487 :         if (errstatus == OCI_ERROR) {
    1079             : #ifdef HAVE_OCI_INSTANT_CLIENT
    1080             :                 php_error_docref(NULL TSRMLS_CC, E_WARNING, "OCIEnvNlsCreate() failed. There is something wrong with your system - please check that " PHP_OCI8_LIB_PATH_MSG " includes the directory with Oracle Instant Client libraries");
    1081             : #else
    1082           3 :                 php_error_docref(NULL TSRMLS_CC, E_WARNING, "OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME and " PHP_OCI8_LIB_PATH_MSG " are set and point to the right directories");
    1083             : #endif
    1084           9 :                 if (OCI_G(env)
    1085           3 :                         && OCIErrorGet(OCI_G(env), (ub4)1, NULL, &ora_error_code, tmp_buf, (ub4)OCI_ERROR_MAXMSG_SIZE, (ub4)OCI_HTYPE_ENV) == OCI_SUCCESS
    1086           6 :                         && *tmp_buf) {
    1087           3 :                         php_error_docref(NULL TSRMLS_CC, E_WARNING, "%s", tmp_buf);
    1088             :                 }
    1089             :                 
    1090           3 :                 OCI_G(env) = NULL;
    1091           3 :                 OCI_G(err) = NULL;
    1092           3 :                 return;
    1093             :         }
    1094             : 
    1095         484 :         errstatus = OCIHandleAlloc (OCI_G(env), (dvoid **)&OCI_G(err), OCI_HTYPE_ERROR, 0, NULL);
    1096             : 
    1097         484 :         if (errstatus == OCI_SUCCESS) {
    1098             : #if !defined(OCI_MAJOR_VERSION) || (OCI_MAJOR_VERSION < 11)
    1099             :                 /* This fixes PECL bug 15988 (sqlnet.ora not being read).  The
    1100             :                  * root cause was fixed in Oracle 10.2.0.4 but there is no
    1101             :                  * compile time method to check for that precise patch level,
    1102             :                  * nor can it be guaranteed that runtime will use the same
    1103             :                  * patch level the code was compiled with.  So, we do this
    1104             :                  * code for all non 11g versions.
    1105             :                  */
    1106             :                 OCICPool *cpoolh;
    1107             :                 ub4 cpoolmode = 0x80000000;     /* Pass invalid mode to OCIConnectionPoolCreate */
    1108             :                 PHP_OCI_CALL(OCIHandleAlloc, (OCI_G(env), (dvoid **) &cpoolh, OCI_HTYPE_CPOOL, (size_t) 0, (dvoid **) 0));
    1109             :                 PHP_OCI_CALL(OCIConnectionPoolCreate, (OCI_G(env), OCI_G(err), cpoolh, NULL, 0, NULL, 0, 0, 0, 0, NULL, 0, NULL, 0, cpoolmode));
    1110             :                 PHP_OCI_CALL(OCIConnectionPoolDestroy, (cpoolh, OCI_G(err), OCI_DEFAULT));
    1111             :                 PHP_OCI_CALL(OCIHandleFree, (cpoolh, OCI_HTYPE_CPOOL));
    1112             : #endif
    1113             :         } else {
    1114           0 :                 OCIErrorGet(OCI_G(env), (ub4)1, NULL, &ora_error_code, tmp_buf, (ub4)OCI_ERROR_MAXMSG_SIZE, (ub4)OCI_HTYPE_ERROR);
    1115             : 
    1116           0 :                 if (ora_error_code) {
    1117           0 :                         int tmp_buf_len = strlen((char *)tmp_buf);
    1118             :                         
    1119           0 :                         if (tmp_buf_len > 0 && tmp_buf[tmp_buf_len - 1] == '\n') {
    1120           0 :                                 tmp_buf[tmp_buf_len - 1] = '\0';
    1121             :                         }
    1122             :                         
    1123           0 :                         if (errstatus == OCI_SUCCESS_WITH_INFO) {
    1124           0 :                                 php_error_docref(NULL TSRMLS_CC, E_WARNING, "Initialization error: OCI_SUCCESS_WITH_INFO: %s", tmp_buf);
    1125             :                         } else {
    1126           0 :                                 php_error_docref(NULL TSRMLS_CC, E_WARNING, "Initialization error: OCI_ERROR: %s", tmp_buf);
    1127             :                                 
    1128           0 :                                 OCIHandleFree((dvoid *) OCI_G(env), OCI_HTYPE_ENV);
    1129             :                                 
    1130           0 :                                 OCI_G(env) = NULL;
    1131           0 :                                 OCI_G(err) = NULL;
    1132             :                         }
    1133             :                 }
    1134             :         }
    1135             : } /* }}} */
    1136             : 
    1137             : /* {{{ php_oci_cleanup_global_handles()
    1138             :  *
    1139             :  * Free global handles (if they were initialized before)
    1140             :  */
    1141       20261 : static void php_oci_cleanup_global_handles(TSRMLS_D)
    1142             : {
    1143       20261 :         if (OCI_G(err)) {
    1144         484 :                 PHP_OCI_CALL(OCIHandleFree, ((dvoid *) OCI_G(err), OCI_HTYPE_ERROR));
    1145         484 :                 OCI_G(err) = NULL;
    1146             :         }
    1147             : 
    1148       20261 :         if (OCI_G(env)) {
    1149         484 :                 PHP_OCI_CALL(OCIHandleFree, ((dvoid *) OCI_G(env), OCI_HTYPE_ENV));
    1150         484 :                 OCI_G(env) = NULL;
    1151             :         }
    1152       20261 : } /* }}} */
    1153             : 
    1154             : /* {{{ PHP_GINIT_FUNCTION
    1155             :  *
    1156             :  * Zerofill globals during module init
    1157             :  */
    1158             : #if (PHP_MAJOR_VERSION == 5 && PHP_MINOR_VERSION > 1) || (PHP_MAJOR_VERSION > 5)
    1159             : /* This check allows PECL builds from this file to be portable to older PHP releases */
    1160       20225 : static PHP_GINIT_FUNCTION(oci)
    1161             : #else
    1162             : static void php_oci_init_globals(zend_oci_globals *oci_globals TSRMLS_DC)
    1163             : #endif
    1164             : {
    1165       20225 :         memset(oci_globals, 0, sizeof(zend_oci_globals));
    1166       20225 : }
    1167             : /* }}} */
    1168             : 
    1169             : /* {{{ PHP_GSHUTDOWN_FUNCTION
    1170             :  *
    1171             :  * Called for thread shutdown in ZTS, after module shutdown for non-ZTS
    1172             :  */
    1173             : /* This check allows PECL builds from this file to be portable to older PHP releases */
    1174             : #if (PHP_MAJOR_VERSION == 5 && PHP_MINOR_VERSION > 1) || (PHP_MAJOR_VERSION > 5)
    1175       20261 : static PHP_GSHUTDOWN_FUNCTION(oci)
    1176             : #else
    1177             : static void php_oci_shutdown_globals(zend_oci_globals *oci_globals TSRMLS_DC)
    1178             : #endif
    1179             : {
    1180       20261 :         php_oci_cleanup_global_handles(TSRMLS_C);
    1181       20261 : }
    1182             : /* }}} */
    1183             : 
    1184       20225 : PHP_MINIT_FUNCTION(oci)
    1185             : {
    1186             :         zend_class_entry oci_lob_class_entry;
    1187             :         zend_class_entry oci_coll_class_entry;
    1188             : 
    1189             : #if (PHP_MAJOR_VERSION == 5 && PHP_MINOR_VERSION > 1) || (PHP_MAJOR_VERSION > 5)
    1190             :         /* This check allows PECL builds from this file to be portable to older PHP releases */
    1191             :         /* this is handled by new globals management code */
    1192             : #else
    1193             :         ZEND_INIT_MODULE_GLOBALS(oci, php_oci_init_globals, php_oci_shutdown_globals);
    1194             : #endif
    1195       20225 :         REGISTER_INI_ENTRIES();
    1196             : 
    1197       20225 :         le_statement = zend_register_list_destructors_ex(php_oci_statement_list_dtor, NULL, "oci8 statement", module_number);
    1198       20225 :         le_connection = zend_register_list_destructors_ex(php_oci_connection_list_dtor, NULL, "oci8 connection", module_number);
    1199       20225 :         le_pconnection = zend_register_list_destructors_ex(php_oci_pconnection_list_np_dtor, php_oci_pconnection_list_dtor, "oci8 persistent connection", module_number);
    1200       20225 :         le_psessionpool = zend_register_list_destructors_ex(NULL, php_oci_spool_list_dtor, "oci8 persistent session pool", module_number);
    1201       20225 :         le_descriptor = zend_register_list_destructors_ex(php_oci_descriptor_list_dtor, NULL, "oci8 descriptor", module_number);
    1202       20225 :         le_collection = zend_register_list_destructors_ex(php_oci_collection_list_dtor, NULL, "oci8 collection", module_number);
    1203             : 
    1204       20225 :         INIT_CLASS_ENTRY(oci_lob_class_entry, "OCI-Lob", php_oci_lob_class_functions);
    1205       20225 :         INIT_CLASS_ENTRY(oci_coll_class_entry, "OCI-Collection", php_oci_coll_class_functions);
    1206             : 
    1207       20225 :         oci_lob_class_entry_ptr = zend_register_internal_class(&oci_lob_class_entry TSRMLS_CC);
    1208       20225 :         oci_coll_class_entry_ptr = zend_register_internal_class(&oci_coll_class_entry TSRMLS_CC);
    1209             : 
    1210             : /* thies@thieso.net 990203 i do not think that we will need all of them - just in here for completeness for now! */
    1211       20225 :         REGISTER_LONG_CONSTANT("OCI_DEFAULT",OCI_DEFAULT, CONST_CS | CONST_PERSISTENT);
    1212       20225 :         REGISTER_LONG_CONSTANT("OCI_SYSOPER",OCI_SYSOPER, CONST_CS | CONST_PERSISTENT);
    1213       20225 :         REGISTER_LONG_CONSTANT("OCI_SYSDBA",OCI_SYSDBA, CONST_CS | CONST_PERSISTENT);
    1214       20225 :         REGISTER_LONG_CONSTANT("OCI_CRED_EXT",PHP_OCI_CRED_EXT, CONST_CS | CONST_PERSISTENT);
    1215       20225 :         REGISTER_LONG_CONSTANT("OCI_DESCRIBE_ONLY",OCI_DESCRIBE_ONLY, CONST_CS | CONST_PERSISTENT);
    1216       20225 :         REGISTER_LONG_CONSTANT("OCI_COMMIT_ON_SUCCESS",OCI_COMMIT_ON_SUCCESS, CONST_CS | CONST_PERSISTENT);
    1217       20225 :         REGISTER_LONG_CONSTANT("OCI_NO_AUTO_COMMIT",OCI_DEFAULT, CONST_CS | CONST_PERSISTENT);
    1218       20225 :         REGISTER_LONG_CONSTANT("OCI_EXACT_FETCH",OCI_EXACT_FETCH, CONST_CS | CONST_PERSISTENT);
    1219             : 
    1220             : /* for $LOB->seek() */
    1221       20225 :         REGISTER_LONG_CONSTANT("OCI_SEEK_SET",PHP_OCI_SEEK_SET, CONST_CS | CONST_PERSISTENT);
    1222       20225 :         REGISTER_LONG_CONSTANT("OCI_SEEK_CUR",PHP_OCI_SEEK_CUR, CONST_CS | CONST_PERSISTENT);
    1223       20225 :         REGISTER_LONG_CONSTANT("OCI_SEEK_END",PHP_OCI_SEEK_END, CONST_CS | CONST_PERSISTENT);
    1224             : 
    1225             : /*      for $LOB->flush() */
    1226       20225 :         REGISTER_LONG_CONSTANT("OCI_LOB_BUFFER_FREE",OCI_LOB_BUFFER_FREE, CONST_CS | CONST_PERSISTENT);
    1227             : 
    1228             : /* for OCIBindByName (real "oci" names + short "php" names */
    1229       20225 :         REGISTER_LONG_CONSTANT("SQLT_BFILEE",SQLT_BFILEE, CONST_CS | CONST_PERSISTENT);
    1230       20225 :         REGISTER_LONG_CONSTANT("SQLT_CFILEE",SQLT_CFILEE, CONST_CS | CONST_PERSISTENT);
    1231       20225 :         REGISTER_LONG_CONSTANT("SQLT_CLOB",SQLT_CLOB, CONST_CS | CONST_PERSISTENT);
    1232       20225 :         REGISTER_LONG_CONSTANT("SQLT_BLOB",SQLT_BLOB, CONST_CS | CONST_PERSISTENT);
    1233       20225 :         REGISTER_LONG_CONSTANT("SQLT_RDD",SQLT_RDD, CONST_CS | CONST_PERSISTENT);
    1234       20225 :         REGISTER_LONG_CONSTANT("SQLT_INT",SQLT_INT, CONST_CS | CONST_PERSISTENT);
    1235       20225 :         REGISTER_LONG_CONSTANT("SQLT_NUM",SQLT_NUM, CONST_CS | CONST_PERSISTENT);
    1236       20225 :         REGISTER_LONG_CONSTANT("SQLT_RSET",SQLT_RSET, CONST_CS | CONST_PERSISTENT);
    1237       20225 :         REGISTER_LONG_CONSTANT("SQLT_AFC",SQLT_AFC, CONST_CS | CONST_PERSISTENT);
    1238       20225 :         REGISTER_LONG_CONSTANT("SQLT_CHR",SQLT_CHR, CONST_CS | CONST_PERSISTENT);
    1239       20225 :         REGISTER_LONG_CONSTANT("SQLT_VCS",SQLT_VCS, CONST_CS | CONST_PERSISTENT);
    1240       20225 :         REGISTER_LONG_CONSTANT("SQLT_AVC",SQLT_AVC, CONST_CS | CONST_PERSISTENT);
    1241       20225 :         REGISTER_LONG_CONSTANT("SQLT_STR",SQLT_STR, CONST_CS | CONST_PERSISTENT);
    1242       20225 :         REGISTER_LONG_CONSTANT("SQLT_LVC",SQLT_LVC, CONST_CS | CONST_PERSISTENT);
    1243       20225 :         REGISTER_LONG_CONSTANT("SQLT_FLT",SQLT_FLT, CONST_CS | CONST_PERSISTENT);
    1244       20225 :         REGISTER_LONG_CONSTANT("SQLT_UIN",SQLT_UIN, CONST_CS | CONST_PERSISTENT);
    1245       20225 :         REGISTER_LONG_CONSTANT("SQLT_LNG",SQLT_LNG, CONST_CS | CONST_PERSISTENT);
    1246       20225 :         REGISTER_LONG_CONSTANT("SQLT_LBI",SQLT_LBI, CONST_CS | CONST_PERSISTENT);
    1247       20225 :         REGISTER_LONG_CONSTANT("SQLT_BIN",SQLT_BIN, CONST_CS | CONST_PERSISTENT);
    1248       20225 :         REGISTER_LONG_CONSTANT("SQLT_ODT",SQLT_ODT, CONST_CS | CONST_PERSISTENT);
    1249             : #if defined(HAVE_OCI_INSTANT_CLIENT) || (defined(OCI_MAJOR_VERSION) && OCI_MAJOR_VERSION >= 10)
    1250       20225 :         REGISTER_LONG_CONSTANT("SQLT_BDOUBLE",SQLT_BDOUBLE, CONST_CS | CONST_PERSISTENT);
    1251       20225 :         REGISTER_LONG_CONSTANT("SQLT_BFLOAT",SQLT_BFLOAT, CONST_CS | CONST_PERSISTENT);
    1252             : #endif
    1253             : 
    1254       20225 :         REGISTER_LONG_CONSTANT("OCI_B_NTY",SQLT_NTY, CONST_CS | CONST_PERSISTENT);
    1255       20225 :         REGISTER_LONG_CONSTANT("SQLT_NTY",SQLT_NTY, CONST_CS | CONST_PERSISTENT);
    1256       20225 :         REGISTER_STRING_CONSTANT("OCI_SYSDATE","SYSDATE", CONST_CS | CONST_PERSISTENT);
    1257             : 
    1258       20225 :         REGISTER_LONG_CONSTANT("OCI_B_BFILE",SQLT_BFILEE, CONST_CS | CONST_PERSISTENT);
    1259       20225 :         REGISTER_LONG_CONSTANT("OCI_B_CFILEE",SQLT_CFILEE, CONST_CS | CONST_PERSISTENT);
    1260       20225 :         REGISTER_LONG_CONSTANT("OCI_B_CLOB",SQLT_CLOB, CONST_CS | CONST_PERSISTENT);
    1261       20225 :         REGISTER_LONG_CONSTANT("OCI_B_BLOB",SQLT_BLOB, CONST_CS | CONST_PERSISTENT);
    1262       20225 :         REGISTER_LONG_CONSTANT("OCI_B_ROWID",SQLT_RDD, CONST_CS | CONST_PERSISTENT);
    1263       20225 :         REGISTER_LONG_CONSTANT("OCI_B_CURSOR",SQLT_RSET, CONST_CS | CONST_PERSISTENT);
    1264       20225 :         REGISTER_LONG_CONSTANT("OCI_B_BIN",SQLT_BIN, CONST_CS | CONST_PERSISTENT);
    1265       20225 :         REGISTER_LONG_CONSTANT("OCI_B_INT",SQLT_INT, CONST_CS | CONST_PERSISTENT);
    1266       20225 :         REGISTER_LONG_CONSTANT("OCI_B_NUM",SQLT_NUM, CONST_CS | CONST_PERSISTENT);
    1267             : 
    1268             : /* for OCIFetchStatement */
    1269       20225 :         REGISTER_LONG_CONSTANT("OCI_FETCHSTATEMENT_BY_COLUMN", PHP_OCI_FETCHSTATEMENT_BY_COLUMN, CONST_CS | CONST_PERSISTENT);
    1270       20225 :         REGISTER_LONG_CONSTANT("OCI_FETCHSTATEMENT_BY_ROW", PHP_OCI_FETCHSTATEMENT_BY_ROW, CONST_CS | CONST_PERSISTENT);
    1271             : 
    1272             : /* for OCIFetchInto & OCIResult */
    1273       20225 :         REGISTER_LONG_CONSTANT("OCI_ASSOC",PHP_OCI_ASSOC, CONST_CS | CONST_PERSISTENT);
    1274       20225 :         REGISTER_LONG_CONSTANT("OCI_NUM",PHP_OCI_NUM, CONST_CS | CONST_PERSISTENT);
    1275       20225 :         REGISTER_LONG_CONSTANT("OCI_BOTH",PHP_OCI_BOTH, CONST_CS | CONST_PERSISTENT);
    1276       20225 :         REGISTER_LONG_CONSTANT("OCI_RETURN_NULLS",PHP_OCI_RETURN_NULLS, CONST_CS | CONST_PERSISTENT);
    1277       20225 :         REGISTER_LONG_CONSTANT("OCI_RETURN_LOBS",PHP_OCI_RETURN_LOBS, CONST_CS | CONST_PERSISTENT);
    1278             : 
    1279             : /* for OCINewDescriptor (real "oci" names + short "php" names */
    1280       20225 :         REGISTER_LONG_CONSTANT("OCI_DTYPE_FILE",OCI_DTYPE_FILE, CONST_CS | CONST_PERSISTENT);
    1281       20225 :         REGISTER_LONG_CONSTANT("OCI_DTYPE_LOB",OCI_DTYPE_LOB, CONST_CS | CONST_PERSISTENT);
    1282       20225 :         REGISTER_LONG_CONSTANT("OCI_DTYPE_ROWID",OCI_DTYPE_ROWID, CONST_CS | CONST_PERSISTENT);
    1283             : 
    1284       20225 :         REGISTER_LONG_CONSTANT("OCI_D_FILE",OCI_DTYPE_FILE, CONST_CS | CONST_PERSISTENT);
    1285       20225 :         REGISTER_LONG_CONSTANT("OCI_D_LOB",OCI_DTYPE_LOB, CONST_CS | CONST_PERSISTENT);
    1286       20225 :         REGISTER_LONG_CONSTANT("OCI_D_ROWID",OCI_DTYPE_ROWID, CONST_CS | CONST_PERSISTENT);
    1287             : 
    1288             : /* for OCIWriteTemporaryLob */
    1289       20225 :         REGISTER_LONG_CONSTANT("OCI_TEMP_CLOB",OCI_TEMP_CLOB, CONST_CS | CONST_PERSISTENT);
    1290       20225 :         REGISTER_LONG_CONSTANT("OCI_TEMP_BLOB",OCI_TEMP_BLOB, CONST_CS | CONST_PERSISTENT);
    1291             : 
    1292       20225 :         return SUCCESS;
    1293             : }
    1294             : 
    1295       20182 : PHP_RINIT_FUNCTION(oci)
    1296             : {
    1297       20182 :         OCI_G(debug_mode) = 0; /* start "fresh" */
    1298       20182 :         OCI_G(num_links) = OCI_G(num_persistent);
    1299       20182 :         OCI_G(errcode) = 0;
    1300       20182 :         OCI_G(edition) = NULL;
    1301             : 
    1302       20182 :         return SUCCESS;
    1303             : }
    1304             : 
    1305       20261 : PHP_MSHUTDOWN_FUNCTION(oci)
    1306             : {
    1307             : /* Work around PHP_GSHUTDOWN_FUNCTION not being called in older versions of PHP */
    1308             : #if (PHP_MAJOR_VERSION == 5 && PHP_MINOR_VERSION < 2) || (PHP_MAJOR_VERSION < 5)
    1309             : #ifndef ZTS
    1310             :         php_oci_cleanup_global_handles(TSRMLS_C);
    1311             : #endif
    1312             : #endif
    1313             : 
    1314       20261 :         OCI_G(shutdown) = 1;
    1315             : 
    1316       20261 :         UNREGISTER_INI_ENTRIES();
    1317             : 
    1318       20261 :         return SUCCESS;
    1319             : }
    1320             : 
    1321       20220 : PHP_RSHUTDOWN_FUNCTION(oci)
    1322             : {
    1323             :         /* Check persistent connections and do the necessary actions if needed. If persistent_helper is
    1324             :          * unable to process a pconnection because of a refcount, the processing would happen from
    1325             :          * np-destructor which is called when refcount goes to zero - php_oci_pconnection_list_np_dtor
    1326             :          */
    1327       20220 :         zend_hash_apply(&EG(persistent_list), (apply_func_t) php_oci_persistent_helper TSRMLS_CC);
    1328             : 
    1329       20220 :         if (OCI_G(edition)) {
    1330           2 :                 efree(OCI_G(edition));
    1331             :         }
    1332             : 
    1333       20220 :         return SUCCESS;
    1334             : }
    1335             : 
    1336         148 : PHP_MINFO_FUNCTION(oci)
    1337             : {
    1338             :         char buf[32];
    1339             :         char *ver;
    1340             : 
    1341         148 :         php_info_print_table_start();
    1342         148 :         php_info_print_table_row(2, "OCI8 Support", "enabled");
    1343         148 :         php_info_print_table_row(2, "Version", PHP_OCI8_VERSION);
    1344         148 :         php_info_print_table_row(2, "Revision", "$Id: cdb1302d3784cf3ece95ed7e5f70998212164e52 $");
    1345             : 
    1346         148 :         snprintf(buf, sizeof(buf), "%ld", OCI_G(num_persistent));
    1347         148 :         php_info_print_table_row(2, "Active Persistent Connections", buf);
    1348         148 :         snprintf(buf, sizeof(buf), "%ld", OCI_G(num_links));
    1349         148 :         php_info_print_table_row(2, "Active Connections", buf);
    1350             : 
    1351             : #if ((OCI_MAJOR_VERSION > 10) || ((OCI_MAJOR_VERSION == 10) && (OCI_MINOR_VERSION >= 2)))
    1352         148 :         php_oci_client_get_version(&ver TSRMLS_CC);
    1353         148 :         php_info_print_table_row(2, "Oracle Run-time Client Library Version", ver);
    1354         148 :         efree(ver);
    1355             : #endif
    1356             : #if     defined(OCI_MAJOR_VERSION) && defined(OCI_MINOR_VERSION)
    1357         148 :         snprintf(buf, sizeof(buf), "%d.%d", OCI_MAJOR_VERSION, OCI_MINOR_VERSION);
    1358             : #elif defined(PHP_OCI8_ORACLE_VERSION)
    1359             :         snprintf(buf, sizeof(buf), "%s", PHP_OCI8_ORACLE_VERSION);
    1360             : #else
    1361             :         snprintf(buf, sizeof(buf), "Unknown");
    1362             : #endif
    1363             : #if defined(HAVE_OCI_INSTANT_CLIENT)
    1364             :         php_info_print_table_row(2, "Oracle Instant Client Version", buf);
    1365             : #else
    1366         148 :         php_info_print_table_row(2, "Oracle Version", buf);
    1367             : #endif
    1368             : 
    1369             : #if !defined(PHP_WIN32) && !defined(HAVE_OCI_INSTANT_CLIENT)
    1370             : #if defined(PHP_OCI8_DEF_DIR)
    1371         148 :         php_info_print_table_row(2, "Compile-time ORACLE_HOME", PHP_OCI8_DEF_DIR);
    1372             : #endif
    1373             : #if defined(PHP_OCI8_DEF_SHARED_LIBADD)
    1374         148 :         php_info_print_table_row(2, "Libraries Used", PHP_OCI8_DEF_SHARED_LIBADD);
    1375             : #endif
    1376             : #endif
    1377             : 
    1378         148 :         php_info_print_table_row(2, "Temporary Lob support", "enabled");
    1379         148 :         php_info_print_table_row(2, "Collections support", "enabled");
    1380         148 :         php_info_print_table_end();
    1381         148 :         DISPLAY_INI_ENTRIES();
    1382         148 : }
    1383             : /* }}} */
    1384             : 
    1385             : /* list destructors {{{ */
    1386             : 
    1387             : /* {{{ php_oci_connection_list_dtor()
    1388             :  *
    1389             :  * Non-persistent connection destructor
    1390             :  */
    1391         533 : static void php_oci_connection_list_dtor(zend_rsrc_list_entry *entry TSRMLS_DC)
    1392             : {
    1393         533 :         php_oci_connection *connection = (php_oci_connection *)entry->ptr;
    1394             : 
    1395         533 :         if (connection) {
    1396         533 :                 php_oci_connection_close(connection TSRMLS_CC);
    1397         533 :                 OCI_G(num_links)--;
    1398             :         }
    1399         533 : } /* }}} */
    1400             : 
    1401             : /* {{{ php_oci_pconnection_list_dtor()
    1402             :  *
    1403             :  * Persistent connection destructor
    1404             :  */
    1405          34 : static void php_oci_pconnection_list_dtor(zend_rsrc_list_entry *entry TSRMLS_DC)
    1406             : {
    1407          34 :         php_oci_connection *connection = (php_oci_connection *)entry->ptr;
    1408             : 
    1409          34 :         if (connection) {
    1410          34 :                 php_oci_connection_close(connection TSRMLS_CC);
    1411          34 :                 OCI_G(num_persistent)--;
    1412          34 :                 OCI_G(num_links)--;
    1413             :         }
    1414          34 : } /* }}} */
    1415             : 
    1416             : /* {{{ php_oci_pconnection_list_np_dtor()
    1417             :  *
    1418             :  * Non-Persistent destructor for persistent connection - This gets invoked when
    1419             :  * the refcount of this goes to zero in the regular list
    1420             :  */
    1421          42 : static void php_oci_pconnection_list_np_dtor(zend_rsrc_list_entry *entry TSRMLS_DC)
    1422             : {
    1423          42 :         php_oci_connection *connection = (php_oci_connection *)entry->ptr;
    1424             :         zend_rsrc_list_entry *le;
    1425             : 
    1426             :         /*
    1427             :          * We cannot get connection as NULL or as a stub in this function. This is the function that
    1428             :          * turns a pconnection to a stub
    1429             :          *
    1430             :          * If oci_password_change() changed the password of a persistent connection, close the
    1431             :          * connection and remove it from the persistent connection cache.  This means subsequent scripts
    1432             :          * will be prevented from being able to present the old (now invalid) password to a usable
    1433             :          * connection to the database; they must use the new password.
    1434             :          *
    1435             :          * Check for conditions that warrant removal of the hash entry
    1436             :          */
    1437             : 
    1438         167 :         if (!connection->is_open ||
    1439          42 :                 connection->passwd_changed ||
    1440          41 :                 (PG(connection_status) & PHP_CONNECTION_TIMEOUT) ||
    1441          41 :                 OCI_G(in_call)) {
    1442             : 
    1443             :                 /* Remove the hash entry if present */
    1444           2 :                 if ((zend_hash_find(&EG(persistent_list), connection->hash_key, strlen(connection->hash_key)+1, (void **) &le)== SUCCESS) && (le->type == le_pconnection) && (le->ptr == connection)) {
    1445           1 :                         zend_hash_del(&EG(persistent_list), connection->hash_key, strlen(connection->hash_key)+1);
    1446             :                 }
    1447             :                 else {
    1448           0 :                         php_oci_connection_close(connection TSRMLS_CC);
    1449           0 :                         OCI_G(num_persistent)--;
    1450             :                 }
    1451             : 
    1452           1 :                 if (OCI_G(debug_mode)) {
    1453           0 :                         php_printf ("OCI8 DEBUG L1: np_dtor cleaning up: (%p) at (%s:%d) \n", connection, __FILE__, __LINE__);
    1454             :                 }
    1455             :         }
    1456             :         else {
    1457             :                 /*
    1458             :                  * Release the connection to underlying pool.  We do this unconditionally so that
    1459             :                  * out-of-scope pconnects are now consistent with oci_close and out-of-scope new connect
    1460             :                  * semantics. With the PECL OCI 1.3.x extensions, we release pconnections when oci_close
    1461             :                  * takes the refcount to zero.
    1462             :                  *
    1463             :                  * If oci_old_close_semantics is set, we artifically bump up the refcount and decremented
    1464             :                  * only at request shutdown.
    1465             :                  */
    1466          41 :                 php_oci_connection_release(connection TSRMLS_CC);
    1467             : 
    1468          41 :                 if (OCI_G(debug_mode)) {
    1469           0 :                         php_printf ("OCI8 DEBUG L1: np_dtor releasing: (%p) at (%s:%d) \n", connection, __FILE__, __LINE__);
    1470             :                 }
    1471             :         }
    1472          42 : } /* }}} */
    1473             : 
    1474             : /* {{{ php_oci_statement_list_dtor()
    1475             :  *
    1476             :  * Statement destructor
    1477             :  */
    1478       34475 : static void php_oci_statement_list_dtor(zend_rsrc_list_entry *entry TSRMLS_DC)
    1479             : {
    1480       34475 :         php_oci_statement *statement = (php_oci_statement *)entry->ptr;
    1481       34475 :         php_oci_statement_free(statement TSRMLS_CC);
    1482       34475 : } /* }}} */
    1483             : 
    1484             : /* {{{ php_oci_descriptor_list_dtor()
    1485             :  *
    1486             :  *      Descriptor destructor
    1487             :  */
    1488      283635 : static void php_oci_descriptor_list_dtor(zend_rsrc_list_entry *entry TSRMLS_DC)
    1489             : {
    1490      283635 :         php_oci_descriptor *descriptor = (php_oci_descriptor *)entry->ptr;
    1491      283635 :         php_oci_lob_free(descriptor TSRMLS_CC);
    1492      283635 : } /* }}} */
    1493             : 
    1494             : /* {{{ php_oci_collection_list_dtor()
    1495             :  *
    1496             :  * Collection destructor
    1497             :  */
    1498       70047 : static void php_oci_collection_list_dtor(zend_rsrc_list_entry *entry TSRMLS_DC)
    1499             : {
    1500       70047 :         php_oci_collection *collection = (php_oci_collection *)entry->ptr;
    1501       70047 :         php_oci_collection_close(collection TSRMLS_CC);
    1502       70047 : } /* }}} */
    1503             : 
    1504             : /* }}} */
    1505             : 
    1506             : /* Hash Destructors {{{ */
    1507             : 
    1508             : /* {{{ php_oci_define_hash_dtor()
    1509             :  *
    1510             :  * Define hash destructor
    1511             :  */
    1512       30053 : void php_oci_define_hash_dtor(void *data)
    1513             : {
    1514       30053 :         php_oci_define *define = (php_oci_define *) data;
    1515             : 
    1516       30053 :         zval_ptr_dtor(&define->zval);
    1517             : 
    1518       30053 :         if (define->name) {
    1519       30053 :                 efree(define->name);
    1520       30053 :                 define->name = NULL;
    1521             :         }
    1522       30053 : }
    1523             : /* }}} */
    1524             : 
    1525             : /* {{{ php_oci_bind_hash_dtor()
    1526             :  *
    1527             :  * Bind hash destructor
    1528             :  */
    1529         553 : void php_oci_bind_hash_dtor(void *data)
    1530             : {
    1531         553 :         php_oci_bind *bind = (php_oci_bind *) data;
    1532             : 
    1533         553 :         if (bind->array.elements) {
    1534          22 :                 efree(bind->array.elements);
    1535             :         }
    1536             : 
    1537         553 :         if (bind->array.element_lengths) {
    1538          22 :                 efree(bind->array.element_lengths);
    1539             :         }
    1540             : 
    1541         553 :         if (bind->array.indicators) {
    1542          13 :                 efree(bind->array.indicators);
    1543             :         }
    1544             : 
    1545         553 :         zval_ptr_dtor(&bind->zval);
    1546         553 : }
    1547             : /* }}} */
    1548             : 
    1549             : /* {{{ php_oci_column_hash_dtor()
    1550             :  *
    1551             :  * Column hash destructor
    1552             :  */
    1553       63465 : void php_oci_column_hash_dtor(void *data)
    1554             : {
    1555       63465 :         php_oci_out_column *column = (php_oci_out_column *) data;
    1556             :         TSRMLS_FETCH();
    1557             : 
    1558       63465 :         if (column->stmtid) {
    1559        1401 :                 zend_list_delete(column->stmtid);
    1560             :         }
    1561             : 
    1562       63465 :         if (column->is_descr) {
    1563       60135 :                 zend_list_delete(column->descid);
    1564             :         }
    1565             : 
    1566       63465 :         if (column->data) {
    1567        1919 :                 efree(column->data);
    1568             :         }
    1569             : 
    1570       63465 :         if (column->name) {
    1571       63465 :                 efree(column->name);
    1572             :         }
    1573       63465 : }
    1574             : /* }}} */
    1575             : 
    1576             : /* {{{ php_oci_descriptor_flush_hash_dtor()
    1577             :  *
    1578             :  * Flush descriptors on commit
    1579             :  */
    1580      283631 : void php_oci_descriptor_flush_hash_dtor(void *data)
    1581             : {
    1582      283631 :         php_oci_descriptor *descriptor = *(php_oci_descriptor **)data;
    1583             :         TSRMLS_FETCH();
    1584             : 
    1585      283631 :         if (descriptor && descriptor->buffering == PHP_OCI_LOB_BUFFER_USED && (descriptor->type == OCI_DTYPE_LOB || descriptor->type == OCI_DTYPE_FILE)) {
    1586           1 :                 php_oci_lob_flush(descriptor, OCI_LOB_BUFFER_FREE TSRMLS_CC);
    1587           1 :                 descriptor->buffering = PHP_OCI_LOB_BUFFER_ENABLED;
    1588             :         }
    1589      283631 :         data = NULL;
    1590      283631 : }
    1591             : /* }}} */
    1592             : 
    1593             : /* }}} */
    1594             : 
    1595             : /* {{{ php_oci_connection_descriptors_free()
    1596             :  *
    1597             :  * Free descriptors for a connection
    1598             :  */
    1599         122 : void php_oci_connection_descriptors_free(php_oci_connection *connection TSRMLS_DC)
    1600             : {
    1601         122 :         zend_hash_destroy(connection->descriptors);
    1602         122 :         efree(connection->descriptors);
    1603         122 :         connection->descriptors = NULL;
    1604         122 :         connection->descriptor_count = 0;
    1605         122 : }
    1606             : /* }}} */
    1607             : 
    1608             : 
    1609             : /* {{{ php_oci_error()
    1610             :  *
    1611             :  * Fetch & print out error message if we get an error
    1612             :  * Returns an Oracle error number
    1613             :  */
    1614         329 : sb4 php_oci_error(OCIError *err_p, sword status TSRMLS_DC)
    1615             : {
    1616         329 :         text *errbuf = (text *)NULL;
    1617         329 :         sb4 errcode = 0;
    1618             : 
    1619         329 :         switch (status) {
    1620             :                 case OCI_SUCCESS:
    1621           0 :                         break;
    1622             :                 case OCI_SUCCESS_WITH_INFO:
    1623           1 :                         errcode = php_oci_fetch_errmsg(err_p, &errbuf TSRMLS_CC);
    1624           1 :                         if (errbuf) {
    1625           1 :                                 php_error_docref(NULL TSRMLS_CC, E_WARNING, "OCI_SUCCESS_WITH_INFO: %s", errbuf);
    1626           1 :                                 efree(errbuf);
    1627             :                         } else {
    1628           0 :                                 php_error_docref(NULL TSRMLS_CC, E_WARNING, "OCI_SUCCESS_WITH_INFO: failed to fetch error message");
    1629             :                         }
    1630           1 :                         break;
    1631             :                 case OCI_NEED_DATA:
    1632           0 :                         php_error_docref(NULL TSRMLS_CC, E_WARNING, "OCI_NEED_DATA");
    1633           0 :                         break;
    1634             :                 case OCI_NO_DATA:
    1635           3 :                         errcode = php_oci_fetch_errmsg(err_p, &errbuf TSRMLS_CC);
    1636           3 :                         if (errbuf) {
    1637           3 :                                 php_error_docref(NULL TSRMLS_CC, E_WARNING, "%s", errbuf);
    1638           3 :                                 efree(errbuf);
    1639             :                         } else {
    1640           0 :                                 php_error_docref(NULL TSRMLS_CC, E_WARNING, "OCI_NO_DATA: failed to fetch error message");
    1641             :                         }
    1642           3 :                         break;
    1643             :                 case OCI_ERROR:
    1644         322 :                         errcode = php_oci_fetch_errmsg(err_p, &errbuf TSRMLS_CC);
    1645         322 :                         if (errbuf) {
    1646         322 :                                 php_error_docref(NULL TSRMLS_CC, E_WARNING, "%s", errbuf);
    1647         322 :                                 efree(errbuf);
    1648             :                         } else {
    1649           0 :                                 php_error_docref(NULL TSRMLS_CC, E_WARNING, "failed to fetch error message");
    1650             :                         }
    1651         322 :                         break;
    1652             :                 case OCI_INVALID_HANDLE:
    1653           3 :                         php_error_docref(NULL TSRMLS_CC, E_WARNING, "OCI_INVALID_HANDLE");
    1654           3 :                         break;
    1655             :                 case OCI_STILL_EXECUTING:
    1656           0 :                         php_error_docref(NULL TSRMLS_CC, E_WARNING, "OCI_STILL_EXECUTING");
    1657           0 :                         break;
    1658             :                 case OCI_CONTINUE:
    1659           0 :                         php_error_docref(NULL TSRMLS_CC, E_WARNING, "OCI_CONTINUE");
    1660           0 :                         break;
    1661             :                 default:
    1662           0 :                         php_error_docref(NULL TSRMLS_CC, E_WARNING, "Unknown OCI error code: %d", status);
    1663             :                         break;
    1664             :         }
    1665         329 :         return errcode;
    1666             : }
    1667             : /* }}} */
    1668             : 
    1669             : /* {{{ php_oci_fetch_errmsg()
    1670             :  *
    1671             :  * Fetch error message into the buffer from the error handle provided
    1672             :  */
    1673         519 : sb4 php_oci_fetch_errmsg(OCIError *error_handle, text **error_buf TSRMLS_DC)
    1674             : {
    1675         519 :         sb4 error_code = 0;
    1676             :         text err_buf[PHP_OCI_ERRBUF_LEN];
    1677             : 
    1678         519 :         memset(err_buf, 0, sizeof(err_buf));
    1679         519 :         PHP_OCI_CALL(OCIErrorGet, (error_handle, (ub4)1, NULL, &error_code, err_buf, (ub4)PHP_OCI_ERRBUF_LEN, (ub4)OCI_HTYPE_ERROR));
    1680             : 
    1681         519 :         if (error_code) {
    1682         519 :                 int err_buf_len = strlen((char *)err_buf);
    1683             : 
    1684         519 :                 if (err_buf_len && err_buf[err_buf_len - 1] == '\n') {
    1685         513 :                         err_buf[err_buf_len - 1] = '\0';
    1686             :                 }
    1687         519 :                 if (err_buf_len && error_buf) {
    1688         519 :                         *error_buf = NULL;
    1689         519 :                         *error_buf = (text *)estrndup((char *)err_buf, err_buf_len);
    1690             :                 }
    1691             :         }
    1692         519 :         return error_code;
    1693             : } /* }}} */
    1694             : 
    1695             : /* {{{ php_oci_fetch_sqltext_offset()
    1696             :  *
    1697             :  * Compute offset in the SQL statement
    1698             :  */
    1699         166 : int php_oci_fetch_sqltext_offset(php_oci_statement *statement, text **sqltext, ub2 *error_offset TSRMLS_DC)
    1700             : {
    1701             :         sword errstatus;
    1702             : 
    1703         166 :         *sqltext = NULL;
    1704         166 :         *error_offset = 0;
    1705         166 :         PHP_OCI_CALL_RETURN(errstatus, OCIAttrGet, ((dvoid *)statement->stmt, OCI_HTYPE_STMT, (dvoid *) sqltext, (ub4 *)0, OCI_ATTR_STATEMENT, statement->err));
    1706             : 
    1707         166 :         if (errstatus != OCI_SUCCESS) {
    1708           0 :                 statement->errcode = php_oci_error(statement->err, errstatus TSRMLS_CC);
    1709           0 :                 PHP_OCI_HANDLE_ERROR(statement->connection, statement->errcode);
    1710           0 :                 return 1;
    1711             :         }
    1712             : 
    1713         166 :         PHP_OCI_CALL_RETURN(errstatus, OCIAttrGet, ((dvoid *)statement->stmt, OCI_HTYPE_STMT, (ub2 *)error_offset, (ub4 *)0, OCI_ATTR_PARSE_ERROR_OFFSET, statement->err));
    1714             : 
    1715         166 :         if (errstatus != OCI_SUCCESS) {
    1716           0 :                 statement->errcode = php_oci_error(statement->err, errstatus TSRMLS_CC);
    1717           0 :                 PHP_OCI_HANDLE_ERROR(statement->connection, statement->errcode);
    1718           0 :                 return 1;
    1719             :         }
    1720         166 :         return 0;
    1721             : } /* }}} */
    1722             : 
    1723             : /* {{{ php_oci_do_connect()
    1724             :  *
    1725             :  * Connect wrapper
    1726             :  */
    1727         651 : void php_oci_do_connect(INTERNAL_FUNCTION_PARAMETERS, int persistent, int exclusive)
    1728             : {
    1729             :         php_oci_connection *connection;
    1730             :         char *username, *password;
    1731         651 :         char *dbname = NULL, *charset = NULL;
    1732         651 :         int username_len = 0, password_len = 0;
    1733         651 :         int dbname_len = 0, charset_len = 0;
    1734         651 :         long session_mode = OCI_DEFAULT;
    1735             : 
    1736             :         /* if a fourth parameter is handed over, it is the charset identifier (but is only used in Oracle 9i+) */
    1737         651 :         if (zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "ss|ssl", &username, &username_len, &password, &password_len, &dbname, &dbname_len, &charset, &charset_len, &session_mode) == FAILURE) {
    1738           5 :                 return;
    1739             :         }
    1740             : 
    1741         646 :         if (!charset_len) {
    1742         635 :                 charset = NULL;
    1743             :         }
    1744             : 
    1745         646 :         connection = php_oci_do_connect_ex(username, username_len, password, password_len, NULL, 0, dbname, dbname_len, charset, session_mode, persistent, exclusive TSRMLS_CC);
    1746             : 
    1747         646 :         if (!connection) {
    1748          51 :                 RETURN_FALSE;
    1749             :         }
    1750         595 :         RETURN_RESOURCE(connection->rsrc_id);
    1751             : 
    1752             : } /* }}} */
    1753             : 
    1754             : /* {{{ php_oci_do_connect_ex()
    1755             :  *
    1756             :  * The real connect function. Allocates all the resources needed, establishes the connection and
    1757             :  * returns the result handle (or NULL)
    1758             :  */
    1759         650 : php_oci_connection *php_oci_do_connect_ex(char *username, int username_len, char *password, int password_len, char *new_password, int new_password_len, char *dbname, int dbname_len, char *charset, long session_mode, int persistent, int exclusive TSRMLS_DC)
    1760             : {
    1761             :         zend_rsrc_list_entry *le;
    1762             :         zend_rsrc_list_entry new_le;
    1763         650 :         php_oci_connection *connection = NULL;
    1764         650 :         smart_str hashed_details = {0};
    1765             :         time_t timestamp;
    1766         650 :         php_oci_spool *session_pool = NULL;
    1767         650 :         zend_bool use_spool = 1;           /* Default is to use client-side session pool */
    1768         650 :         zend_bool ping_done = 0;
    1769             : 
    1770         650 :         ub2 charsetid = 0;
    1771         650 :         ub2 charsetid_nls_lang = 0;
    1772             : 
    1773         650 :         if (session_mode & ~(OCI_SYSOPER | OCI_SYSDBA | PHP_OCI_CRED_EXT)) {
    1774           2 :                 php_error_docref(NULL TSRMLS_CC, E_WARNING, "Invalid session mode specified (%ld)", session_mode);
    1775           2 :                 return NULL;
    1776             :         }
    1777         648 :         if (session_mode & (OCI_SYSOPER | OCI_SYSDBA | PHP_OCI_CRED_EXT)) {
    1778          41 :                 if ((session_mode & OCI_SYSOPER) && (session_mode & OCI_SYSDBA)) {
    1779           6 :                         php_error_docref(NULL TSRMLS_CC, E_WARNING, "OCI_SYSDBA and OCI_SYSOPER cannot be used together");
    1780           6 :                         return NULL;
    1781             :                 }
    1782          35 :                 if (session_mode & PHP_OCI_CRED_EXT) {
    1783             : #ifdef PHP_WIN32
    1784             :                         /* Disable external authentication on Windows as Impersonation is not yet handled.
    1785             :                          * TODO: Re-enable this once OCI provides capability.
    1786             :                          */
    1787             :                         php_error_docref(NULL TSRMLS_CC, E_WARNING, "External Authentication is not supported on Windows");
    1788             :                         return NULL;
    1789             : #endif
    1790          24 :                         if (username_len != 1 || username[0] != '/' || password_len != 0) {
    1791          12 :                                 php_error_docref(NULL TSRMLS_CC, E_WARNING, "OCI_CRED_EXT can only be used with a username of \"/\" and a NULL password");
    1792          12 :                                 return NULL;
    1793             :                         }
    1794             :                 }
    1795          23 :                 if (session_mode & (OCI_SYSOPER | OCI_SYSDBA)) {
    1796             :                         /* Increase security by not caching privileged oci_pconnect() connections. The
    1797             :                          * connection becomes equivalent to oci_connect() or oci_new_connect().
    1798             :                          */
    1799          17 :                         persistent = 0;
    1800          17 :                         if (!OCI_G(privileged_connect)) {
    1801           2 :                                 php_error_docref(NULL TSRMLS_CC, E_WARNING, "Privileged connect is disabled. Enable oci8.privileged_connect to be able to connect as SYSOPER or SYSDBA");
    1802           2 :                                 return NULL;
    1803             :                         }
    1804             : #if (PHP_MAJOR_VERSION == 5 && PHP_MINOR_VERSION < 4) || (PHP_MAJOR_VERSION < 5)
    1805             :                         /* Safe mode has been removed in PHP 5.4 */
    1806             :                         if (PG(safe_mode)) {
    1807             :                                 php_error_docref(NULL TSRMLS_CC, E_WARNING, "Privileged connect is disabled in Safe Mode");
    1808             :                                 return NULL;
    1809             :                         }
    1810             : #endif
    1811             :                 }
    1812             :         }
    1813             : 
    1814             :         /* Initialize global handles if they weren't initialized before */
    1815         628 :         if (OCI_G(env) == NULL) {
    1816         487 :                 php_oci_init_global_handles(TSRMLS_C);
    1817         487 :                 if (OCI_G(env) == NULL) {
    1818           3 :                         return NULL;
    1819             :                 }
    1820             :         }
    1821             : 
    1822             :         /* We cannot use the new session create logic (OCISessionGet from
    1823             :          * client-side session pool) when privileged connect or password
    1824             :          * change is attempted or OCI_CRED_EXT mode is specified.
    1825             :          * TODO: Re-enable this when OCI provides support.
    1826             :          */
    1827         625 :         if ((session_mode & (OCI_SYSOPER | OCI_SYSDBA | PHP_OCI_CRED_EXT)) || (new_password_len)) {
    1828          25 :                 use_spool = 0;
    1829             :         }
    1830             : 
    1831         625 :         smart_str_appendl_ex(&hashed_details, "oci8***", sizeof("oci8***") - 1, 0);
    1832         625 :         smart_str_appendl_ex(&hashed_details, username, username_len, 0);
    1833         625 :         smart_str_appendl_ex(&hashed_details, "**", sizeof("**") - 1, 0);
    1834             : 
    1835             :         /* DRCP: connection_class is an attribute of a connection */
    1836         625 :         if (OCI_G(connection_class)){
    1837         625 :                 smart_str_appendl_ex(&hashed_details, OCI_G(connection_class), strlen(OCI_G(connection_class)), 0);
    1838             :         }
    1839         625 :         smart_str_appendl_ex(&hashed_details, "**", sizeof("**") - 1, 0);
    1840             : 
    1841             :         /* Add edition attribute to the hash */
    1842         625 :         if (OCI_G(edition)){
    1843          19 :                 smart_str_appendl_ex(&hashed_details, OCI_G(edition), strlen(OCI_G(edition)), 0);
    1844             :         }
    1845         625 :         smart_str_appendl_ex(&hashed_details, "**", sizeof("**") - 1, 0);
    1846             : 
    1847         625 :         if (password_len) {
    1848             :                 ulong password_hash;
    1849         611 :                 password_hash = zend_inline_hash_func(password, password_len);
    1850         611 :                 smart_str_append_unsigned_ex(&hashed_details, password_hash, 0);
    1851             :         }
    1852         625 :         smart_str_appendl_ex(&hashed_details, "**", sizeof("**") - 1, 0);
    1853             : 
    1854         625 :         if (dbname) {
    1855         625 :                 smart_str_appendl_ex(&hashed_details, dbname, dbname_len, 0);
    1856             :         }
    1857         625 :         smart_str_appendl_ex(&hashed_details, "**", sizeof("**") - 1, 0);
    1858             : 
    1859         625 :         if (charset && *charset) {
    1860          10 :                 PHP_OCI_CALL_RETURN(charsetid, OCINlsCharSetNameToId, (OCI_G(env), (CONST oratext *)charset));
    1861          10 :                 if (!charsetid) {
    1862           2 :                         php_error_docref(NULL TSRMLS_CC, E_WARNING, "Invalid character set name: %s", charset);
    1863             :                 } else {
    1864           8 :                         smart_str_append_unsigned_ex(&hashed_details, charsetid, 0);
    1865             :                 }
    1866             :         }
    1867             : 
    1868             :         /* use NLS_LANG if no or invalid charset specified */
    1869         625 :         if (!charsetid) {
    1870         617 :                 size_t rsize = 0;
    1871             :                 sword result;
    1872             : 
    1873         617 :                 PHP_OCI_CALL_RETURN(result, OCINlsEnvironmentVariableGet, (&charsetid_nls_lang, 0, OCI_NLS_CHARSET_ID, 0, &rsize));
    1874         617 :                 if (result != OCI_SUCCESS) {
    1875           0 :                         charsetid_nls_lang = 0;
    1876             :                 }
    1877         617 :                 smart_str_append_unsigned_ex(&hashed_details, charsetid_nls_lang, 0);
    1878             :         }
    1879             : 
    1880         625 :         timestamp = time(NULL);
    1881             : 
    1882         625 :         smart_str_append_unsigned_ex(&hashed_details, session_mode, 0);
    1883         625 :         smart_str_0(&hashed_details);
    1884             : 
    1885             :         /* make it lowercase */
    1886         625 :         php_strtolower(hashed_details.c, hashed_details.len);
    1887             : 
    1888         625 :         if (!exclusive && !new_password) {
    1889         577 :                 zend_bool found = 0;
    1890             : 
    1891         591 :                 if (persistent && zend_hash_find(&EG(persistent_list), hashed_details.c, hashed_details.len+1, (void **) &le) == SUCCESS) {
    1892          14 :                         found = 1;
    1893             :                         /* found */
    1894          14 :                         if (le->type == le_pconnection) {
    1895          14 :                                 connection = (php_oci_connection *)le->ptr;
    1896             :                         }
    1897         563 :                 } else if (!persistent && zend_hash_find(&EG(regular_list), hashed_details.c, hashed_details.len+1, (void **) &le) == SUCCESS) {
    1898          28 :                         found = 1;
    1899          28 :                         if (le->type == le_index_ptr) {
    1900             :                                 int type, link;
    1901             :                                 void *ptr;
    1902             : 
    1903          28 :                                 link = OCI8_PTR_TO_INT(le->ptr);
    1904          28 :                                 ptr = zend_list_find(link,&type);
    1905          28 :                                 if (ptr && (type == le_connection)) {
    1906          18 :                                         connection = (php_oci_connection *)ptr;
    1907             :                                 }
    1908             :                         }
    1909             :                 }
    1910             : 
    1911             :                 /* Debug statements {{{ */
    1912         577 :                 if (OCI_G(debug_mode)) {
    1913           1 :                         if (connection && connection->is_stub) {
    1914           0 :                                 php_printf ("OCI8 DEBUG L1: Got a cached stub: (%p) at (%s:%d) \n", connection, __FILE__, __LINE__);
    1915           1 :                         } else if (connection) {
    1916           0 :                                 php_printf ("OCI8 DEBUG L1: Got a cached connection: (%p) at (%s:%d) \n", connection, __FILE__, __LINE__);
    1917             :                         } else {
    1918           1 :                                 php_printf ("OCI8 DEBUG L1: Got NO cached connection at (%s:%d) \n", __FILE__, __LINE__);
    1919             :                         }
    1920             :                 } /* }}} */
    1921             : 
    1922             :                 /* If we got a pconnection stub, then 'load'(OCISessionGet) the real connection from its
    1923             :                  * private spool A connection is a stub if it is only a cached structure and the real
    1924             :                  * connection is released to its underlying private session pool.  We currently do not have
    1925             :                  * stub support for non-persistent conns.
    1926             :                  *
    1927             :                  * TODO: put in negative code for non-persistent stubs
    1928             :                  */
    1929         577 :                 if (connection && connection->is_persistent && connection->is_stub) {
    1930           8 :                         if (php_oci_create_session(connection, NULL, dbname, dbname_len, username, username_len, password, password_len, new_password, new_password_len, session_mode TSRMLS_CC)) {
    1931           0 :                                 smart_str_free_ex(&hashed_details, 0);
    1932           0 :                                 zend_hash_del(&EG(persistent_list), connection->hash_key, strlen(connection->hash_key)+1);
    1933             : 
    1934           0 :                                 return NULL;
    1935             :                         }
    1936             :                         /* We do the ping in php_oci_create_session, no need to ping again below */
    1937           8 :                         ping_done = 1;
    1938             :                 }
    1939             : 
    1940         577 :                 if (connection) {
    1941          32 :                         if (connection->is_open) {
    1942             :                                 /* found an open connection. now ping it */
    1943          32 :                                 if (connection->is_persistent) {
    1944             :                                         int rsrc_type;
    1945             : 
    1946             :                                         /* Check connection liveness in the following order:
    1947             :                                          * 1) always check OCI_ATTR_SERVER_STATUS
    1948             :                                          * 2) see if it's time to ping it
    1949             :                                          * 3) ping it if needed
    1950             :                                          */
    1951          14 :                                         if (php_oci_connection_status(connection TSRMLS_CC)) {
    1952             :                                                 /* Only ping if:
    1953             :                                                  *
    1954             :                                                  * 1) next_ping > 0, which means that ping_interval is not -1 (aka "Off")
    1955             :                                                  *
    1956             :                                                  * 2) current_timestamp > next_ping, which means "it's time to check if it's
    1957             :                                                  * still alive"
    1958             :                                                  */
    1959          14 :                                                 if (!ping_done && (*(connection->next_pingp) > 0) && (timestamp >= *(connection->next_pingp)) && !php_oci_connection_ping(connection TSRMLS_CC)) {
    1960             :                                                         /* server died */
    1961             :                                                 } else {
    1962             :                                                         php_oci_connection *tmp;
    1963             : 
    1964             :                                                         /* okay, the connection is open and the server is still alive */
    1965          14 :                                                         connection->used_this_request = 1;
    1966          14 :                                                         tmp = (php_oci_connection *)zend_list_find(connection->rsrc_id, &rsrc_type);
    1967             : 
    1968          26 :                                                         if (tmp != NULL && rsrc_type == le_pconnection && strlen(tmp->hash_key) == hashed_details.len &&
    1969          12 :                                                                 memcmp(tmp->hash_key, hashed_details.c, hashed_details.len) == 0 && zend_list_addref(connection->rsrc_id) == SUCCESS) {
    1970             :                                                                 /* do nothing */
    1971             :                                                         } else {
    1972             : #if (PHP_MAJOR_VERSION == 5 && PHP_MINOR_VERSION > 3) || (PHP_MAJOR_VERSION > 5)
    1973           8 :                                                                 connection->rsrc_id = zend_list_insert(connection, le_pconnection TSRMLS_CC);
    1974             : #else
    1975             :                                                                 connection->rsrc_id = zend_list_insert(connection, le_pconnection);
    1976             : #endif
    1977             :                                                                 /* Persistent connections: For old close semantics we artificially
    1978             :                                                                  * bump up the refcount to prevent the non-persistent destructor
    1979             :                                                                  * from getting called until request shutdown. The refcount is
    1980             :                                                                  * decremented in the persistent helper
    1981             :                                                                  */
    1982           8 :                                                                 if (OCI_G(old_oci_close_semantics)) {
    1983           0 :                                                                         zend_list_addref(connection->rsrc_id);
    1984             :                                                                 }
    1985             :                                                         }
    1986          14 :                                                         smart_str_free_ex(&hashed_details, 0);
    1987          14 :                                                         return connection;
    1988             :                                                 }
    1989             :                                         }
    1990             :                                         /* server died */
    1991             :                                 } else {
    1992             :                                         /* we do not ping non-persistent connections */
    1993          18 :                                         smart_str_free_ex(&hashed_details, 0);
    1994          18 :                                         zend_list_addref(connection->rsrc_id);
    1995          18 :                                         return connection;
    1996             :                                 }
    1997             :                         } /* is_open is true? */
    1998             : 
    1999             :                         /* Server died - connection not usable. The is_open=true can also fall through to here,
    2000             :                          * if ping fails
    2001             :                          */
    2002           0 :                         if (persistent){
    2003             :                                 int rsrc_type;
    2004             : 
    2005           0 :                                 connection->is_open = 0;
    2006           0 :                                 connection->used_this_request = 1;
    2007             : 
    2008             :                                 /* We have to do a hash_del but need to preserve the resource if there is a positive
    2009             :                                  * refcount. Set the data pointer in the list entry to NULL
    2010             :                                  */
    2011           0 :                                 if (connection == zend_list_find(connection->rsrc_id, &rsrc_type) && rsrc_type == le_pconnection) {
    2012           0 :                                         le->ptr = NULL;
    2013             :                                 }
    2014             : 
    2015           0 :                                 zend_hash_del(&EG(persistent_list), hashed_details.c, hashed_details.len+1);
    2016             :                         } else {
    2017             :                                 /* We only remove the hash entry. The resource and the list entry with its pointer
    2018             :                                  * to the resource are still intact
    2019             :                                  */
    2020           0 :                                 zend_hash_del(&EG(regular_list), hashed_details.c, hashed_details.len+1);
    2021             :                         }
    2022             : 
    2023           0 :                         connection = NULL;
    2024         545 :                 } else if (found) {
    2025             :                         /* found something, but it's not a connection, delete it */
    2026          10 :                         if (persistent) {
    2027           0 :                                 zend_hash_del(&EG(persistent_list), hashed_details.c, hashed_details.len+1);
    2028             :                         } else {
    2029          10 :                                 zend_hash_del(&EG(regular_list), hashed_details.c, hashed_details.len+1);
    2030             :                         }
    2031             :                 }
    2032             :         }
    2033             : 
    2034             :         /* Check if we have reached max_persistent. If so, try to remove a few timed-out connections. As
    2035             :          * a last resort, return a non-persistent connection.
    2036             :          */
    2037         593 :         if (persistent) {
    2038          36 :                 zend_bool alloc_non_persistent = 0;
    2039             : 
    2040          36 :                 if (OCI_G(max_persistent) != -1 && OCI_G(num_persistent) >= OCI_G(max_persistent)) {
    2041             :                         /* try to find an idle connection and kill it */
    2042           0 :                         zend_hash_apply(&EG(persistent_list), (apply_func_t) php_oci_persistent_helper TSRMLS_CC);
    2043             : 
    2044           0 :                         if (OCI_G(max_persistent) != -1 && OCI_G(num_persistent) >= OCI_G(max_persistent)) {
    2045             :                                 /* all persistent connactions are in use, fallback to non-persistent connection creation */
    2046           0 :                                 php_error_docref(NULL TSRMLS_CC, E_NOTICE, "Too many open persistent connections (%ld)", OCI_G(num_persistent));
    2047           0 :                                 alloc_non_persistent = 1;
    2048             :                         }
    2049             :                 }
    2050             : 
    2051          36 :                 if (alloc_non_persistent) {
    2052           0 :                         connection = (php_oci_connection *) ecalloc(1, sizeof(php_oci_connection));
    2053           0 :                         connection->hash_key = estrndup(hashed_details.c, hashed_details.len);
    2054           0 :                         connection->is_persistent = 0;
    2055             :                 } else {
    2056          36 :                         connection = (php_oci_connection *) calloc(1, sizeof(php_oci_connection));
    2057          36 :                         if (connection == NULL) {
    2058           0 :                                 return NULL;
    2059             :                         }
    2060          36 :                         connection->hash_key = zend_strndup(hashed_details.c, hashed_details.len);
    2061          36 :                         if (connection->hash_key == NULL) {
    2062           0 :                                 free(connection);
    2063           0 :                                 return NULL;
    2064             :                         }
    2065          36 :                         connection->is_persistent = 1;
    2066             :                 }
    2067             :         } else {
    2068         557 :                 connection = (php_oci_connection *) ecalloc(1, sizeof(php_oci_connection));
    2069         557 :                 connection->hash_key = estrndup(hashed_details.c, hashed_details.len);
    2070         557 :                 connection->is_persistent = 0;
    2071             :         }
    2072             : 
    2073             :         /* {{{ Get the session pool that suits this connection request from the persistent list. This
    2074             :          * step is only for non-persistent connections as persistent connections have private session
    2075             :          * pools. Non-persistent conns use shared session pool to allow for optimizations such as
    2076             :          * caching the physical connection (for DRCP) even when the non-persistent php connection is
    2077             :          * destroyed.
    2078             :          *
    2079             :          * TODO: Unconditionally do this once OCI provides extended OCISessionGet capability
    2080             :          */
    2081         593 :         if (use_spool && !connection->is_persistent) {
    2082         534 :                 if ((session_pool = php_oci_get_spool(username, username_len, password, password_len, dbname, dbname_len, charsetid ? charsetid:charsetid_nls_lang TSRMLS_CC))==NULL)
    2083             :                 {
    2084           0 :                         php_oci_connection_close(connection TSRMLS_CC);
    2085           0 :                         smart_str_free_ex(&hashed_details, 0);
    2086           0 :                         return NULL;
    2087             :                 }
    2088             :         } /* }}} */
    2089             : 
    2090         593 :         connection->idle_expiry = (OCI_G(persistent_timeout) > 0) ? (timestamp + OCI_G(persistent_timeout)) : 0;
    2091             : 
    2092             :         /* Mark password as unchanged by PHP during the duration of the database session */
    2093         593 :         connection->passwd_changed = 0;
    2094             : 
    2095         593 :         smart_str_free_ex(&hashed_details, 0);
    2096             : 
    2097         593 :         if (charsetid) {
    2098           8 :                 connection->charset = charsetid;
    2099             :         } else {
    2100         585 :                 connection->charset = charsetid_nls_lang;
    2101             :         }
    2102             : 
    2103             :         /* Old session creation semantics when session pool cannot be used Eg: privileged
    2104             :          * connect/password change
    2105             :          */
    2106         593 :         if (!use_spool) {
    2107          25 :                 if (php_oci_old_create_session(connection, dbname, dbname_len, username, username_len, password, password_len, new_password, new_password_len, session_mode TSRMLS_CC)) {
    2108          21 :                         php_oci_connection_close(connection TSRMLS_CC);
    2109          21 :                         return NULL;
    2110             :                 }
    2111             :         } else {
    2112             :                 /* create using the client-side session pool */
    2113         568 :                 if (php_oci_create_session(connection, session_pool, dbname, dbname_len, username, username_len, password, password_len, new_password, new_password_len, session_mode TSRMLS_CC)) {
    2114           5 :                         php_oci_connection_close(connection TSRMLS_CC);
    2115           5 :                         return NULL;
    2116             :                 }
    2117             :         }
    2118             : 
    2119             :         /* Mark it as open */
    2120         567 :         connection->is_open = 1;
    2121             : 
    2122             :         /* add to the appropriate hash */
    2123         567 :         if (connection->is_persistent) {
    2124          34 :                 new_le.ptr = connection;
    2125          34 :                 new_le.type = le_pconnection;
    2126          34 :                 connection->used_this_request = 1;
    2127             : #if (PHP_MAJOR_VERSION == 5 && PHP_MINOR_VERSION > 3) || (PHP_MAJOR_VERSION > 5)
    2128          34 :                 connection->rsrc_id = zend_list_insert(connection, le_pconnection TSRMLS_CC);
    2129             : #else
    2130             :                 connection->rsrc_id = zend_list_insert(connection, le_pconnection);
    2131             : #endif
    2132             : 
    2133             :                 /* Persistent connections: For old close semantics we artificially bump up the refcount to
    2134             :                  * prevent the non-persistent destructor from getting called until request shutdown. The
    2135             :                  * refcount is decremented in the persistent helper
    2136             :                  */
    2137          34 :                 if (OCI_G(old_oci_close_semantics)) {
    2138           4 :                         zend_list_addref(connection->rsrc_id);
    2139             :                 }
    2140          34 :                 zend_hash_update(&EG(persistent_list), connection->hash_key, strlen(connection->hash_key)+1, (void *)&new_le, sizeof(zend_rsrc_list_entry), NULL);
    2141          34 :                 OCI_G(num_persistent)++;
    2142          34 :                 OCI_G(num_links)++;
    2143         533 :         } else if (!exclusive) {
    2144             : #if (PHP_MAJOR_VERSION == 5 && PHP_MINOR_VERSION > 3) || (PHP_MAJOR_VERSION > 5)
    2145         496 :                 connection->rsrc_id = zend_list_insert(connection, le_connection TSRMLS_CC);
    2146             : #else
    2147             :                 connection->rsrc_id = zend_list_insert(connection, le_connection);
    2148             : #endif
    2149         496 :                 new_le.ptr = OCI8_INT_TO_PTR(connection->rsrc_id);
    2150         496 :                 new_le.type = le_index_ptr;
    2151         496 :                 zend_hash_update(&EG(regular_list), connection->hash_key, strlen(connection->hash_key)+1, (void *)&new_le, sizeof(zend_rsrc_list_entry), NULL);
    2152         496 :                 OCI_G(num_links)++;
    2153             :         } else {
    2154             : #if (PHP_MAJOR_VERSION == 5 && PHP_MINOR_VERSION > 3) || (PHP_MAJOR_VERSION > 5)
    2155          37 :                 connection->rsrc_id = zend_list_insert(connection, le_connection TSRMLS_CC);
    2156             : #else
    2157             :                 connection->rsrc_id = zend_list_insert(connection, le_connection);
    2158             : #endif
    2159          37 :                 OCI_G(num_links)++;
    2160             :         }
    2161             : 
    2162             :         /* Debug statements {{{ */
    2163         567 :         if (OCI_G(debug_mode)) {
    2164           1 :                 if (connection->is_persistent) {
    2165           0 :                         php_printf ("OCI8 DEBUG L1: New Persistent Connection address: (%p) at (%s:%d) \n", connection, __FILE__, __LINE__);
    2166             :                 } else {
    2167           1 :                         php_printf ("OCI8 DEBUG L1: New Non-Persistent Connection address: (%p) at (%s:%d) \n", connection, __FILE__, __LINE__);
    2168             :                 }
    2169           1 :                 php_printf ("OCI8 DEBUG L1: num_persistent=(%ld), num_links=(%ld) at (%s:%d) \n", OCI_G(num_persistent), OCI_G(num_links), __FILE__, __LINE__);
    2170             :         } /* }}} */
    2171             : 
    2172         567 :         return connection;
    2173             : }
    2174             : /* }}} */
    2175             : 
    2176             : /* {{{ php_oci_connection_ping()
    2177             :  *
    2178             :  * Ping connection. Uses OCIPing() or OCIServerVersion() depending on the Oracle Client version
    2179             :  */
    2180           1 : static int php_oci_connection_ping(php_oci_connection *connection TSRMLS_DC)
    2181             : {
    2182             :         /* Use OCIPing instead of OCIServerVersion. If OCIPing returns ORA-1010 (invalid OCI operation)
    2183             :          * such as from Pre-10.1 servers, the error is still from the server and we would have
    2184             :          * successfully performed a roundtrip and validated the connection. Use OCIServerVersion for
    2185             :          * Pre-10.2 clients
    2186             :          */
    2187             : #if ((OCI_MAJOR_VERSION > 10) || ((OCI_MAJOR_VERSION == 10) && (OCI_MINOR_VERSION >= 2))) /* OCIPing available 10.2 onwards */
    2188           1 :         PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIPing, (connection->svc, OCI_G(err), OCI_DEFAULT));
    2189             : #else
    2190             :         char version[256];
    2191             :         /* use good old OCIServerVersion() */
    2192             :         PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIServerVersion, (connection->svc, OCI_G(err), (text *)version, sizeof(version), OCI_HTYPE_SVCCTX));
    2193             : #endif
    2194             : 
    2195           1 :         if (OCI_G(errcode) == OCI_SUCCESS) {
    2196           1 :                 return 1;
    2197             :         } else {
    2198           0 :                 sb4 error_code = 0;
    2199             :                 text tmp_buf[OCI_ERROR_MAXMSG_SIZE];
    2200             : 
    2201             :                 /* Treat ORA-1010 as a successful Ping */
    2202           0 :                 OCIErrorGet(OCI_G(err), (ub4)1, NULL, &error_code, tmp_buf, (ub4)OCI_ERROR_MAXMSG_SIZE, (ub4)OCI_HTYPE_ERROR);
    2203           0 :                 if (error_code == 1010) {
    2204           0 :                         return 1;
    2205             :                 }
    2206             :         }
    2207             : 
    2208             :         /* ignore errors here, just return failure
    2209             :          * php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC); */
    2210           0 :         return 0;
    2211             : }
    2212             : /* }}} */
    2213             : 
    2214             : /* {{{ php_oci_connection_status()
    2215             :  *
    2216             :  * Check connection status (pre-ping check)
    2217             :  */
    2218          14 : static int php_oci_connection_status(php_oci_connection *connection TSRMLS_DC)
    2219             : {
    2220          14 :         ub4 ss = 0;
    2221             : 
    2222             :         /* get OCI_ATTR_SERVER_STATUS */
    2223          14 :         PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIAttrGet, ((dvoid *)connection->server, OCI_HTYPE_SERVER, (dvoid *)&ss, (ub4 *)0, OCI_ATTR_SERVER_STATUS, OCI_G(err)));
    2224             : 
    2225          14 :         if (OCI_G(errcode) == OCI_SUCCESS && ss == OCI_SERVER_NORMAL) {
    2226          14 :                 return 1;
    2227             :         }
    2228             : 
    2229             :         /* ignore errors here, just return failure
    2230             :          * php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC); */
    2231           0 :         return 0;
    2232             : }
    2233             : /* }}} */
    2234             : 
    2235             : /* {{{ php_oci_connection_rollback()
    2236             :  *
    2237             :  * Rollback connection
    2238             :  */
    2239          54 : int php_oci_connection_rollback(php_oci_connection *connection TSRMLS_DC)
    2240             : {
    2241          54 :         PHP_OCI_CALL_RETURN(connection->errcode, OCITransRollback, (connection->svc, connection->err, (ub4) 0));
    2242          54 :         connection->needs_commit = 0;
    2243             : 
    2244          54 :         if (connection->errcode != OCI_SUCCESS) {
    2245           0 :                 connection->errcode = php_oci_error(connection->err, connection->errcode TSRMLS_CC);
    2246           0 :                 PHP_OCI_HANDLE_ERROR(connection, connection->errcode);
    2247           0 :                 return 1;
    2248             :         }
    2249          54 :         return 0;
    2250             : } /* }}} */
    2251             : 
    2252             : /* {{{ php_oci_connection_commit()
    2253             :  *
    2254             :  * Commit connection
    2255             :  */
    2256          89 : int php_oci_connection_commit(php_oci_connection *connection TSRMLS_DC)
    2257             : {
    2258          89 :         PHP_OCI_CALL_RETURN(connection->errcode, OCITransCommit, (connection->svc, connection->err, (ub4) 0));
    2259          89 :         connection->needs_commit = 0;
    2260             : 
    2261          89 :         if (connection->errcode != OCI_SUCCESS) {
    2262           1 :                 connection->errcode = php_oci_error(connection->err, connection->errcode TSRMLS_CC);
    2263           1 :                 PHP_OCI_HANDLE_ERROR(connection, connection->errcode);
    2264           1 :                 return 1;
    2265             :         }
    2266          88 :         return 0;
    2267             : } /* }}} */
    2268             : 
    2269             : /* {{{ php_oci_connection_close()
    2270             :  *
    2271             :  * Close the connection and free all its resources
    2272             :  */
    2273         593 : static int php_oci_connection_close(php_oci_connection *connection TSRMLS_DC)
    2274             : {
    2275         593 :         int result = 0;
    2276         593 :         zend_bool in_call_save = OCI_G(in_call);
    2277             : 
    2278         593 :         if (!connection->is_stub) {
    2279             :                 /* Release resources associated with connection */
    2280         560 :                 php_oci_connection_release(connection TSRMLS_CC);
    2281             :         }
    2282             : 
    2283         593 :         if (!connection->using_spool && connection->svc) {
    2284          11 :                         PHP_OCI_CALL(OCISessionEnd, (connection->svc, connection->err, connection->session, (ub4) 0));
    2285             :         }
    2286             : 
    2287         593 :         if (connection->err) {
    2288         579 :                 PHP_OCI_CALL(OCIHandleFree, ((dvoid *) connection->err, (ub4) OCI_HTYPE_ERROR));
    2289             :         }
    2290         593 :         if (connection->authinfo) {
    2291         568 :                 PHP_OCI_CALL(OCIHandleFree, ((dvoid *) connection->authinfo, (ub4) OCI_HTYPE_AUTHINFO));
    2292             :         }
    2293             : 
    2294             :         /* No Handlefrees for session pool connections */
    2295         593 :         if (!connection->using_spool) {
    2296          25 :                 if (connection->session) {
    2297          11 :                         PHP_OCI_CALL(OCIHandleFree, ((dvoid *) connection->session, OCI_HTYPE_SESSION));
    2298             :                 }
    2299             : 
    2300          25 :                 if (connection->is_attached) {
    2301          11 :                         PHP_OCI_CALL(OCIServerDetach, (connection->server, OCI_G(err), OCI_DEFAULT));
    2302             :                 }
    2303             : 
    2304          25 :                 if (connection->svc) {
    2305          11 :                         PHP_OCI_CALL(OCIHandleFree, ((dvoid *) connection->svc,      (ub4) OCI_HTYPE_SVCCTX));
    2306             :                 }
    2307             : 
    2308          25 :                 if (connection->server) {
    2309          25 :                         PHP_OCI_CALL(OCIHandleFree, ((dvoid *) connection->server, (ub4) OCI_HTYPE_SERVER));
    2310             :                 }
    2311             : 
    2312          25 :                 if (connection->env) {
    2313          25 :                         PHP_OCI_CALL(OCIHandleFree, ((dvoid *) connection->env, OCI_HTYPE_ENV));
    2314             :                 }
    2315         568 :         } else if (connection->private_spool) {
    2316             :         /* Keep this as the last member to be freed, as there are dependencies
    2317             :          * (like env) on the session pool
    2318             :          */
    2319          34 :                 php_oci_spool_close(connection->private_spool TSRMLS_CC);
    2320             :         }
    2321             : 
    2322         593 :         if (connection->is_persistent) {
    2323          36 :                 if (connection->hash_key) {
    2324          36 :                         free(connection->hash_key);
    2325             :                 }
    2326          36 :                 free(connection);
    2327             :         } else {
    2328         557 :                 if (connection->hash_key) {
    2329         557 :                         efree(connection->hash_key);
    2330             :                 }
    2331         557 :                 efree(connection);
    2332             :         }
    2333         593 :         connection = NULL;
    2334         593 :         OCI_G(in_call) = in_call_save;
    2335         593 :         return result;
    2336             : } /* }}} */
    2337             : 
    2338             : /* {{{ php_oci_connection_release()
    2339             :  *
    2340             :  * Release the connection's resources. This involves freeing descriptors and rolling back
    2341             :  * transactions, setting timeout-related parameters etc. For session-pool using connections, the
    2342             :  * underlying connection is released to its session pool.
    2343             :  */
    2344         601 : int php_oci_connection_release(php_oci_connection *connection TSRMLS_DC)
    2345             : {
    2346         601 :         int result = 0;
    2347         601 :         zend_bool in_call_save = OCI_G(in_call);
    2348         601 :         time_t timestamp = time(NULL);
    2349             : 
    2350         601 :         if (connection->is_stub) {
    2351           0 :                 return 0;
    2352             :         }
    2353             : 
    2354         601 :         if (connection->descriptors) {
    2355          70 :                 php_oci_connection_descriptors_free(connection TSRMLS_CC);
    2356             :         }
    2357             : 
    2358         601 :         if (connection->svc) {
    2359             :                 /* rollback outstanding transactions */
    2360         582 :                 if (connection->needs_commit) {
    2361          49 :                         if (php_oci_connection_rollback(connection TSRMLS_CC)) {
    2362             :                                 /* rollback failed */
    2363           0 :                                 result = 1;
    2364             :                         }
    2365             :                 }
    2366             :         }
    2367             : 
    2368         601 :         if (OCI_G(persistent_timeout) > 0) {
    2369           0 :                 connection->idle_expiry = timestamp + OCI_G(persistent_timeout);
    2370             :         }
    2371             : 
    2372             :         /* We may have half-cooked connections to clean up */
    2373         601 :         if (connection->next_pingp) {
    2374         575 :                 if (OCI_G(ping_interval) >= 0) {
    2375         575 :                         *(connection->next_pingp) = timestamp + OCI_G(ping_interval);
    2376             :                 } else {
    2377             :                         /* ping_interval is -1 */
    2378           0 :                         *(connection->next_pingp) = 0;
    2379             :                 }
    2380             :         }
    2381             : 
    2382             :         /* Release the session (stubs are filtered out at the beginning)*/
    2383         601 :         if (connection->using_spool) {
    2384         576 :                 ub4 rlsMode = OCI_DEFAULT;
    2385             : 
    2386         576 :                 if (result) {
    2387           0 :                         rlsMode |= OCI_SESSRLS_DROPSESS;
    2388             :                 }
    2389             : 
    2390             :                 /* Sessions for non-persistent connections should be dropped.  For 11 and above, the session
    2391             :                  * pool has its own mechanism for doing so for purity NEW connections. We need to do so
    2392             :                  * explicitly for 10.2 and earlier.
    2393             :                  */
    2394             : #if (!(OCI_MAJOR_VERSION >= 11))
    2395             :                 if (!connection->is_persistent) {
    2396             :                         rlsMode |= OCI_SESSRLS_DROPSESS;
    2397             :                 }
    2398             : #endif
    2399             : 
    2400         576 :                 if (connection->svc) {
    2401         571 :                         PHP_OCI_CALL(OCISessionRelease, (connection->svc, connection->err, NULL,
    2402             :                                                                                  0, rlsMode));
    2403             :                 }
    2404             :                 /* It no longer has relation with the database session. However authinfo and env are
    2405             :                  * cached
    2406             :                  */
    2407         576 :                 connection->svc = NULL;
    2408         576 :                 connection->server = NULL;
    2409         576 :                 connection->session = NULL;
    2410             : 
    2411         576 :                 connection->is_attached = connection->is_open = connection->needs_commit = connection->used_this_request = 0;
    2412         576 :                 connection->is_stub = 1;
    2413             : 
    2414             :                 /* Cut the link between the connection structure and the time_t structure allocated within
    2415             :                  * the OCI session
    2416             :                  */
    2417         576 :                 connection->next_pingp = NULL;
    2418             :         }
    2419             : 
    2420         601 :         OCI_G(in_call) = in_call_save;
    2421         601 :         return result;
    2422             : } /* }}} */
    2423             : 
    2424             : /* {{{ php_oci_password_change()
    2425             :  *
    2426             :  * Change password for the user with the username given
    2427             :  */
    2428           2 : int php_oci_password_change(php_oci_connection *connection, char *user, int user_len, char *pass_old, int pass_old_len, char *pass_new, int pass_new_len TSRMLS_DC)
    2429             : {
    2430           2 :         PHP_OCI_CALL_RETURN(connection->errcode, OCIPasswordChange, (connection->svc, connection->err, (text *)user, user_len, (text *)pass_old, pass_old_len, (text *)pass_new, pass_new_len, OCI_DEFAULT));
    2431             : 
    2432           2 :         if (connection->errcode != OCI_SUCCESS) {
    2433           0 :                 connection->errcode = php_oci_error(connection->err, connection->errcode TSRMLS_CC);
    2434           0 :                 PHP_OCI_HANDLE_ERROR(connection, connection->errcode);
    2435           0 :                 return 1;
    2436             :         }
    2437           2 :         connection->passwd_changed = 1;
    2438           2 :         return 0;
    2439             : } /* }}} */
    2440             : 
    2441             : 
    2442             : /* {{{ php_oci_client_get_version()
    2443             :  *
    2444             :  * Get Oracle client library version
    2445             :  */
    2446         180 : void php_oci_client_get_version(char **version TSRMLS_DC)
    2447             : {
    2448             :         char  version_buff[256];
    2449         180 :         sword major_version = 0;
    2450         180 :         sword minor_version = 0; 
    2451         180 :         sword update_num = 0;
    2452         180 :         sword patch_num = 0;
    2453         180 :         sword port_update_num = 0;
    2454             : 
    2455             : #if ((OCI_MAJOR_VERSION > 10) || ((OCI_MAJOR_VERSION == 10) && (OCI_MINOR_VERSION >= 2))) /* OCIClientVersion only available 10.2 onwards */
    2456         180 :         PHP_OCI_CALL(OCIClientVersion, (&major_version, &minor_version, &update_num, &patch_num, &port_update_num));
    2457         180 :         snprintf(version_buff, sizeof(version_buff), "%d.%d.%d.%d.%d", major_version, minor_version, update_num, patch_num, port_update_num);
    2458             : #else
    2459             :         memcpy(version_buff, "Unknown", sizeof("Unknown"));
    2460             : #endif
    2461         180 :         *version = estrdup(version_buff);
    2462         180 : } /* }}} */
    2463             : 
    2464             : 
    2465             : /* {{{ php_oci_server_get_version()
    2466             :  *
    2467             :  * Get Oracle server version
    2468             :  */
    2469         256 : int php_oci_server_get_version(php_oci_connection *connection, char **version TSRMLS_DC)
    2470             : {
    2471             :         char version_buff[256];
    2472             : 
    2473         256 :         PHP_OCI_CALL_RETURN(connection->errcode, OCIServerVersion, (connection->svc, connection->err, (text *)version_buff, sizeof(version_buff), OCI_HTYPE_SVCCTX));
    2474             : 
    2475         256 :         if (connection->errcode != OCI_SUCCESS) {
    2476           0 :                 connection->errcode = php_oci_error(connection->err, connection->errcode TSRMLS_CC);
    2477           0 :                 PHP_OCI_HANDLE_ERROR(connection, connection->errcode);
    2478           0 :                 return 1;
    2479             :         }
    2480             : 
    2481         256 :         *version = estrdup(version_buff);
    2482         256 :         return 0;
    2483             : } /* }}} */
    2484             : 
    2485             : /* {{{ php_oci_column_to_zval()
    2486             :  *
    2487             :  * Convert php_oci_out_column struct into zval
    2488             :  */
    2489      482590 : int php_oci_column_to_zval(php_oci_out_column *column, zval *value, int mode TSRMLS_DC)
    2490             : {
    2491             :         php_oci_descriptor *descriptor;
    2492             :         ub4 lob_length;
    2493             :         int column_size;
    2494             :         char *lob_buffer;
    2495             :         int lob_fetch_status;
    2496             : 
    2497      482590 :         if (column->indicator == -1) { /* column is NULL */
    2498         106 :                 ZVAL_NULL(value);
    2499         106 :                 return 0;
    2500             :         }
    2501             : 
    2502      482484 :         if (column->is_cursor) { /* REFCURSOR -> simply return the statement id */
    2503        1417 :                 ZVAL_RESOURCE(value, column->stmtid);
    2504        1417 :                 zend_list_addref(column->stmtid);
    2505      481067 :         } else if (column->is_descr) {
    2506             : 
    2507      373324 :                 if (column->data_type != SQLT_RDD) {
    2508             :                         int rsrc_type;
    2509             : 
    2510             :                         /* reset descriptor's length */
    2511      373323 :                         descriptor = (php_oci_descriptor *) zend_list_find(column->descid, &rsrc_type);
    2512             : 
    2513      373323 :                         if (!descriptor || rsrc_type != le_descriptor) {
    2514           0 :                                 php_error_docref(NULL TSRMLS_CC, E_WARNING, "Unable to find LOB descriptor #%d", column->descid);
    2515           0 :                                 return 1;
    2516             :                         }
    2517             : 
    2518      373323 :                         descriptor->lob_size = -1;
    2519      373323 :                         descriptor->lob_current_position = 0;
    2520      373323 :                         descriptor->buffering = 0;
    2521             :                 }
    2522             : 
    2523      373324 :                 if (column->data_type != SQLT_RDD && (mode & PHP_OCI_RETURN_LOBS)) {
    2524             :                         /* PHP_OCI_RETURN_LOBS means that we want the content of the LOB back instead of the locator */
    2525             : 
    2526       51035 :                         lob_fetch_status = php_oci_lob_read(descriptor, -1, 0, &lob_buffer, &lob_length TSRMLS_CC);
    2527       51035 :                         php_oci_temp_lob_close(descriptor TSRMLS_CC);
    2528       51035 :                         if (lob_fetch_status) {
    2529           0 :                                 ZVAL_FALSE(value);
    2530           0 :                                 return 1;
    2531             :                         } else {
    2532       51035 :                                 if (lob_length > 0) {
    2533       51028 :                                         ZVAL_STRINGL(value, lob_buffer, lob_length, 0);
    2534             :                                 } else {
    2535           7 :                                         ZVAL_EMPTY_STRING(value);
    2536             :                                 }
    2537       51035 :                                 return 0;
    2538             :                         }
    2539             :                 } else {
    2540             :                         /* return the locator */
    2541      322289 :                         object_init_ex(value, oci_lob_class_entry_ptr);
    2542      322289 :                         add_property_resource(value, "descriptor", column->descid);
    2543      322289 :                         zend_list_addref(column->descid);
    2544             :                 }
    2545             :         } else {
    2546      107743 :                 switch (column->retcode) {
    2547             :                         case 0:
    2548             :                                 /* intact value */
    2549      107743 :                                 if (column->piecewise) {
    2550          13 :                                         column_size = column->retlen4;
    2551             :                                 } else {
    2552      107730 :                                         column_size = column->retlen;
    2553             :                                 }
    2554      107743 :                                 break;
    2555             : 
    2556             :                         default:
    2557           0 :                                 ZVAL_FALSE(value);
    2558           0 :                                 return 0;
    2559             :                 }
    2560             : 
    2561      107743 :                 ZVAL_STRINGL(value, column->data, column_size, 1);
    2562             :         }
    2563      431449 :         return 0;
    2564             : }
    2565             : /* }}} */
    2566             : 
    2567             : /* {{{ php_oci_fetch_row()
    2568             :  *
    2569             :  * Fetch the next row from the given statement
    2570             :  */
    2571      231444 : void php_oci_fetch_row (INTERNAL_FUNCTION_PARAMETERS, int mode, int expected_args)
    2572             : {
    2573             :         zval *z_statement, *array;
    2574             :         php_oci_statement *statement;
    2575             :         php_oci_out_column *column;
    2576      231444 :         ub4 nrows = 1;
    2577             :         int i;
    2578      231444 :         long fetch_mode = 0;
    2579             : 
    2580      231444 :         if (expected_args > 2) {
    2581             :                 /* only for ocifetchinto BC */
    2582             : 
    2583        6625 :                 if (zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "rz|l", &z_statement, &array, &fetch_mode) == FAILURE) {
    2584           2 :                         return;
    2585             :                 }
    2586             : 
    2587        6623 :                 if (ZEND_NUM_ARGS() == 2) {
    2588           1 :                         fetch_mode = mode;
    2589             :                 }
    2590      224819 :         } else if (expected_args == 2) {
    2591             :                 /* only for oci_fetch_array() */
    2592             : 
    2593      104691 :                 if (zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "r|l", &z_statement, &fetch_mode) == FAILURE) {
    2594           0 :                         return;
    2595             :                 }
    2596             : 
    2597      104691 :                 if (ZEND_NUM_ARGS() == 1) {
    2598          67 :                         fetch_mode = mode;
    2599             :                 }
    2600             :         } else {
    2601             :                 /* for all oci_fetch_*() */
    2602             : 
    2603      120128 :                 if (zend_parse_parameters(ZEND_NUM_ARGS() TSRMLS_CC, "r", &z_statement) == FAILURE) {
    2604           0 :                         return;
    2605             :                 }
    2606             : 
    2607      120128 :                 fetch_mode = mode;
    2608             :         }
    2609             : 
    2610      231442 :         if (!(fetch_mode & PHP_OCI_NUM) && !(fetch_mode & PHP_OCI_ASSOC)) {
    2611             :                 /* none of the modes present, use the default one */
    2612          26 :                 if (mode & PHP_OCI_ASSOC) {
    2613          21 :                         fetch_mode |= PHP_OCI_ASSOC;
    2614             :                 }
    2615          26 :                 if (mode & PHP_OCI_NUM) {
    2616          26 :                         fetch_mode |= PHP_OCI_NUM;
    2617             :                 }
    2618             :         }
    2619             : 
    2620      231442 :         PHP_OCI_ZVAL_TO_STATEMENT(z_statement, statement);
    2621             : 
    2622      231441 :         if (php_oci_statement_fetch(statement, nrows TSRMLS_CC)) {
    2623       30091 :                 RETURN_FALSE;
    2624             :         }
    2625             : 
    2626      201350 :         array_init(return_value);
    2627             : 
    2628      593393 :         for (i = 0; i < statement->ncolumns; i++) {
    2629             : 
    2630      392043 :                 column = php_oci_statement_get_column(statement, i + 1, NULL, 0 TSRMLS_CC);
    2631             : 
    2632      392043 :                 if (column == NULL) {
    2633           0 :                         continue;
    2634             :                 }
    2635      392043 :                 if ((column->indicator == -1) && ((fetch_mode & PHP_OCI_RETURN_NULLS) == 0)) {
    2636          51 :                         continue;
    2637             :                 }
    2638             : 
    2639      391992 :                 if (!(column->indicator == -1)) {
    2640             :                         zval *element;
    2641             : 
    2642      391929 :                         MAKE_STD_ZVAL(element);
    2643      391929 :                         php_oci_column_to_zval(column, element, fetch_mode TSRMLS_CC);
    2644             : 
    2645      391929 :                         if (fetch_mode & PHP_OCI_NUM || !(fetch_mode & PHP_OCI_ASSOC)) {
    2646        9525 :                                 add_index_zval(return_value, i, element);
    2647             :                         }
    2648      391929 :                         if (fetch_mode & PHP_OCI_ASSOC) {
    2649      382486 :                                 if (fetch_mode & PHP_OCI_NUM) {
    2650             :                                         Z_ADDREF_P(element);
    2651             :                                 }
    2652      382486 :                                 add_assoc_zval(return_value, column->name, element);
    2653             :                         }
    2654             : 
    2655             :                 } else {
    2656          63 :                         if (fetch_mode & PHP_OCI_NUM || !(fetch_mode & PHP_OCI_ASSOC)) {
    2657          52 :                                 add_index_null(return_value, i);
    2658             :                         }
    2659          63 :                         if (fetch_mode & PHP_OCI_ASSOC) {
    2660          36 :                                 add_assoc_null(return_value, column->name);
    2661             :                         }
    2662             :                 }
    2663             :         }
    2664             : 
    2665      201350 :         if (expected_args > 2) {
    2666             :                 /* Only for ocifetchinto BC.  In all other cases we return array, not long */
    2667       52944 :                 REPLACE_ZVAL_VALUE(&array, return_value, 1); /* copy return_value to given reference */
    2668             :                 zval_dtor(return_value);
    2669        6618 :                 RETURN_LONG(statement->ncolumns);
    2670             :         }
    2671             : }
    2672             : /* }}} */
    2673             : 
    2674             : /* {{{ php_oci_persistent_helper()
    2675             :  *
    2676             :  * Helper function to close/rollback persistent connections at the end of request. A return value of
    2677             :  * 1 indicates that the connection is to be destroyed
    2678             :  */
    2679         582 : static int php_oci_persistent_helper(zend_rsrc_list_entry *le TSRMLS_DC)
    2680             : {
    2681             :         time_t timestamp;
    2682             :         php_oci_connection *connection;
    2683             : 
    2684         582 :         timestamp = time(NULL);
    2685             : 
    2686             :         /* Persistent connection stubs are also counted as they have private session pools */
    2687         582 :         if (le->type == le_pconnection) {
    2688          34 :                 connection = (php_oci_connection *)le->ptr;
    2689             : 
    2690          34 :                 if (!connection->used_this_request && OCI_G(persistent_timeout) != -1) {
    2691           0 :                         if (OCI_G(debug_mode)) {
    2692           0 :                                 php_printf ("OCI8 DEBUG L1: persistent_helper processing for timeout: (%p stub=%d) at (%s:%d) \n", connection, connection->is_stub, __FILE__, __LINE__);
    2693             :                         }
    2694           0 :                         if (connection->idle_expiry < timestamp) {
    2695             :                                 /* connection has timed out */
    2696           0 :                                 return ZEND_HASH_APPLY_REMOVE;
    2697             :                         }
    2698             :                 }
    2699             :         }
    2700         582 :         return ZEND_HASH_APPLY_KEEP;
    2701             : } /* }}} */
    2702             : 
    2703             : /* {{{ php_oci_create_spool()
    2704             :  *
    2705             :  *       Create(alloc + Init) Session pool for the given dbname and charsetid
    2706             :  */
    2707         530 : static php_oci_spool *php_oci_create_spool(char *username, int username_len, char *password, int password_len, char *dbname, int dbname_len, char *hash_key, int hash_key_len, int charsetid TSRMLS_DC)
    2708             : {
    2709         530 :         php_oci_spool *session_pool = NULL;
    2710         530 :         zend_bool iserror = 0;
    2711         530 :         ub4 poolmode = OCI_DEFAULT;     /* Mode to be passed to OCISessionPoolCreate */
    2712         530 :         OCIAuthInfo *spoolAuth = NULL;
    2713             : 
    2714             :         /* Allocate sessionpool out of persistent memory */
    2715         530 :         session_pool = (php_oci_spool *) calloc(1, sizeof(php_oci_spool));
    2716         530 :         if (session_pool == NULL) {
    2717           0 :                 iserror = 1;
    2718           0 :                 goto exit_create_spool;
    2719             :         }
    2720             : 
    2721             :         /* Populate key if passed */
    2722         530 :         if (hash_key_len) {
    2723         496 :                 session_pool->spool_hash_key = zend_strndup(hash_key, hash_key_len);
    2724         496 :                 if (session_pool->spool_hash_key == NULL) {
    2725           0 :                         iserror = 1;
    2726           0 :                         goto exit_create_spool;
    2727             :                 }
    2728             :         }
    2729             : 
    2730             :         /* Create the session pool's env */
    2731         530 :         if (!(session_pool->env = php_oci_create_env(charsetid TSRMLS_CC))) {
    2732           0 :                 iserror = 1;
    2733           0 :                 goto exit_create_spool;
    2734             :         }
    2735             : 
    2736             :         /* Allocate the pool handle */
    2737         530 :         PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIHandleAlloc, (session_pool->env, (dvoid **) &session_pool->poolh, OCI_HTYPE_SPOOL, (size_t) 0, (dvoid **) 0));
    2738             : 
    2739         530 :         if (OCI_G(errcode) != OCI_SUCCESS) {
    2740           0 :                 php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    2741           0 :                 iserror = 1;
    2742           0 :                 goto exit_create_spool;
    2743             :         }
    2744             : 
    2745             :         /* Allocate the session pool error handle - This only for use in the destructor, as there is a
    2746             :          * generic bug which can free up the OCI_G(err) variable before destroying connections. We
    2747             :          * cannot use this for other roundtrip calls as there is no way the user can access this error
    2748             :          */
    2749         530 :         PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIHandleAlloc, ((dvoid *) session_pool->env, (dvoid **)&(session_pool->err), (ub4) OCI_HTYPE_ERROR,(size_t) 0, (dvoid **) 0));
    2750             : 
    2751         530 :         if (OCI_G(errcode) != OCI_SUCCESS) {
    2752           0 :                 php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    2753           0 :                 iserror = 1;
    2754           0 :                 goto exit_create_spool;
    2755             :         }
    2756             : 
    2757             : /* Disable RLB as we mostly have single-connection pools */
    2758             : #if (OCI_MAJOR_VERSION > 10)
    2759         530 :         poolmode = OCI_SPC_NO_RLB | OCI_SPC_HOMOGENEOUS;
    2760             : #else
    2761             :         poolmode = OCI_SPC_HOMOGENEOUS;
    2762             : #endif
    2763             : 
    2764             : #if ((OCI_MAJOR_VERSION > 11) || ((OCI_MAJOR_VERSION == 11) && (OCI_MINOR_VERSION >= 2)))
    2765             :         /* Allocate auth handle for session pool {{{ */
    2766         530 :         PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIHandleAlloc, (session_pool->env, (dvoid **)&(spoolAuth), OCI_HTYPE_AUTHINFO, 0, NULL));
    2767             : 
    2768         530 :         if (OCI_G(errcode) != OCI_SUCCESS) {
    2769           0 :                 php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    2770           0 :                 iserror = 1;
    2771           0 :                 goto exit_create_spool;
    2772             :         } /* }}} */
    2773             : 
    2774             :         /* Set the edition attribute on the auth handle {{{ */
    2775         530 :         if (OCI_G(edition)) {
    2776          11 :                 PHP_OCI_CALL_RETURN(OCI_G(errcode),OCIAttrSet, ((dvoid *) spoolAuth, (ub4) OCI_HTYPE_AUTHINFO, (dvoid *) OCI_G(edition), (ub4)(strlen(OCI_G(edition))), (ub4)OCI_ATTR_EDITION, OCI_G(err)));
    2777             : 
    2778          11 :                 if (OCI_G(errcode) != OCI_SUCCESS) {
    2779           0 :                         php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    2780           0 :                         iserror = 1;
    2781           0 :                         goto exit_create_spool;
    2782             :                 }
    2783             :         } /* }}} */
    2784             : 
    2785             :         /* Set the driver name attribute on the auth handle {{{ */
    2786         530 :         PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIAttrSet, ((dvoid *) spoolAuth, (ub4) OCI_HTYPE_AUTHINFO, (dvoid *) PHP_OCI8_DRIVER_NAME, (ub4) sizeof(PHP_OCI8_DRIVER_NAME)-1, (ub4) OCI_ATTR_DRIVER_NAME, OCI_G(err)));
    2787             : 
    2788         530 :         if (OCI_G(errcode) != OCI_SUCCESS) {
    2789           0 :                 php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    2790           0 :                 iserror = 1;
    2791           0 :                 goto exit_create_spool;
    2792             :         } /* }}} */
    2793             : 
    2794             :         /* Set the auth handle on the session pool {{{ */
    2795         530 :         PHP_OCI_CALL_RETURN(OCI_G(errcode),OCIAttrSet, ((dvoid *) (session_pool->poolh),(ub4) OCI_HTYPE_SPOOL, (dvoid *) spoolAuth, (ub4)0, (ub4)OCI_ATTR_SPOOL_AUTH, OCI_G(err)));
    2796             : 
    2797         530 :         if (OCI_G(errcode) != OCI_SUCCESS) {
    2798           0 :                 php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    2799           0 :                 iserror = 1;
    2800           0 :                 goto exit_create_spool;
    2801             :         } /* }}} */
    2802             : #endif
    2803             : 
    2804             :         /* Create the homogeneous session pool - We have different session pools for every different
    2805             :          * username, password, charset and dbname.
    2806             :          */
    2807         530 :         PHP_OCI_CALL_RETURN(OCI_G(errcode), OCISessionPoolCreate,(session_pool->env, OCI_G(err), session_pool->poolh, (OraText **)&session_pool->poolname, &session_pool->poolname_len, (OraText *)dbname, (ub4)dbname_len, 0, UB4MAXVAL, 1,(OraText *)username, (ub4)username_len, (OraText *)password,(ub4)password_len, poolmode));
    2808             : 
    2809         530 :         if (OCI_G(errcode) != OCI_SUCCESS) {
    2810           0 :                 php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    2811           0 :                 iserror = 1;
    2812             :         }
    2813             : 
    2814             : exit_create_spool:
    2815         530 :         if (iserror && session_pool) {
    2816           0 :                 php_oci_spool_close(session_pool TSRMLS_CC);
    2817           0 :                 session_pool = NULL;
    2818             :         }
    2819             : 
    2820         530 :         if (spoolAuth) {
    2821         530 :                 PHP_OCI_CALL(OCIHandleFree, ((dvoid *) spoolAuth, (ub4) OCI_HTYPE_AUTHINFO));
    2822             :         }
    2823             : 
    2824         530 :         if (OCI_G(debug_mode)) {
    2825           1 :                 php_printf ("OCI8 DEBUG L1: create_spool: (%p) at (%s:%d) \n", session_pool, __FILE__, __LINE__);
    2826             :         }
    2827             : 
    2828         530 :         return session_pool;
    2829             : } /* }}} */
    2830             : 
    2831             : /* {{{ php_oci_get_spool()
    2832             :  *
    2833             :  * Get Session pool for the given dbname and charsetid from the persistent list. Function called for
    2834             :  * non-persistent connections.
    2835             :  */
    2836         534 : static php_oci_spool *php_oci_get_spool(char *username, int username_len, char *password, int password_len, char *dbname, int dbname_len, int charsetid TSRMLS_DC)
    2837             : {
    2838         534 :         smart_str spool_hashed_details = {0};
    2839         534 :         php_oci_spool *session_pool = NULL;
    2840         534 :         zend_rsrc_list_entry spool_le = {0};
    2841         534 :         zend_rsrc_list_entry *spool_out_le = NULL;
    2842         534 :         zend_bool iserror = 0;
    2843             : 
    2844             :         /* Create the spool hash key {{{ */
    2845         534 :         smart_str_appendl_ex(&spool_hashed_details, "oci8spool***", sizeof("oci8spool***") - 1, 0);
    2846         534 :         smart_str_appendl_ex(&spool_hashed_details, username, username_len, 0);
    2847         534 :         smart_str_appendl_ex(&spool_hashed_details, "**", sizeof("**") - 1, 0);
    2848             :         /* Add edition attribute to the hash */
    2849         534 :         if (OCI_G(edition)){
    2850          15 :                 smart_str_appendl_ex(&spool_hashed_details, OCI_G(edition), strlen(OCI_G(edition)), 0);
    2851             :         }
    2852         534 :         smart_str_appendl_ex(&spool_hashed_details, "**", sizeof("**") - 1, 0);
    2853         534 :         if (password_len) {
    2854             :                 ulong password_hash;
    2855         534 :                 password_hash = zend_inline_hash_func(password, password_len);
    2856         534 :                 smart_str_append_unsigned_ex(&spool_hashed_details, password_hash, 0);
    2857             :         }
    2858         534 :         smart_str_appendl_ex(&spool_hashed_details, "**", sizeof("**") - 1, 0);
    2859             : 
    2860         534 :         if (dbname_len) {
    2861         534 :                 smart_str_appendl_ex(&spool_hashed_details, dbname, dbname_len, 0);
    2862             :         }
    2863         534 :         smart_str_appendl_ex(&spool_hashed_details, "**", sizeof("**") - 1, 0);
    2864             : 
    2865         534 :         smart_str_append_unsigned_ex(&spool_hashed_details, charsetid, 0);
    2866             : 
    2867             :         /* Session Pool Hash Key : oci8spool***username**edition**hashedpassword**dbname**charset */
    2868             : 
    2869         534 :         smart_str_0(&spool_hashed_details);
    2870         534 :         php_strtolower(spool_hashed_details.c, spool_hashed_details.len);
    2871             :         /* }}} */
    2872             : 
    2873         534 :         if (zend_hash_find(&EG(persistent_list),spool_hashed_details.c, spool_hashed_details.len+1, (void **)&spool_out_le) == FAILURE) {
    2874             : 
    2875         496 :                 session_pool = php_oci_create_spool(username, username_len, password, password_len, dbname, dbname_len, spool_hashed_details.c, spool_hashed_details.len, charsetid TSRMLS_CC);
    2876             : 
    2877         496 :                 if (session_pool == NULL) {
    2878           0 :                         iserror = 1;
    2879           0 :                         goto exit_get_spool;
    2880             :                 }
    2881         496 :                 spool_le.ptr  = session_pool;
    2882         496 :                 spool_le.type = le_psessionpool;
    2883             : #if (PHP_MAJOR_VERSION == 5 && PHP_MINOR_VERSION > 3) || (PHP_MAJOR_VERSION > 5)
    2884         496 :                 zend_list_insert(session_pool, le_psessionpool TSRMLS_CC);
    2885             : #else
    2886             :                 zend_list_insert(session_pool, le_psessionpool);
    2887             : #endif
    2888         496 :                 zend_hash_update(&EG(persistent_list), session_pool->spool_hash_key, strlen(session_pool->spool_hash_key)+1,(void *)&spool_le, sizeof(zend_rsrc_list_entry),NULL);
    2889         114 :         } else if (spool_out_le->type == le_psessionpool &&
    2890          38 :                 strlen(((php_oci_spool *)(spool_out_le->ptr))->spool_hash_key) == spool_hashed_details.len &&
    2891          38 :                 memcmp(((php_oci_spool *)(spool_out_le->ptr))->spool_hash_key, spool_hashed_details.c, spool_hashed_details.len) == 0) {
    2892             :                 /* retrieve the cached session pool */
    2893          38 :                 session_pool = (php_oci_spool *)(spool_out_le->ptr);
    2894             :         }
    2895             : 
    2896             : exit_get_spool:
    2897         534 :         smart_str_free_ex(&spool_hashed_details, 0);
    2898         534 :         if (iserror && session_pool) {
    2899           0 :                 php_oci_spool_close(session_pool TSRMLS_CC);
    2900           0 :                 session_pool = NULL;
    2901             :         }
    2902             : 
    2903         534 :         return session_pool;
    2904             : 
    2905             : } /* }}} */
    2906             : 
    2907             : /* {{{ php_oci_create_env()
    2908             :  *
    2909             :  * Create the OCI environment choosing the correct function for the OCI version
    2910             :  */
    2911         555 : static OCIEnv *php_oci_create_env(ub2 charsetid TSRMLS_DC)
    2912             : {
    2913         555 :         OCIEnv *retenv = NULL;
    2914             : 
    2915             :         /* create an environment using the character set id */
    2916         555 :         PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIEnvNlsCreate, (&retenv, OCI_G(events) ? PHP_OCI_INIT_MODE | OCI_EVENTS : PHP_OCI_INIT_MODE, 0, NULL, NULL, NULL, 0, NULL, charsetid, charsetid));
    2917             : 
    2918         555 :         if (OCI_G(errcode) != OCI_SUCCESS) {
    2919           0 :                 sb4   ora_error_code = 0;
    2920             :                 text  ora_msg_buf[OCI_ERROR_MAXMSG_SIZE];  /* Use traditional smaller size: non-PL/SQL errors should fit and it keeps the stack smaller */
    2921             : 
    2922             : #ifdef HAVE_OCI_INSTANT_CLIENT
    2923             :                 php_error_docref(NULL TSRMLS_CC, E_WARNING, "OCIEnvNlsCreate() failed. There is something wrong with your system - please check that " PHP_OCI8_LIB_PATH_MSG " includes the directory with Oracle Instant Client libraries");
    2924             : #else
    2925           0 :                 php_error_docref(NULL TSRMLS_CC, E_WARNING, "OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORACLE_HOME and " PHP_OCI8_LIB_PATH_MSG " are set and point to the right directories");
    2926             : #endif
    2927           0 :                 if (retenv
    2928           0 :                         && OCIErrorGet(retenv, (ub4)1, NULL, &ora_error_code, ora_msg_buf, (ub4)OCI_ERROR_MAXMSG_SIZE, (ub4)OCI_HTYPE_ENV) == OCI_SUCCESS
    2929           0 :                         && *ora_msg_buf) {
    2930           0 :                         php_error_docref(NULL TSRMLS_CC, E_WARNING, "%s", ora_msg_buf);
    2931             :                 }
    2932             :                 
    2933           0 :                 return NULL;
    2934             :         }
    2935         555 :         return retenv;
    2936             : }/* }}} */
    2937             : 
    2938             : /* {{{ php_oci_old_create_session()
    2939             :  *
    2940             :  * This function is to be deprecated in future in favour of OCISessionGet which is used in
    2941             :  * php_oci_do_connect_ex
    2942             :  */
    2943          25 : static int php_oci_old_create_session(php_oci_connection *connection, char *dbname, int dbname_len, char *username, int username_len, char *password, int password_len, char *new_password, int new_password_len, int session_mode TSRMLS_DC)
    2944             : {
    2945          25 :         ub4 statement_cache_size = (OCI_G(statement_cache_size) > 0) ? OCI_G(statement_cache_size) : 0;
    2946             : 
    2947          25 :         if (OCI_G(debug_mode)) {
    2948           0 :                 php_printf ("OCI8 DEBUG: Bypassing client-side session pool for session create at (%s:%d) \n", __FILE__, __LINE__);
    2949             :         }
    2950             : 
    2951             :         /* Create the OCI environment separate for each connection */
    2952          25 :         if (!(connection->env = php_oci_create_env(connection->charset TSRMLS_CC))) {
    2953           0 :                 return 1;
    2954             :         }
    2955             : 
    2956             :         /* Allocate our server handle {{{ */
    2957          25 :         PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIHandleAlloc, (connection->env, (dvoid **)&(connection->server), OCI_HTYPE_SERVER, 0, NULL));
    2958             : 
    2959          25 :         if (OCI_G(errcode) != OCI_SUCCESS) {
    2960           0 :                 php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    2961           0 :                 return 1;
    2962             :         } /* }}} */
    2963             : 
    2964             :         /* Attach to the server {{{ */
    2965          25 :         PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIServerAttach, (connection->server, OCI_G(err), (text *)dbname, dbname_len, (ub4) OCI_DEFAULT));
    2966             : 
    2967          25 :         if (OCI_G(errcode) != OCI_SUCCESS) {
    2968          14 :                 php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    2969          14 :                 return 1;
    2970             :         } /* }}} */
    2971          11 :         connection->is_attached = 1;
    2972             : 
    2973             :         /* Allocate our session handle {{{ */
    2974          11 :         PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIHandleAlloc, (connection->env, (dvoid **)&(connection->session), OCI_HTYPE_SESSION, 0, NULL));
    2975             : 
    2976          11 :         if (OCI_G(errcode) != OCI_SUCCESS) {
    2977           0 :                 php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    2978           0 :                 return 1;
    2979             :         } /* }}} */
    2980             : 
    2981             :         /* Allocate our private error-handle {{{ */
    2982          11 :         PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIHandleAlloc, (connection->env, (dvoid **)&(connection->err), OCI_HTYPE_ERROR, 0, NULL));
    2983             : 
    2984          11 :         if (OCI_G(errcode) != OCI_SUCCESS) {
    2985           0 :                 php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    2986           0 :                 return 1;
    2987             :         } /* }}} */
    2988             : 
    2989             :         /* Allocate our service-context {{{ */
    2990          11 :         PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIHandleAlloc, (connection->env, (dvoid **)&(connection->svc), OCI_HTYPE_SVCCTX, 0, NULL));
    2991             : 
    2992          11 :         if (OCI_G(errcode) != OCI_SUCCESS) {
    2993           0 :                 php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    2994           0 :                 return 1;
    2995             :         } /* }}} */
    2996             : 
    2997             :         /* Set the username {{{ */
    2998          11 :         if (username) {
    2999          11 :                 PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIAttrSet, ((dvoid *) connection->session, (ub4) OCI_HTYPE_SESSION, (dvoid *) username, (ub4) username_len, (ub4) OCI_ATTR_USERNAME, OCI_G(err)));
    3000             : 
    3001          11 :                 if (OCI_G(errcode) != OCI_SUCCESS) {
    3002           0 :                         php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    3003           0 :                         return 1;
    3004             :                 }
    3005             :         }/* }}} */
    3006             : 
    3007             :         /* Set the password {{{ */
    3008          11 :         if (password) {
    3009          11 :                 PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIAttrSet, ((dvoid *) connection->session, (ub4) OCI_HTYPE_SESSION, (dvoid *) password, (ub4) password_len, (ub4) OCI_ATTR_PASSWORD, OCI_G(err)));
    3010             : 
    3011          11 :                 if (OCI_G(errcode) != OCI_SUCCESS) {
    3012           0 :                         php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    3013           0 :                         return 1;
    3014             :                 }
    3015             :         }/* }}} */
    3016             : 
    3017             :         /* Set the edition attribute on the session handle {{{ */
    3018             : #if ((OCI_MAJOR_VERSION > 11) || ((OCI_MAJOR_VERSION == 11) && (OCI_MINOR_VERSION >= 2)))
    3019          11 :         if (OCI_G(edition)) {
    3020           0 :                 PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIAttrSet, ((dvoid *) connection->session, (ub4) OCI_HTYPE_SESSION, (dvoid *) OCI_G(edition), (ub4) (strlen(OCI_G(edition))), (ub4) OCI_ATTR_EDITION, OCI_G(err)));
    3021             : 
    3022           0 :                 if (OCI_G(errcode) != OCI_SUCCESS) {
    3023           0 :                         php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    3024           0 :                         return 1;
    3025             :                 }
    3026             :         }
    3027             : #endif /* }}} */
    3028             : 
    3029             :         /* Set the driver name attribute on the session handle {{{ */
    3030             : #if (OCI_MAJOR_VERSION >= 11)
    3031          11 :         PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIAttrSet, ((dvoid *) connection->session, (ub4) OCI_HTYPE_SESSION, (dvoid *) PHP_OCI8_DRIVER_NAME, (ub4) sizeof(PHP_OCI8_DRIVER_NAME)-1, (ub4) OCI_ATTR_DRIVER_NAME, OCI_G(err)));
    3032             : 
    3033          11 :         if (OCI_G(errcode) != OCI_SUCCESS) {
    3034           0 :                 php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    3035           0 :                 return 1;
    3036             :         }
    3037             : #endif /* }}} */
    3038             : 
    3039             :         /* Set the server handle in the service handle {{{ */
    3040          11 :         PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIAttrSet, (connection->svc, OCI_HTYPE_SVCCTX, connection->server, 0, OCI_ATTR_SERVER, OCI_G(err)));
    3041             : 
    3042          11 :         if (OCI_G(errcode) != OCI_SUCCESS) {
    3043           0 :                 php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    3044           0 :                 return 1;
    3045             :         } /* }}} */
    3046             : 
    3047             :         /* Set the authentication handle in the service handle {{{ */
    3048          11 :         PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIAttrSet, (connection->svc, OCI_HTYPE_SVCCTX, connection->session, 0, OCI_ATTR_SESSION, OCI_G(err)));
    3049             : 
    3050          11 :         if (OCI_G(errcode) != OCI_SUCCESS) {
    3051           0 :                 php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    3052           0 :                 return 1;
    3053             :         } /* }}} */
    3054             : 
    3055          11 :         if (new_password) {
    3056             :                 /* Try to change password if new one was provided {{{ */
    3057           4 :                 PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIPasswordChange, (connection->svc, OCI_G(err), (text *)username, username_len, (text *)password, password_len, (text *)new_password, new_password_len, OCI_AUTH));
    3058             : 
    3059           4 :                 if (OCI_G(errcode) != OCI_SUCCESS) {
    3060           0 :                         php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    3061           0 :                         return 1;
    3062             :                 }
    3063             : 
    3064           4 :                 PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIAttrGet, ((dvoid *)connection->svc, OCI_HTYPE_SVCCTX, (dvoid *)&(connection->session), (ub4 *)0, OCI_ATTR_SESSION, OCI_G(err)));
    3065             : 
    3066           4 :                 if (OCI_G(errcode) != OCI_SUCCESS) {
    3067           0 :                         php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    3068           0 :                         return 1;
    3069             :                 } /* }}} */
    3070             :         } else {
    3071             :                 /* start the session {{{ */
    3072           7 :                 ub4 cred_type = OCI_CRED_RDBMS;
    3073             : 
    3074             :                 /* Extract the overloaded session_mode parameter into valid Oracle credential and session mode values */
    3075           7 :                 if (session_mode & PHP_OCI_CRED_EXT) {
    3076           0 :                         cred_type = OCI_CRED_EXT;
    3077           0 :                         session_mode ^= PHP_OCI_CRED_EXT;
    3078             :                 }
    3079             : 
    3080           7 :                 session_mode |= OCI_STMT_CACHE;
    3081             : 
    3082           7 :                 PHP_OCI_CALL_RETURN(OCI_G(errcode), OCISessionBegin, (connection->svc, OCI_G(err), connection->session, (ub4) cred_type, (ub4) session_mode));
    3083             : 
    3084           7 :                 if (OCI_G(errcode) != OCI_SUCCESS) {
    3085           7 :                         php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    3086             :                         /* OCISessionBegin returns OCI_SUCCESS_WITH_INFO when
    3087             :                          * user's password has expired, but is still usable.
    3088             :                          */
    3089           7 :                         if (OCI_G(errcode) != OCI_SUCCESS_WITH_INFO) {
    3090           7 :                                 return 1;
    3091             :                         }
    3092             :                 } /* }}} */
    3093             :         }
    3094             : 
    3095             :         /* Brand new connection: Init and update the next_ping in the connection */
    3096           4 :         if (php_oci_ping_init(connection, OCI_G(err) TSRMLS_CC) != OCI_SUCCESS) {
    3097           0 :                 php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    3098           0 :                 return 1;
    3099             :         }
    3100             : 
    3101           4 :         PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIAttrSet, ((dvoid *) connection->svc, (ub4) OCI_HTYPE_SVCCTX, (ub4 *) &statement_cache_size, 0, (ub4) OCI_ATTR_STMTCACHESIZE, OCI_G(err)));
    3102             : 
    3103           4 :         if (OCI_G(errcode) != OCI_SUCCESS) {
    3104           0 :                 php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    3105           0 :                 return 1;
    3106             :         }
    3107             : 
    3108             :         /* Successfully created session */
    3109           4 :         return 0;
    3110             : } /* }}} */
    3111             : 
    3112             : /* {{{ php_oci_create_session()
    3113             :  *
    3114             :  * Create session using client-side session pool - new norm
    3115             :  */
    3116         576 : static int php_oci_create_session(php_oci_connection *connection, php_oci_spool *session_pool, char *dbname, int dbname_len, char *username, int username_len, char *password, int password_len, char *new_password, int new_password_len, int session_mode TSRMLS_DC)
    3117             : {
    3118         576 :         php_oci_spool *actual_spool = NULL;
    3119             : #if (OCI_MAJOR_VERSION > 10)
    3120         576 :         ub4 purity = -2;                                /* Illegal value to initialize */
    3121             : #endif
    3122         576 :         time_t timestamp = time(NULL);
    3123         576 :         ub4 statement_cache_size = (OCI_G(statement_cache_size) > 0) ? OCI_G(statement_cache_size) : 0;
    3124             : 
    3125             :         /* Persistent connections have private session pools */
    3126         644 :         if (connection->is_persistent && !connection->private_spool &&
    3127          68 :                 !(connection->private_spool = php_oci_create_spool(username, username_len, password, password_len, dbname, dbname_len, NULL, 0, connection->charset TSRMLS_CC))) {
    3128           0 :                         return 1;
    3129             :         }
    3130         576 :         actual_spool = (connection->is_persistent) ? (connection->private_spool) : (session_pool);
    3131             : 
    3132         576 :         connection->env = actual_spool->env;
    3133             : 
    3134             :         /* Do this upfront so that connection close on an error would know that this is a session pool
    3135             :          * connection. Failure to do this would result in crashes in error scenarios
    3136             :          */
    3137         576 :         if (!connection->using_spool) {
    3138         568 :                 connection->using_spool = 1;
    3139             :         }
    3140             : 
    3141         576 :         if (OCI_G(debug_mode)) {
    3142           1 :                 if (session_pool) {
    3143           1 :                         php_printf ("OCI8 DEBUG L1: using shared pool: (%p) at (%s:%d) \n", session_pool, __FILE__, __LINE__);
    3144             :                 } else {
    3145           0 :                         php_printf ("OCI8 DEBUG L1: using private pool: (%p) at (%s:%d) \n", connection->private_spool, __FILE__, __LINE__);
    3146             :                 }
    3147             :         }
    3148             : 
    3149             :         /* The passed in "connection" can be a cached stub from plist or freshly created. In the former
    3150             :          * case, we do not have to allocate any handles
    3151             :          */
    3152             : 
    3153         576 :         if (!connection->err) {
    3154         568 :                 PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIHandleAlloc, (connection->env, (dvoid **)&(connection->err), OCI_HTYPE_ERROR, 0, NULL));
    3155             : 
    3156         568 :                 if (OCI_G(errcode) != OCI_SUCCESS) {
    3157           0 :                         php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    3158           0 :                         return 1;
    3159             :                 }
    3160             :         }
    3161             : 
    3162             :         /* {{{ Allocate and initialize the connection-private authinfo handle if not allocated yet */
    3163         576 :         if (!connection->authinfo) {
    3164         568 :                 PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIHandleAlloc, (connection->env, (dvoid **)&(connection->authinfo), OCI_HTYPE_AUTHINFO, 0, NULL));
    3165             : 
    3166         568 :                 if (OCI_G(errcode) != OCI_SUCCESS) {
    3167           0 :                         php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    3168           0 :                         return 1;
    3169             :                 }
    3170             : 
    3171             :                 /* Set the Connection class and purity if OCI client version >= 11g */
    3172             : #if (OCI_MAJOR_VERSION > 10)
    3173         568 :                 PHP_OCI_CALL_RETURN(OCI_G(errcode),OCIAttrSet, ((dvoid *) connection->authinfo,(ub4) OCI_HTYPE_SESSION, (dvoid *) OCI_G(connection_class), (ub4)(strlen(OCI_G(connection_class))), (ub4)OCI_ATTR_CONNECTION_CLASS, OCI_G(err)));
    3174             : 
    3175         568 :                 if (OCI_G(errcode) != OCI_SUCCESS) {
    3176           0 :                         php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    3177           0 :                         return 1;
    3178             :                 }
    3179             : 
    3180         568 :                 if (connection->is_persistent)
    3181          34 :                         purity = OCI_ATTR_PURITY_SELF;
    3182             :                 else
    3183         534 :                         purity = OCI_ATTR_PURITY_NEW;
    3184             : 
    3185         568 :                 PHP_OCI_CALL_RETURN(OCI_G(errcode),OCIAttrSet, ((dvoid *) connection->authinfo,(ub4) OCI_HTYPE_AUTHINFO, (dvoid *) &purity, (ub4)0, (ub4)OCI_ATTR_PURITY, OCI_G(err)));
    3186             : 
    3187         568 :                 if (OCI_G(errcode) != OCI_SUCCESS) {
    3188           0 :                         php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    3189           0 :                         return 1;
    3190             :                 }
    3191             : #endif
    3192             :         } /* }}} */
    3193             : 
    3194             :         /* Debug statements {{{ */
    3195         576 :         if (OCI_G(debug_mode)) {
    3196           1 :                 ub4 numfree = 0, numbusy = 0, numopen = 0;
    3197           1 :                 PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIAttrGet, ((dvoid *)actual_spool->poolh, OCI_HTYPE_SPOOL, (dvoid *)&numopen, (ub4 *)0, OCI_ATTR_SPOOL_OPEN_COUNT, OCI_G(err)));
    3198           1 :                 PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIAttrGet, ((dvoid *)actual_spool->poolh, OCI_HTYPE_SPOOL, (dvoid *)&numbusy, (ub4 *)0, OCI_ATTR_SPOOL_BUSY_COUNT, OCI_G(err)));
    3199           1 :                 numfree = numopen - numbusy;    /* number of free connections in the pool */
    3200           1 :                 php_printf ("OCI8 DEBUG L1: (numopen=%d)(numbusy=%d)(numfree=%d) at (%s:%d) \n", numopen, numbusy, numfree, __FILE__, __LINE__);
    3201             :         } /* }}} */
    3202             : 
    3203             :                 /* Ping loop: Ping and loop till we get a good connection. When a database instance goes
    3204             :                  * down, it can leave several bad connections that need to be flushed out before getting a
    3205             :                  * good one. In non-RAC, we always get a brand new connection at the end of the loop and in
    3206             :                  * RAC, we can get a good connection from a different instance before flushing out all bad
    3207             :                  * ones. We do not need to ping brand new connections.
    3208             :                  */
    3209             :         do {
    3210             :                 /* Continue to use the global error handle as the connection is closed when an error occurs */
    3211         576 :                 PHP_OCI_CALL_RETURN(OCI_G(errcode),OCISessionGet, (connection->env, OCI_G(err), &(connection->svc), (OCIAuthInfo *)connection->authinfo, (OraText *)actual_spool->poolname, (ub4)actual_spool->poolname_len, NULL, 0, NULL, NULL, NULL, OCI_SESSGET_SPOOL));
    3212             : 
    3213         576 :                 if (OCI_G(errcode) != OCI_SUCCESS) {
    3214           5 :                         php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    3215             : 
    3216             :                         /* Session creation returns OCI_SUCCESS_WITH_INFO when user's password has expired, but
    3217             :                          * is still usable.
    3218             :                          */
    3219             : 
    3220           5 :                         if (OCI_G(errcode) != OCI_SUCCESS_WITH_INFO) {
    3221           5 :                                 return 1;
    3222             :                         }
    3223             :                 }
    3224             : 
    3225             :                 /* {{{ Populate the session and server fields of the connection */
    3226         571 :                 PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIAttrGet, ((dvoid *)connection->svc, OCI_HTYPE_SVCCTX, (dvoid *)&(connection->server), (ub4 *)0, OCI_ATTR_SERVER, OCI_G(err)));
    3227             : 
    3228         571 :                 PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIAttrGet, ((dvoid *)connection->svc, OCI_HTYPE_SVCCTX, (dvoid *)&(connection->session), (ub4 *)0, OCI_ATTR_SESSION, OCI_G(err))); /* }}} */
    3229             : 
    3230         571 :                 PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIContextGetValue, (connection->session, OCI_G(err), (ub1 *)"NEXT_PING", (ub1)sizeof("NEXT_PING"), (void **)&(connection->next_pingp)));
    3231         571 :                 if (OCI_G(errcode) != OCI_SUCCESS) {
    3232           0 :                         php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    3233           0 :                         return 1;
    3234             :                 }
    3235             : 
    3236         571 :                 if (!(connection->next_pingp)){
    3237             :                         /* This is a brand new connection, we need not ping, but have to initialize ping */
    3238         563 :                         if (php_oci_ping_init(connection, OCI_G(err) TSRMLS_CC) != OCI_SUCCESS) {
    3239           0 :                                 php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    3240           0 :                                 return 1;
    3241             :                         }
    3242           8 :                 } else if ((*(connection->next_pingp) > 0) && (timestamp >= *(connection->next_pingp))) {
    3243           0 :                         if (php_oci_connection_ping(connection TSRMLS_CC)) {
    3244             :                                 /* Got a good connection - update next_ping and get out of ping loop */
    3245           0 :                                 *(connection->next_pingp) = timestamp + OCI_G(ping_interval);
    3246             :                         } else {
    3247             :                                 /* Bad connection - remove from pool */
    3248           0 :                                 PHP_OCI_CALL(OCISessionRelease, (connection->svc, connection->err, NULL,0, (ub4) OCI_SESSRLS_DROPSESS));
    3249           0 :                                 connection->svc = NULL;
    3250           0 :                                 connection->server = NULL;
    3251           0 :                                 connection->session = NULL;
    3252             :                         }
    3253             :                 }       /* If ping applicable */
    3254         571 :         } while (!(connection->svc));
    3255             : 
    3256         571 :         PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIAttrSet, ((dvoid *) connection->svc, (ub4) OCI_HTYPE_SVCCTX, (ub4 *) &statement_cache_size, 0, (ub4) OCI_ATTR_STMTCACHESIZE, OCI_G(err)));
    3257             : 
    3258         571 :         if (OCI_G(errcode) != OCI_SUCCESS) {
    3259           0 :                 php_oci_error(OCI_G(err), OCI_G(errcode) TSRMLS_CC);
    3260           0 :                 return 1;
    3261             :         }
    3262             : 
    3263             :         /* Session is now taken from the session pool and attached and open */
    3264         571 :         connection->is_stub = 0;
    3265         571 :         connection->is_attached = connection->is_open = 1;
    3266             : 
    3267         571 :         return 0;
    3268             : } /* }}} */
    3269             : 
    3270             : /* {{{ php_oci_spool_list_dtor()
    3271             :  *
    3272             :  * Session pool destructor function
    3273             :  */
    3274         496 : static void php_oci_spool_list_dtor(zend_rsrc_list_entry *entry TSRMLS_DC)
    3275             : {
    3276         496 :         php_oci_spool *session_pool = (php_oci_spool *)entry->ptr;
    3277             : 
    3278         496 :         if (session_pool) {
    3279         496 :                 php_oci_spool_close(session_pool TSRMLS_CC);
    3280             :         }
    3281             : 
    3282         496 :         return;
    3283             : } /* }}} */
    3284             : 
    3285             : /* {{{  php_oci_spool_close()
    3286             :  *
    3287             :  * Destroys the OCI Session Pool
    3288             :  */
    3289         530 : static void php_oci_spool_close(php_oci_spool *session_pool TSRMLS_DC)
    3290             : {
    3291         530 :         if (session_pool->poolname_len) {
    3292         530 :                 PHP_OCI_CALL(OCISessionPoolDestroy, ((dvoid *) session_pool->poolh,
    3293             :                         (dvoid *) session_pool->err, OCI_SPD_FORCE));
    3294             :         }
    3295             : 
    3296         530 :         if (session_pool->poolh) {
    3297         530 :                 PHP_OCI_CALL(OCIHandleFree, ((dvoid *) session_pool->poolh, OCI_HTYPE_SPOOL));
    3298             :         }
    3299             : 
    3300         530 :         if (session_pool->err) {
    3301         530 :                 PHP_OCI_CALL(OCIHandleFree, ((dvoid *) session_pool->err, OCI_HTYPE_ERROR));
    3302             :         }
    3303             : 
    3304         530 :         if (session_pool->env) {
    3305         530 :                 PHP_OCI_CALL(OCIHandleFree, ((dvoid *) session_pool->env, OCI_HTYPE_ENV));
    3306             :         }
    3307             : 
    3308         530 :         if (session_pool->spool_hash_key) {
    3309         496 :                 free(session_pool->spool_hash_key);
    3310             :         }
    3311             : 
    3312         530 :         free(session_pool);
    3313         530 : } /* }}} */
    3314             : 
    3315             : /* {{{ php_oci_ping_init()
    3316             :  *
    3317             :  * Initializes the next_ping time as a context value in the connection.  We now use
    3318             :  * OCIContext{Get,Set}Value to store the next_ping because we need to support ping for
    3319             :  * non-persistent DRCP connections
    3320             :  */
    3321         567 : static sword php_oci_ping_init(php_oci_connection *connection, OCIError *errh TSRMLS_DC)
    3322             : {
    3323         567 :         time_t *next_pingp = NULL;
    3324             : 
    3325         567 :         PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIContextGetValue, (connection->session, errh, (ub1 *)"NEXT_PING", (ub1)sizeof("NEXT_PING"), (void **)&next_pingp));
    3326         567 :         if (OCI_G(errcode) != OCI_SUCCESS) {
    3327           0 :                 return OCI_G(errcode);
    3328             :         }
    3329             : 
    3330             :         /* This must be a brand-new connection. Allocate memory for the ping */
    3331         567 :         if (!next_pingp) {
    3332         567 :                 PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIMemoryAlloc, (connection->session, errh, (void **)&next_pingp, OCI_DURATION_SESSION, sizeof(time_t), OCI_MEMORY_CLEARED));
    3333         567 :                 if (OCI_G(errcode) != OCI_SUCCESS) {
    3334           0 :                         return OCI_G(errcode);
    3335             :                 }
    3336             :         }
    3337             : 
    3338         567 :         if (OCI_G(ping_interval) >= 0) {
    3339         567 :                 time_t timestamp = time(NULL);
    3340         567 :                 *next_pingp = timestamp + OCI_G(ping_interval);
    3341             :         } else {
    3342           0 :                 *next_pingp = 0;
    3343             :         }
    3344             : 
    3345             :         /* Set the new ping value into the connection */
    3346         567 :         PHP_OCI_CALL_RETURN(OCI_G(errcode), OCIContextSetValue, (connection->session, errh, OCI_DURATION_SESSION, (ub1 *)"NEXT_PING", (ub1)sizeof("NEXT_PING"), next_pingp));
    3347         567 :         if (OCI_G(errcode) != OCI_SUCCESS) {
    3348           0 :                 OCIMemoryFree(connection->session, errh, next_pingp);
    3349           0 :                 return OCI_G(errcode);
    3350             :         }
    3351             : 
    3352             :         /* Cache the pointer so we do not have to do OCIContextGetValue repeatedly */
    3353         567 :         connection->next_pingp = next_pingp;
    3354             : 
    3355         567 :         return OCI_SUCCESS;
    3356             : } /* }}} */
    3357             : 
    3358             : #endif /* HAVE_OCI8 */
    3359             : 
    3360             : /*
    3361             :  * Local variables:
    3362             :  * tab-width: 4
    3363             :  * c-basic-offset: 4
    3364             :  * End:
    3365             :  * vim600: noet sw=4 ts=4 fdm=marker
    3366             :  * vim<600: noet sw=4 ts=4
    3367             :  */

Generated by: LCOV version 1.10

Generated at Fri, 24 Oct 2014 05:21:50 +0000 (25 hours ago)

Copyright © 2005-2014 The PHP Group
All rights reserved.