- skip to content

# Database Abstraction Layer

### User Tools

- Login

### Site Tools

- Recent changes
- Media Manager
- Sitemap

### Sidebar

##### Resources

- Reference Manual
- User Guide
- The Data Dictionary
- ADOdb-xmlschema
- ADOdb Active Record
- Performance Monitoring
- Date/Time Library
- Session Management Library
- Unsupported Addons
- Coding Standards

##### Supported Databases

- Access
- ADO
- CSV
- Firebird
- Frontbase
- IBM DB2
- Informix
- Interbase
- LDAP
- Microsoft SQL Server
- MySQL
- Netezza
- ODBC
- ODBTP
- Oracle
- PDO
- Postgresql
- SAP ADS
- SAP ASE
- SAP Maxdb
- SAP Sqlanywhere
- Sqlite
- Sybase
- Plain Text
- Visual Foxpro

##### Other

- Feature Comparison Matrix
- Connection Matrix
- Include File Guide

v5:database:oracle

# Oracle

For more information on using advanced functionality in the Oracle driver, read the Advanced Oracle Tutorial

# oci8

##### Specification

Driver Name | oci8
Data Provider | oracle
Status | Active1)
Windows | Yes
Unix | Yes
ADOdb V5 | Yes
ADOdb V6 | Yes

##### Alternatives

Alternative Drivers
PDO driver for Oracle
ADO driver for Oracle

This is the preferred driver for connecting to Oracle databases Despite its name, this driver supports Oracle databases up to and including Oracle 11.

## Driver Specific Methods

Non portable methods are not declared in the base class. Use of these methods in portable code will cause a fatal error when used with other drivers.

The following non-portable methods are available to this driver

Method | Description
--- | ---
bind() | A fast way of updating records
executeCursor() | Returns a cursor to procedure as a handle

[oracle, unix, windows, active]

### Connection Examples

a. PHP and Oracle reside on the same machine, use default SID, with non-persistent connections:

    $conn = NewADOConnection('oci8');
    $conn->connect(false, 'scott', 'tiger');

b. TNS Name defined in tnsnames.ora (or ONAMES or HOSTNAMES), eg. 'myTNS':

    $conn = NewADOConnection('oci8');
    $conn->connect(false, 'scott', 'tiger', 'myTNS');

or

    $conn->connect('myTNS', 'scott', 'tiger');

c. Host Address and SID

    $conn->connectSID = true;
    $conn->connect('192.168.0.1', 'scott', 'tiger', 'SID');

d. Host Address and Service Name

    $conn->connect('192.168.0.1', 'scott', 'tiger', 'servicename');

e. Oracle connection string:

    $cstr = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
                                   (HOST=$host)
                                   (PORT=$port)
                          )
                          (CONNECT_DATA=(SID=$sid)
                          )
             )";
    $conn->connect($cstr, 'scott', 'tiger');

f. ADOdb data source names (dsn):

    $dsn = 'oci8://user:pwd@tnsname/?persist';  # persist is optional
    $conn = ADONewConnection($dsn);  # no need for Connect/PConnect

    $dsn = 'oci8://user:pwd@host/sid';
    $conn = ADONewConnection($dsn);

    $dsn = 'oci8://user:pwd@/';   # oracle on local machine
    $conn = ADONewConnection($dsn);

With ADOdb data source names, there is no need to call `connect()` or `pConnect()` as this is done automatically.

### Date Format

By default, after connection the following SQL is issued:

    "ALTER SESSION SET NLS_DATE_FORMAT='".$this->NLS_DATE_FORMAT."'"

The default value for `NLS_DATE_FORMAT` is `YYYY-MM-DD`. To include time as well, use `RRRR-MM-DD HH24:MI:SS` or set the value to empty to disable this action.

# oci8po

##### Specification

Driver Name | oci8po
Data Provider | oracle
Status | Active2)
Windows | Yes
Unix | Yes
ADOdb V5 | Yes
ADOdb V6 | Yes

This driver extends the oci8 driver and provides compatibility with other database drivers such as MySQL and SQL Server. Use this version of the driver if you are writing portable code.

[oracle, unix, windows, active, portable]

# oci805

##### Specification

Driver Name | oci805
Data Provider | oracle
Status | Inactive3)
Windows | Yes
Unix | Yes
ADOdb V5 | Yes
ADOdb V6 | Yes

This driver provides an undocumented enhancement to the oci8 driver

[oracle, unix, windows, deprecated]

# oci8quercus

##### Specification

Driver Name | oci805cus
Data Provider | oracle
Status | Inactive4)
Windows | Yes
Unix | Yes
ADOdb V5 | Yes
ADOdb V6 | Yes

This driver provides an undocumented enhancement to the oci8 driver

[oracle, unix, windows, deprecated]

# oracle

Support for oracle databases versions 7 and lower was removed in PHP version 5.1. In ADOdb version 6, the Oracle driver will be removed and the oci8 driver will become the oracle driver

##### Specification

Driver Name | oracle
Data Provider | oracle
Status | Obsolete5)
Windows | Yes
Unix | Yes
ADOdb V5 | Yes
ADOdb V6 | No

This driver provided support to oracle 7 and lower databases. The driver is obsolete, and not supported by PHP and will be removed in ADOdb version 6.0 The data provider name 'oracle' will be assigned to the oci8 driver. The oci8 driver will become a stub to provide backwards compatibility.

[oracle, unix, windows, obsolete, supported]
1) , 2) This driver is actively supported by ADOdb project members
3) , 4) This driver is obsolete is not actively supported or enhanced by ADOdb project members, but you can provide fixes and enhancements if you have the expertise
5) This driver is not maintained and will be removed in ADOdb V6
v5/database/oracle.txt · Last modified: 2016/01/17 06:27 by 184.99.209.82

### Page Tools

- Show pagesource
- Old revisions
- Backlinks
- Rename Page
- Back to top