title: How can I append/concatenate BLOB data to a BLOB column using SQL UPDATE command in ORACLE
body: <p>I need to append data to my BLOB field,
  how can I do this using an UPDATE command?
  What i am asking is; is it possible to concatenate blob data so that i can eventually set it to a field like
  UPDATE BLOB_table
  SET
  BLOB_field = BLOB_field + BLOB_data</p>
  
  <p>I tried using DBMS_LOB.APPEND but it does not return a value; so i created a function which gives me an error of "invalid LOB locator specified"</p>
  
  <pre><code>CREATE OR REPLACE FUNCTION MAKESS.CONCAT_BLOB(A in BLOB,B in BLOB) RETURN BLOB IS
   C BLOB;
  BEGIN
  DBMS_LOB.APPEND(c,A);
  DBMS_LOB.APPEND(c,B);
  RETURN c;
  END;
  /
  </code></pre>