laravel-oci8 icon indicating copy to clipboard operation
laravel-oci8 copied to clipboard

[5.5] Fix updating of multiple blob entries.

Open operezg opened this issue 7 years ago • 2 comments

operezg avatar May 31 '18 18:05 operezg

Thanks, can you please provide some info on what the PR fixes? Any snippets to reproduce the issue would be helpful.

yajra avatar Jun 01 '18 02:06 yajra

Of course This is a example to updateLob function

$idData = $this->connection->table('table')->updateLob(
                [
                    "field1" => "",
                    "field2" => "",
                    "field3" => "",
                ],
                [
                    "fieldblob1" => '',
                    "fieldblob2" => '',
                    "fieldblob3" => '',
                ], 'id_table'
            );

When try to insert blob in oracle the field need to init to = EMPTY_BLOB() each fields to set, the current implementation set "fieldblob1, fieldblob2, fieldblob3 = EMPTY_BLOB()" this causes error ORA-00927: missing equal sign and in oracle need fieldblob1 = EMPTY_BLOB(), fieldblob2 = EMPTY_BLOB(), fieldblob3 = EMPTY_BLOB() to correct sintaxis

operezg avatar Jun 01 '18 15:06 operezg