Is there a way to handle this, and instead send a BLOB that contains a "Not found" message? Otherwise we get a HTTP 404.
Here's my simple media resource query for the GET
Select mime_type as mimetype, report_blob from schema.reports where report_name = :filename
If the row is not found, I would want the report_blob to contain the row with the "Not Found" BLOB.
As in: Select report_blob into v_missing_pdf from schema.reports where report_name = 'ReportNotFound.pdf';
Edit: ORDS 3.0.9 - Database 12.2 - APEX 5.1.1
Thanks!