oci_pconnect

Connect to an Oracle database using a persistent connection (PHP 5, PECL oci8:1.1-1.2.4)
resource oci_pconnect ( string username, string password [, string db [, string charset [, int session_mode]]] )

Examples ( Source code ) » oci_pconnect


<?php

    function getOracleConnection()

    {

      if (!function_exists('oci_pconnect'))

        return false;

      $toReturn = oci_pconnect('user', 'pass', 'db');

      if ($testRes = @oci_parse($toReturn, 'SELECT Count(group_type_code) FROM pvo.group_type'))

        if (@oci_execute($testRes))

          if (@oci_fetch_array($testRes))

            return $toReturn;

      oci_close($toReturn);

      if (!function_exists('oci_connect'))

        return false;

      $toReturn = oci_connect('user', 'pass', 'db');

      if ($testRes = @oci_parse($toReturn, 'SELECT Count(group_type_code) FROM pvo.group_type'))

        if (@oci_execute($testRes))

          if (@oci_fetch_array($testRes))

            return $toReturn;

      oci_close($toReturn);

      if (!function_exists('oci_new_connect'))

        return false;

      $toReturn = oci_new_connect('user', 'pass', 'db');

      if ($testRes = @oci_parse($toReturn, 'SELECT Count(group_type_code) FROM pvo.group_type'))

        if (@oci_execute($testRes))

          if (@oci_fetch_array($testRes))

            return $toReturn;

      oci_close($toReturn);

      return false;

    }

?>

Related Examples ( Source code ) » oci_pconnect

Code Examples / Notes » oci_pconnect

If you connect using oci_pconnect and the connection has logged you off but is still valid, there seems to be no way to re-use that connection. The next time I try oci_pconnect and then perform an oci_execute operation, I get a "ORA-01012: not logged on" warning. This problem remains, even if I close the connection using oci_close. I ended up with the following (rather annoying) code. <?php function getOracleConnection() { if (!function_exists('oci_pconnect')) return false; $toReturn = oci_pconnect('user', 'pass', 'db'); if ($testRes = @oci_parse($toReturn, 'SELECT Count(group_type_code) FROM pvo.group_type')) if (@oci_execute($testRes)) if (@oci_fetch_array($testRes)) return $toReturn; oci_close($toReturn); if (!function_exists('oci_connect')) return false; $toReturn = oci_connect('user', 'pass', 'db'); if ($testRes = @oci_parse($toReturn, 'SELECT Count(group_type_code) FROM pvo.group_type')) if (@oci_execute($testRes)) if (@oci_fetch_array($testRes)) return $toReturn; oci_close($toReturn); if (!function_exists('oci_new_connect')) return false; $toReturn = oci_new_connect('user', 'pass', 'db'); if ($testRes = @oci_parse($toReturn, 'SELECT Count(group_type_code) FROM pvo.group_type')) if (@oci_execute($testRes)) if (@oci_fetch_array($testRes)) return $toReturn; oci_close($toReturn); return false; } ?>

oci_pconnect

Connect to an Oracle database using a persistent connection (PHP 5, PECL oci8:1.1-1.2.4) resource oci_pconnect ( string username, string password [, string db [, string charset [, int session_mode]]] )

Related Examples ( Source code ) » oci_pconnect

Code Examples / Notes » oci_pconnect

Change Language

Connect to an Oracle database using a persistent connection (PHP 5, PECL oci8:1.1-1.2.4)
resource oci_pconnect ( string username, string password [, string db [, string charset [, int session_mode]]] )