/** * 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; }); }
/** * Register the service provider. * * @return void */ public function register() { if (file_exists(config_path('oracle.php'))) { $this->mergeConfigFrom(config_path('oracle.php'), 'database.connections'); } else { $this->mergeConfigFrom(__DIR__ . '/../config/oracle.php', 'database.connections'); } $this->app['db']->extend('oracle', function ($config) { $connector = new Connector(); $connection = $connector->connect($config); $db = new Oci8Connection($connection, $config["database"], $config["prefix"], $config); if (!empty($config['skip_session_vars'])) { return $db; } // 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; }); }