Skip to content
Icon

WARNING You're browsing the documentation for an old version of LARAVEL-OCI8. Consider upgrading your project to laravel-oci8 11.0.

Stand Alone Usage

This documentation demonstrates how to use the package outside of Laravel.

  • add "yajra/laravel-oci8": "9.0.*" on your composer then run composer install
  • create database.php and add the code below
require 'vendor/autoload.php';
 
use Illuminate\Database\Capsule\Manager as Capsule;
use Yajra\Oci8\Connectors\OracleConnector;
use Yajra\Oci8\Oci8Connection;
 
$capsule = new Capsule;
 
$manager = $capsule->getDatabaseManager();
$manager->extend('oracle', function($config)
{
$connector = new OracleConnector();
$connection = $connector->connect($config);
$db = new Oci8Connection($connection, $config["database"], $config["prefix"]);
 
// set oracle session variables
$sessionVars = [
'NLS_TIME_FORMAT' => 'HH24:MI:SS',
'NLS_DATE_FORMAT' => 'YYYY-MM-DD HH24:MI:SS',
'NLS_TIMESTAMP_FORMAT' => 'YYYY-MM-DD HH24:MI:SS',
'NLS_TIMESTAMP_TZ_FORMAT' => 'YYYY-MM-DD HH24:MI:SS TZH:TZM',
'NLS_NUMERIC_CHARACTERS' => '.,',
];
 
// Like Postgres, Oracle allows the concept of "schema"
if (isset($config['schema']))
{
$sessionVars['CURRENT_SCHEMA'] = $config['schema'];
}
 
$db->setSessionVars($sessionVars);
 
return $db;
});
 
$capsule->addConnection(array(
'driver' => 'oracle',
'host' => 'oracle.host',
'database' => 'xe',
'username' => 'user',
'password' => 'password',
'prefix' => '',
'port' => 1521
));
 
$capsule->bootEloquent();

Set the event dispatcher used by Eloquent models (Optional).

use Illuminate\Events\Dispatcher;
use Illuminate\Container\Container;
$capsule->setEventDispatcher(new Dispatcher(new Container));
 
// Make this Capsule instance available globally via static methods... (optional)
$capsule->setAsGlobal();

Now we can start working with database tables just like we would if we were using Laravel!

require 'database.php';
 
// Create the User model
class User extends Illuminate\Database\Eloquent\Model {
public $timestamps = false;
}
 
// Grab a user with an id of 1
$user = User::find(1);
 
echo $user->toJson(); die();