Package information:
Code Information:
Oci8 is a wrapper for the PHP Oracle OCI functions that allows interaction
with Oracle databases by using objects in place of the regular oci_*
functions.
Oci8 converts the warnings thrown by the oci_*
function into Oci8Exceptions
for better error handling.
Via Composer
$ composer require jpina/oci8
Connect to a database, execute a query and fetch a row:
$db = new Jpina\Oci8Connection('username', 'password', '//localhost:1521/XE');
$statement = $db->parse('SELECT * FROM dual');
$statement->execute();
$row = $statement->fetchAssoc();
Handing errors
try {
$db = new Jpina\Oci8Connection('username', 'password', '//localhost:1521/XE');
// Closing database to force an error on next statement
$db->close();
// This statement will throw an Oci8Exception since there is no active connection
$statement = $db->parse('SELECT * FROM dual');
} catch (Jpina\Oci8Exception $ex) {
// Handle the Exception
}
Please see CHANGELOG for more information what has changed recently.
In order to run the tests you will need access to an Oracle Database and copy the .env.example
to .env
, then you
can provide your own values within the .env
, these values will be used by the tests to connect to the database.
You can run the tests with composer once you have your .env
file configured properly.
$ composer test
If you don't have access to an Oracle Database server, you can also run a docker container like wnameless/oracle-xe-11g and then connect to it to run the tests against a containerized Oracle Database.
Please see CONTRIBUTING and CONDUCT for details.
If you discover any security related issues, please email jabdhel@gmail.com instead of using the issue tracker.
The MIT License (MIT). Please see License File for more information.