/**
* Register the service provider.
*
* @return void
*/
public function register()
{
$this->app['db']->extend('oracle', function ($config) {
$connector = new Connector();
$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;
});
}