Arjay Angeles

Try executing it manually. See https://yajrabox.com/docs/laravel-oci8/master/stored-procedure for ref. Thanks!

For a workaround, you can duplicate the `Oci8ServiceProvider.php` class and remove any alter session that is not applicable on your DB version. You will also need to disable auto package...

It seems like `compileDisableForeignKeyConstraints` is not yet available on the package. Will try to implement this when I got the chance. If you can please do not hesitate to submit...

This is the expected behaviour. If you want it trimmed, I suggest you update the type to `varchar2` if possible.

On some installations, `php.ini` for cli is different. I suggest you check which config file is being loaded on cli and then enable the oci8 plugin there. On mac, here...

Per [SO Post](https://stackoverflow.com/questions/756558/what-is-the-maximum-length-of-a-table-name-in-oracle#:~:text=In%20Oracle%2012.2%20and%20above,name%20length%20is%2030%20bytes.) In [Oracle 12.2](http://docs.oracle.com/database/122/REFRN/ALL_OBJECTS.htm#REFRN20146) and above the maximum object name length is 128 bytes. In [Oracle 12.1](https://docs.oracle.com/database/121/SQLRF/sql_elements008.htm#SQLRF00223) and below the maximum object name length is 30 bytes. We...

Might be a grant privilege issue? Is the schema you are using allowed to drop objects? Yes, I do not suggest using `php artisan migrate:fresh` when working with existing database...

It seems like you are using a wrong connection. It should be `Oci8Connection` and not `MySqlConnection`. Use something like: `DB::connection('oracle')->executeProcedure(...)`.

@oohdeveloper the default date format that we are using is `RRRR-MM-DD HH24:MI:SS`. You need to follow this format when working with dates. ```php $date = DB::selectOne("select f_recibo_fec_ultpago(36601,'2017-10-23') from dual"); ```...

I think this recent PR is what you need. See https://github.com/yajra/pdo-via-oci8/pull/74.