PHPackages                             ojenra/laravel-sproc - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. ojenra/laravel-sproc

Abandoned → [masterei/laravel-sproc](/?search=masterei%2Flaravel-sproc)Library[Database & ORM](/categories/database)

ojenra/laravel-sproc
====================

Laravel Query Builder for handling stored procedure.

v3.0.2(2y ago)113MITPHPPHP ^7.3|^8.0

Since Jul 17Pushed 2y ago1 watchersCompare

[ Source](https://github.com/masterei/laravel-sproc)[ Packagist](https://packagist.org/packages/ojenra/laravel-sproc)[ Docs](https://github.com/masterei/laravel-sproc)[ RSS](/packages/ojenra-laravel-sproc/feed)WikiDiscussions main Synced 1mo ago

READMEChangelog (8)Dependencies (1)Versions (10)Used By (0)

Laravel Sproc
=============

[](#laravel-sproc)

[![Latest Version on Packagist](https://camo.githubusercontent.com/e30d53148a965c376cdec6c99bd16b8d965ad446542a991c81762175bde3e76c/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f6d617374657265692f6c61726176656c2d7370726f632e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/masterei/laravel-sproc)[![Total Downloads](https://camo.githubusercontent.com/19a20e4dae3b0b233ad8547f4b3ac3f76246dda50cfe3959315ab1d879b223cb/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f6d617374657265692f6c61726176656c2d7370726f632e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/masterei/laravel-sproc)

Laravel Query Builder for handling stored procedure.

Installation
------------

[](#installation)

You can install the package via composer:

```
composer require masterei/laravel-sproc
```

Optionally, you can publish the config file with:

```
php artisan vendor:publish --tag="sproc-config"
```

Usage
-----

[](#usage)

Import class facade

```
use Masterei\Sproc\Facades\SP;
```

execute()

```
 /**
 * Use this method if you are not expecting any dataset result.
 * @return void
 */

SP::call('stored_procedure_name')
    ->params([
        'Param01' => 'Arg01',
        'Param02' => 'Arg02',
    ])
    ->execute();
```

get()

```
/**
 * Standard way of retrieving data from stored procedure.
 * This method accepts a dataset index. The default index is 0.
 */

SP::call('stored_procedure_name')
    ->params([
        'Param01' => 'Arg01',
        'Param02' => 'Arg02',
    ])
    ->get();
```

first()

```
/**
 * Returns first object from an object array.
 */

SP::call('stored_procedure_name')
    ->params([
        'Param01' => 'Arg01',
        'Param02' => 'Arg02',
    ])
    ->first();
```

all()

```
/**
 * Retrieves all dataset result.
 * Can be chained with first() method.
 */

SP::call('stored_procedure_name')
    ->params([
        'Param01' => 'Arg01',
        'Param02' => 'Arg02',
    ])
    ->all();
```

fetch()

```
/**
 * Use this method to initialize dataset results.
 * Can be chained with first(), get() or all() method.
 */

$sp = SP::call('stored_procedure_name')
    ->params([
        'Param01' => 'Arg01',
        'Param02' => 'Arg02',
    ])
    ->fetch();

// example
$data01 = $sp->get(1);
$data02 = $sp->get(2);
```

getScopeID()

```
/**
 * Returns id, ID or first row result generated by the stored procedure.
 */

SP::call('stored_procedure_name')
    ->params([
        'Param01' => 'Arg01',
        'Param02' => 'Arg02',
    ])
    ->getScopeID();
```

toSql()

```
/**
 * Use this method to view generated raw query string.
 */

SP::call('stored_procedure_name')
    ->params([
        'Param01' => 'Arg01',
        'Param02' => 'Arg02',
    ])
    ->toSql();
```

hydrate()

```
/**
 * Convert plain arrays into collection of models.
 * Can be chained with first(), get() or all() method.
 */

SP::hydrate([
    "key01" => "value01",
    "key02" => "value02"
]);
```

Note
----

[](#note)

- This package uses Laravel Eloquent Collection meaning that you can freely use its features like groupBy(), sortBy(), map() etc.

Changelog
---------

[](#changelog)

Please see [CHANGELOG](CHANGELOG.md) for more information on what has changed recently.

License
-------

[](#license)

The MIT License (MIT). Please see [License File](LICENSE.md) for more information.

###  Health Score

26

—

LowBetter than 43% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity7

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity58

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~72 days

Recently: every ~122 days

Total

8

Last Release

887d ago

Major Versions

v1.1.2 → v2.0.02022-11-07

v2.0.0 → v3.0.02023-01-19

### Community

Maintainers

![](https://www.gravatar.com/avatar/c8b19fb533634e9c6f48193419880bcdf5c3b17be1e0933e569a2cfb220290c9?d=identicon)[masterei](/maintainers/masterei)

---

Top Contributors

[![masterei](https://avatars.githubusercontent.com/u/34229270?v=4)](https://github.com/masterei "masterei (20 commits)")

---

Tags

mastereilaravel-sprocsproc

### Embed Badge

![Health badge](/badges/ojenra-laravel-sproc/health.svg)

```
[![Health](https://phpackages.com/badges/ojenra-laravel-sproc/health.svg)](https://phpackages.com/packages/ojenra-laravel-sproc)
```

###  Alternatives

[doctrine/orm

Object-Relational-Mapper for PHP

10.2k285.3M6.2k](/packages/doctrine-orm)[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k115.1M102](/packages/jdorn-sql-formatter)[illuminate/database

The Illuminate Database package.

2.8k52.4M9.4k](/packages/illuminate-database)[mongodb/mongodb

MongoDB driver library

1.6k64.0M546](/packages/mongodb-mongodb)[ramsey/uuid-doctrine

Use ramsey/uuid as a Doctrine field type.

90340.3M211](/packages/ramsey-uuid-doctrine)[reliese/laravel

Reliese Components for Laravel Framework code generation.

1.7k3.4M16](/packages/reliese-laravel)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)