Yii2 Connect Oracle via OCI8

This library is based on yajra/pdo-via-oci8 Version 3 that support PHP 8.2.

Installation

Install With Composer

The preferred way to install this extension is through composer.

Either run

php composer.phar require apaoww/yii2-oci8 "dev-master"

or add

"apaoww/yii2-oci8": "dev-master"

to the require section of your composer.json file.

OR Install From Archive

You can also install from archive. Add aliase on config file to point alias to the folder

return [
    ...
    'aliases' => [
        '@apaoww/oci8' => 'path/to/your/extracted',
        ...
    ]
];

Usage

Once the extension is installed, simply modify your application configuration on main-local.php as follows :

return [    
    'components' => [
        ....
        'db' => [
                    'class' => 'apaoww\oci8\Oci8DbConnection',
                    'dsn' => 'oci:dbname=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SID=xe)));charset=AL32UTF8;',
                    'username' => 'yourdatabaseschemaname',
                    'password' => 'databasepassword',
            'enableSchemaCache' => true, //increase performance when retrieved table meta data
                    'schemaCacheDuration' => 3600,
                    'schemaCache' => 'cache',
            'on afterOpen' => function($event) {

                /* A session configuration example */
                $q = <<<SQL
begin
  dbms_session.set_role('NAME_OF_YOUR_ROLE_IN_ORACLE');
  EXCEPTION  -- exception handlers begin
   WHEN OTHERS THEN  -- handles all other errors
      ROLLBACK;
end;
SQL;
                $event->sender->createCommand($q)->execute();
            },
                    // To convert column name to lower case
                    'schemaMap' => ['oci' => 'apaoww\oci8\ESchemaOci',],
                'attributes' => [
    //                PDO::ATTR_STRINGIFY_FETCHES => true,
                    PDO::ATTR_CASE => PDO::CASE_LOWER,
                ],
                    ],
    ],
];