Code Weaver

Helps Laravel developers discover, compare, and choose open-source packages. See popularity, security, maintainers, and scores at a glance to make better decisions.

Laravel Oci8 Laravel Package

yajra/laravel-oci8

Oracle database driver for Laravel using the PHP OCI8 extension. Adds an Illuminate/Database-compatible Oracle connection, query builder and schema support, with versioned releases matching Laravel versions and optional PHPStan/Larastan stubs for OCI8-specific DB methods.

View on GitHub

Deep Wiki

Context7

v13.2.0

13.2.0 (2026-04-07)

Features

implement compileThreadCount (9cb4f03)
use native json type for Oracle 21c and above (eb039ce)

v13.1.0

13.1.0 (2026-04-07)

Bug Fixes

move binary_ci in whereLike to 12cR2 version (8f41811)
pint :robot: (09a8d0a)
table comment generation in SchemaBuilder (f0057e1)
typo in OracleGrammar comment retrieval (13e6838)

Features

add context7 configuration file (73560ae)
dependency-aware join reorder (e609a08)
implement index renaming in OracleGrammar (5f5d45d)
update larastan extension (b6c3d1f)

v13.0.0

What's Changed

feat: upgrade to laravel 13 by @csaba215 in https://github.com/yajra/laravel-oci8/pull/975
test: add more tests from laravel framework by @csaba215 in https://github.com/yajra/laravel-oci8/pull/974

Full Changelog: https://github.com/yajra/laravel-oci8/compare/v12.11.0...v13.0.0

v12.11.0

12.11.0 (2026-03-17)

Bug Fixes

pint :robot: (41d979c)
pint :robot: (fe0b150)

Features

add OracleSchemaState for dumping and loading database schema (7a1973a)
wrap insertGetId PDO errors as QueryException (62bfae5)

v12.10.1

12.10.1 (2026-03-06)

Bug Fixes

align getCountForPagination logic to upstream laravel (73927b0)

v12.10.0

12.10.0 (2026-02-25)

Bug Fixes

pint :robot: (084612a)
simplify whereDate to always use to_date with YYYY-MM-DD mask (bd7ef47)
Support date comparison operators in whereDate() - Issue #964 (4a3cceb)

Features

add tests from laravel framework and rework current tests (847a8e1)

v12.9.0

12.9.0 (2026-02-24)

Features

filter rn number (b31fb12)

v12.8.0

12.8.0 (2026-02-21)

Features

prepare for newer oracle versions (c85d81d)

v12.7.0

12.7.0 (2026-02-18)

Features

add PHPStan extensions for Oracle procedure reflection (f9af7b2)
reorder joins to fix oracle specific functions (f291eac)

v12.6.1

12.6.1 (2026-01-21)

Bug Fixes

compileColumns returning internal hidden oracle columns (a1e03d1)

v12.6.0

12.6.0 (2026-01-19)

Bug Fixes

withExists and add test for it (d1cb941)

Features

clob binding in upsert when above 3999 char and add tests for it (80fd461)
improve tests for withExists and add tests other similar with functions (a13fa1e)

v12.5.0

12.5.0 (2026-01-13)

Bug Fixes

pint :robot: (2b84ee9)
preserve nullable constraint when modifying Oracle columns (b6dd9be), closes #941

Features

add generatedAs function similar to pgsql (1c5dbe8)
add onNull to match trigger style logic, add tests for it, mark 12c tests as skipped instead of empty (c0a650c)
override Blueprint id() function based on oracle version (d800b3d)

v12.4.0

12.4.0 (2026-01-06)

Bug Fixes

json tests (6e63048)
wrong comment (a1354a3)

Features

add more json tests (bc85c02)
add support for whereJsonContains (638cfec)
implement whereJsonBoolean, whereJsonContainsKey, whereJsonLength, add tests for them and further improve tests (1e3cfc6)
scaffold compatibility tests for pgsql (c756b2c)
update readme with json support (2c14876)

v12.3.2

12.3.2 (2025-12-31)

Bug Fixes

raw query in multiple insert (8526b40)

