PHP Handbuch
Zurück |  | Weiter

# oci_pconnect

(PHP 5)

oci_pconnect -- Connect to an Oracle database using a persistent connection

## Description

resource oci_pconnect ( string username, string password [, string db [, string charset [, int session_mode]]] )

oci_pconnect() creates a persistent connection to an Oracle server and logs on. Persistent connections are cached and re-used between requests, resulting in reduced overhead on each page load; a typical PHP application will have a single persistent connection open against an Oracle server per Apache child process (or PHP FastCGI/CGI process). See the Persistent Database Connections section for more information.

> Anmerkung: Starting with version 1.1 of the oci8 extension, the lifetime and maximum amount of persistent Oracle connections can be tuned by setting the following configuration values: oci8.persistent_timeout, oci8.ping_interval and oci8.max_persistent.

The optional third parameter can either contain the name of the local Oracle instance or the name of the entry in `tnsnames.ora`. If the third parameter is not specified, PHP uses environment variables ORACLE_SID and TWO_TASK to determine the name of local Oracle instance and location of `tnsnames.ora` accordingly.

Parameter session_mode is available since version 1.1 and accepts the following values: `OCI_DEFAULT`, `OCI_SYSOPER` and `OCI_SYSDBA`. If either `OCI_SYSOPER` or `OCI_SYSDBA` were specified, oci_connect() will try to establish privileged connection using external credentials. Privileged connections are disabled by default. To enable them you need to set oci8.privileged_connect to On.

> Anmerkung: If you're using PHP with Oracle Instant Client, you can use easy connect naming method described here: http://download-west.oracle.com/docs/cd/B12037_01/network.101/b10775/naming.htm#i498306. Basically this means you can specify "//db_host[:port]/database_name" as database name. But if you want to use the old way of naming you must set either `ORACLE_HOME` or `TNS_ADMIN`.

Wenn Sie den Oracle Server in der Version 9.2 oder höher benutzen, können Sie den Zeichensatz, der für eine neue Verbindung genutzt werden soll, mit dem charset Parameter angeben. Verwenden Sie Oracle in einer Version < 9.2 wird dieser Parameter ignoriert und stattdessen die Umgebungsvariable NLS_LANG benutzt.

oci_pconnect() returns connection identifier or `FALSE` on error.

> Anmerkung: In PHP versions before 5.0.0 you must use ociplogon() instead. This name still can be used, it was left as alias of oci_pconnect() for downwards compatability. This, however, is deprecated and not recommended.

See also oci_connect() and oci_new_connect().

Zurück | Zum Anfang | Weiter
oci_password_change | Nach oben | oci_result