Arjay Angeles
Arjay Angeles
It was added on https://github.com/yajra/pdo-via-oci8/blob/2.0/CHANGELOG.md#v240---2022-02-09 and v3, were you able to update to latest version?
You can use `DB::setDateFormat('YYYY-MM-DD')`. This command will set both date and timestamp format though. See https://yajrabox.com/docs/laravel-oci8/master/date-format.
Oh, is `NLS_TIMESTAMP_FORMAT` equivalent to `NLS_TIMESTAMP_TZ_FORMAT`? If not, you will have to do a manual statement. ``` DB::statement("ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD'"); ```
@Adam2Marsh this is the first time I heard about edition. Making a quick search on it and seems like we just need to alter the session as you mentioned. In...
Can you please provide the error dump? The code looks fine.
@bendparker might indeed be related to dates. When using the package, the date format in session is set to `YYYY-MM-DD HH:MI:SS` if I recall correctly. If values are not in...
Can you please provide some snippets to reproduce the issue?
Is it the recommended way to get the next id? I think you should be getting it directly from the sequence? ```php DB::getSequence()->nextValue('USERS_ID_SEQ'); ```
Not sure but maybe persistent configuration might help? ```php 'options' => [ PDO::ATTR_PERSISTENT => true, ], ```
Looks good, however I suggest we include if possible on the config side. Consider having multiple oracle connections with different version. This might cause a breaking change? Thanks!