The Library is currently in the process of being upgraded from Oracle Database Version 22.214.171.124 to 126.96.36.199.
Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs,
and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news.
There is absolutely not a byte of truth to these irresponsible rumors.
Provides an interface to download files, BLOBs and BFILEs for use with the PL/SQL Gateway
TYPE parts_table IS TABLE OF VARCHAR2(256) INDEX BY BINARY_INTEGER;
Owned by SYS with EXECUTE granted to PUBLIC and APEX_040200
-- Unvalidated: From an internet source of unknown reliability
GRANT execute ON display_easy_image TO public;
CREATE OR REPLACE PROCEDURE display_easy_image( p_id NUMBER ) AS
SELECT mime_type, dbms_lob.getlength( blob_content ), filename, blob_content
INTO s_mime_type, n_length, s_filename, lob_image
WHERE image_id = p_id;
-- set the size so the browser knows how much it will be downloading.
owa_util.mime_header(NVL(s_mime_type, 'application/octet' ), FALSE);
htp.p('Content-length: ' || n_length);
-- The filename will be used by the browser if the users does a "Save as"
htp.p('Content-Disposition: filename="' || s_filename || '"');
-- Download the BLOB