Oracle WPG_DOCLOAD Demos

Oracle WPG_DOCLOAD Version 11.2.0.3

General Information

AUTHID

DEFINER

Constants

Name	Data Type	Value
max_doctable_name_len	PLS_INTEGER	256
mimet_col_len	PLS_INTEGER	48
name_col_len	PLS_INTEGER	64

Data Types

TYPE parts_table IS TABLE OF VARCHAR2(256) INDEX BY BINARY_INTEGER;

Dependencies

DBMS_ASSERT	WWV_FLOW_DML	WWV_FLOW_SVG
DBMS_LOB	WWV_FLOW_FILE_MGR	WWV_FLOW_UTILITIES
DBMS_SQL	WWV_FLOW_FLASH_CHART	WWV_FLOW_WORKSHEET
DBMS_SYS_SQL	WWV_FLOW_IMAGE_GENERATOR	WWV_FLOW_WORKSHEET_ATTACHMENT
HTP	WWV_FLOW_LOAD_DATA	WWV_FLOW_XLIFF
OWA_UTIL	WWV_FLOW_PAGE_CACHE_API	WWV_RENDER_REPORT3
WWV_FLOW_DATALOAD_XML	WWV_FLOW_RENDER_QUERY

Security Model

Owned by SYS with EXECUTE granted to PUBLIC

Source

{ORACLE_HOME}/rdbms/admin/wpgdocs.sql

Subprograms

DOWNLOAD_FILE	GET_DOWNLOAD_BLOB
GET_CONTENT_LENGTH	GET_DOWNLOAD_FILE	IS_FILE_DOWNLOAD
GET_DOWNLOAD_BFILE

DOWNLOAD_FILE

Signals the PL/SQL Gateway that p_blob is to be downloaded to the client's browser

Overload 1

wpg_docload.download_file(
p_filename IN VARCHAR2,
p_bcaching IN BOOLEAN DEFAULT TRUE);

TBD

Overload 2

wpg_docload.download_file(p_blob IN OUT NOCOPY BLOB);

TBD

Overload 3

wpg_docload.download_file(p_blob IN OUT BFILE);

TBD

GET_CONTENT_LENGTH

Return the length of a lob to be downloaded

wpg_docload.get_content_length RETURN PLS_INTEGER;

TBD

GET_DOWNLOAD_BFILE (private ... do not use)

Fetch the bfile to be downloaded

wpg_docload.get_download_blob(p_bfile OUT BFILE);

TBD

GET_DOWNLOAD_BLOB (private ... do not use)

Fetch the blob to be downloaded

wpg_docload.get_download_blob(p_blob OUT NOCOPY BLOB);

TBD

GET_DOWNLOAD_FILE (private ... do not use)

Get the name and mime_type of the file to be downloaded

wpg_docload.get_download_file(p_doc_info OUT VARCHAR2);

TBD

IS_FILE_DOWNLOAD

Is there a file to download?

wpg_docload.is_file_download RETURN BOOLEAN

-- 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
s_mime_type VARCHAR2(48);
n_length NUMBER;
s_filename VARCHAR2(400);
lob_image BLOB;
BEGIN
SELECT mime_type, dbms_lob.getlength( blob_content ), filename, blob_content
INTO s_mime_type, n_length, s_filename, lob_image
FROM easy_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 || '"');
owa_util.http_header_close;
-- Download the BLOB
wpg_docload.download_file(lob_image);
END display_easy_image;
/