title: Oracle Apex - should I use Empty_BLOB() or null?
body: <p>I am currently using Oracle Apex 5.1.2.</p>
  
  <p>I created a table in the database that contains a column that can hold a BLOB data type, a column for filename, and a column for MIME type. </p>
  
  <p>In my APEX application, I have a File Browse page item. The intent for this page item is to allow the end-user to attach a file to the page. This part works perfectly - the user is able to browse for a file using that item and attach it to a page and later download the file in order to view it.</p>
  
  <p>The problem: I want the end-user to be able to delete the attachment if they need to and, if they'd like, attach another file in its place. My idea is to create a button and in the settings for the button set the Action to "Submit Page" and the Database Action to SQL Update Action. Then I will create a page process of type PL/SQL code and set the Server-side Condition in the settings for the process to occur when the button I created is pressed. In the PL/SQL code section of the process, it appears from the research I have done that I have one of two options:</p>
  
  <pre><code>UPDATE table_name
  SET blob_column = EMPTY_BLOB()
  WHERE my_id = id
  </code></pre>
  
  <p>OR:</p>
  
  <pre><code>UPDATE table_name
  SET blob_column = null
  WHERE my_id = id
  </code></pre>
  
  <p>I have already tried both of these options and they both work, but I don't know which option is better for what I am trying to achieve. I have tried to research this problem, but unfortunately I can't find the exact answer I am looking for. Does anyone have any recommendations?</p>
  
  <p>Thank you in advance.</p>