pdo-via-oci8's Introduction

Oracle PDO Userspace Driver for OCI8

PDO via Oci8

The yajra/pdo-via-oci8 package is a simple userspace driver for PDO that uses the tried and tested OCI8 functions instead of using the still experimental and not all that functionnal PDO_OCI library.

Please report any bugs you may find.

Installation
Credits

Installation

Add yajra/laravel-pdo-via-oci8 as a requirement to composer.json:

{
    "require": {
        "yajra/laravel-pdo-via-oci8": "2.*"
    }
}

And then run composer update

PHP 8 Support

When using PHP 8, please use version 3: "yajra/laravel-pdo-via-oci8": "3.*".

Testing

There is a test suite (using PHPUnit with a version bigger than 6.x) on the test directory. If you want to test (you must test your code!), create a table called people with two columns:

name as varchar2(50)
email as varchar2(30)

And some environment variables:

OCI_USER with the database user name
OCI_PWD with the database password
OCI_STR with the database connection string

And then go to the test dir and run PHPUnit like:

phpunit --colors .

Examle to get it up and running on docker DB container-registry.oracle.com/database/enterprise:12.2.0.1

create pluggable database testpdb admin user oracle identified by system file_name_convert = ('/pdbseed/', '/testpdb01/');
alter pluggable database testpdb open;

ALTER SESSION SET CONTAINER=testpdb;

CREATE TABLE person (name NVARCHAR2(50), email NVARCHAR2(30));