Oracle DB driver for Laravel 5

5.4.4 2017-06-08 18:44 UTC


OracleDB (updated for 5.4)

Latest Stable Version Total Downloads Build Status

OracleDB is an Oracle Database Driver package for Laravel Framework - thanks @taylorotwell. OracleDB is an extension of Illuminate/Database that uses either the [PDO_OCI] (http://www.php.net/manual/en/ref.pdo-oci.php) extension or the OCI8 Functions wrapped into the PDO namespace.

Please report any bugs you may find.


Add jfelder/oracledb as a requirement to composer.json:

    "require": {
        "jfelder/oracledb": "5.4.*"

And then run composer update

Once Composer has installed or updated your packages you need to register OracleDB. Open up config/app.php and find the providers key and add:


Finally you need to publish a configuration file by running the following Artisan command.

$ php artisan vendor:publish

This will copy the configuration file to config/oracledb.php

Basic Usage

The configuration file for this package is located at 'config/oracledb.php'. In this file you define all of your oracle database connections. If you need to make more than one connection, just copy the example one. If you want to make one of these connections the default connection, enter the name you gave the connection into the "Default Database Connection Name" section in 'config/database.php'.

Once you have configured the OracleDB database connection(s), you may run queries using the 'DB' class as normal.

NEW: The oci8 library in now the default library. If you want to use the pdo library, enter "pdo" as the driver and the code will automatically use the pdo library instead of the oci8 library. Any other value will result in the oci8 library being used.

$results = DB::select('select * from users where id = ?', array(1));

The above statement assumes you have set the default connection to be the oracle connection you setup in config/database.php file and will always return an 'array' of results.

$results = DB::connection('oracle')->select('select * from users where id = ?', array(1));

Just like the built-in database drivers, you can use the connection method to access the oracle database(s) you setup in config/oracledb.php file.

Inserting Records Into A Table With An Auto-Incrementing ID

	$id = DB::connection('oracle')->table('users')->insertGetId(
		array('email' => 'john@example.com', 'votes' => 0), 'userid'

Note: When using the insertGetId method, you can specify the auto-incrementing column name as the second parameter in insertGetId function. It will default to "id" if not specified.

See Laravel Database Basic Docs for more information.


Licensed under the MIT License.