laravel-oci8
laravel-oci8 copied to clipboard
[5.5] Fix updating of multiple blob entries.
Thanks, can you please provide some info on what the PR fixes? Any snippets to reproduce the issue would be helpful.
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