v12.3.1

12.3.1 (2025-12-20)

Bug Fixes

use limit syntax for 12c only when limit is set (1e4586e)

v12.3.0

12.3.0 (2025-12-11)

Bug Fixes

pint :robot: (e76225d)

Features

use COLLATE BINARY_CI in where like for 12c+ (c23c671)

v12.2.0

12.2.0 (2025-12-08)

Bug Fixes

when values are empty use ($sequence) values(DEFAULT) syntax in compileInsertGetId (953bd88)

Features

ci: run tests for 21c too (fdea0ab)

v11.6.7

11.6.7 (2025-11-21)

Bug Fixes

preserve nullable constraint when modifying column length (fixes #941) (51d6af5)

Reverts

remove compileTableExists, wrapTable, and compileTables changes (9d3d0cb), closes #941

v12.1.10

What's Changed

fix: Fix issue where db_prefix is not considered in max length by @hpacleb in https://github.com/yajra/laravel-oci8/pull/934
Add Semantic Release workflow on Actions by @jidago in https://github.com/yajra/laravel-oci8/pull/935
CI/CD: Update Semantic Release as manual run by @jidago in https://github.com/yajra/laravel-oci8/pull/936
ci: test against 8.5 by @nikoolz in https://github.com/yajra/laravel-oci8/pull/937
fix(#938): use offsets only when no locks are used by @csaba215 in https://github.com/yajra/laravel-oci8/pull/939

New Contributors

@nikoolz made their first contribution in https://github.com/yajra/laravel-oci8/pull/937
@csaba215 made their first contribution in https://github.com/yajra/laravel-oci8/pull/939

Full Changelog: https://github.com/yajra/laravel-oci8/compare/v12.1.8...v12.1.10

v12.1.9

What's Changed

fix: Fix issue where db_prefix is not considered in max length by @hpacleb in https://github.com/yajra/laravel-oci8/pull/934

Full Changelog: https://github.com/yajra/laravel-oci8/compare/v12.1.8...v12.1.9

v12.1.8

What's Changed

Fix runPaginationCountQuery for Oracle: remove AS from subquery alias on version 12 by @a05151988 in https://github.com/yajra/laravel-oci8/pull/932
Fix https://github.com/yajra/laravel-oci8/issues/927

New Contributors

@a05151988 made their first contribution in https://github.com/yajra/laravel-oci8/pull/932

Full Changelog: https://github.com/yajra/laravel-oci8/compare/v12.1.7...v12.1.8

v11.6.6

What's Changed

Fix duplicate ORDER BY clauses when using lock() without limit() (for 11.x) by @Xinguang in https://github.com/yajra/laravel-oci8/pull/931

Full Changelog: https://github.com/yajra/laravel-oci8/compare/v11.6.5...v11.6.6

v12.1.7

What's Changed

Fix duplicate ORDER BY in Oracle lock queries by @Xinguang in https://github.com/yajra/laravel-oci8/pull/930

New Contributors

@Xinguang made their first contribution in https://github.com/yajra/laravel-oci8/pull/930

Full Changelog: https://github.com/yajra/laravel-oci8/compare/v12.1.6...v12.1.7

v12.1.6

What's Changed

Fix Migration comment not working, ORA-00904 by @ErDiabIo in https://github.com/yajra/laravel-oci8/pull/929
Fix https://github.com/yajra/laravel-oci8/issues/910

Full Changelog: https://github.com/yajra/laravel-oci8/compare/v12.1.5...v12.1.6

v11.6.5

What's Changed

ci: add 8.3 and 8.4 by @yajra in https://github.com/yajra/laravel-oci8/pull/898
fix: log query time to be compatible with laravel logging by @fagundes in https://github.com/yajra/laravel-oci8/pull/928

Full Changelog: https://github.com/yajra/laravel-oci8/compare/v11.6.4...v11.6.5

v12.1.5

What's Changed

Fix: Remove unnecessary wrapping of sequence name in drop method by @ErDiabIo in https://github.com/yajra/laravel-oci8/pull/926

Full Changelog: https://github.com/yajra/laravel-oci8/compare/v12.1.4...v12.1.5

v12.1.4

What's Changed

fix: log query time to be compatible with laravel logging by @fagundes in https://github.com/yajra/laravel-oci8/pull/925

Full Changelog: https://github.com/yajra/laravel-oci8/compare/v12.1.3...v12.1.4

v12.1.3

What's Changed

fix: php artisan db:show by @ErDiabIo in https://github.com/yajra/laravel-oci8/pull/924

Full Changelog: https://github.com/yajra/laravel-oci8/compare/v12.1.2...v12.1.3

v12.1.2

What's Changed

fix: ORA-00942 when try to drop any table by @ErDiabIo in https://github.com/yajra/laravel-oci8/pull/923
fix: https://github.com/yajra/laravel-oci8/issues/916
fix: https://github.com/yajra/laravel-oci8/issues/917

Full Changelog: https://github.com/yajra/laravel-oci8/compare/v12.1.1...v12.1.2

v12.1.1

What's Changed

fix: schema prefix implementation by @yajra in https://github.com/yajra/laravel-oci8/pull/920
fix: pagination error "Undefined property: stdClass::$aggregate" by @nightwalkeryao in https://github.com/yajra/laravel-oci8/pull/921
fix: https://github.com/yajra/laravel-oci8/issues/919
fix: https://github.com/yajra/laravel-oci8/issues/905

New Contributors

@nightwalkeryao made their first contribution in https://github.com/yajra/laravel-oci8/pull/921

Full Changelog: https://github.com/yajra/laravel-oci8/compare/v12.1.0...v12.1.1

v12.1.0

What's Changed

feat: add support for dateTime with timezone by @yajra in https://github.com/yajra/laravel-oci8/pull/918

Full Changelog: https://github.com/yajra/laravel-oci8/compare/v12.0.2...v12.1.0

v12.0.2

What's Changed

fix: ORA-00942, wrong trigger prefix by @yajra in https://github.com/yajra/laravel-oci8/pull/9090
fix: #905
fix: drop if exist when using schema prefix 498fb94

Full Changelog: https://github.com/yajra/laravel-oci8/compare/v12.0.1...v12.0.2

v12.0.1

What's Changed

fix: compileDropIfExists by @yajra in https://github.com/yajra/laravel-oci8/pull/907

Full Changelog: https://github.com/yajra/laravel-oci8/compare/v12.0.0...v12.0.1

v12.0.0

What's Changed

ci: add 8.3 and 8.4 by @yajra in https://github.com/yajra/laravel-oci8/pull/898
feat: Laravel 12 by @yajra in https://github.com/yajra/laravel-oci8/pull/902
feat: FullText Search in laravel-oci8 by @jonas-elias in https://github.com/yajra/laravel-oci8/pull/800

New Contributors

@jonas-elias made their first contribution in https://github.com/yajra/laravel-oci8/pull/800

Full Changelog: https://github.com/yajra/laravel-oci8/compare/v11.6.4...v12.0.0

v11.6.4

fix: OracleGrammar::compileDropAllTables method to ignore secondary objects. #897
fix: #896

v11.6.3

fix: 🐛 multibyte object name causes error #895

v11.6.2

fix: #890
fix: #891
fix: v11.6.1 tagged on wrong branch

v11.6.1

fix: missing prefix on table alias #889
fix: #886
fix: #875

Weaver

How can I help you explore Laravel packages today?

Conversation history is not saved when not logged in.

Add packages to context

No packages found.

davejamesmiller/laravel-breadcrumbs

artisanry/parsedown

christhompsontldr/phpsdk

enqueue/dsn

bunny/bunny

enqueue/test

enqueue/null

enqueue/amqp-tools

milesj/emojibase

bower-asset/punycode

bower-asset/inputmask

bower-asset/jquery

bower-asset/yii2-pjax

laravel/nova

spatie/laravel-mailcoach

spatie/laravel-superseeder

laravel/liferaft

nst/json-test-suite

danielmiessler/sec-lists

jackalope/jackalope-transport