Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
11g Release 1 (11.1)

Part Number B28419-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

221 WPG_DOCLOAD

The WPG_DOCLOAD package provides an interface to download files, BLOBs and BFILEs.

See Also:

For more information about implementation of this package:

The chapter contains the following topics:


Using WPG_DOCLOAD


Constants

NAME_COL_LEN

The NAME column in your document table must be the same as the value of name_col_len.

name_col_len CONSTANT pls_integer := 64;

MIMET_COL_LEN

The MIME_TYPE column in your document table must be the same as the value of mimet_col_len.

mimet_col_len CONSTANT pls_integer := 48;

MAX_DOCTABLE_NAME_LEN

The name length of your document table must be less than max_doctable_name_len.

max_doctable_name_len CONSTANT pls_integer := 256;

Summary of WPG_DOCLOAD Subprograms

Table 221-1 WPG_DOCLOAD Package Subprograms

Subprogram Description
DOWNLOAD_FILE Procedures Downloads files, BLOBS and BFILES


DOWNLOAD_FILE Procedures

There are three versions of this procedure:

Syntax

WPG_DOCLOAD.DOWNLOAD_FILE(
   p_filename      IN             VARCHAR2, 
   p_bcaching      IN             BOOLEAN DEFAULT TRUE);
WPG_DOCLOAD.DOWNLOAD_FILE(
   p_blob          IN OUT NOCOPY  BLOB);

WPG_DOCLOAD.DOWNLOAD_FILE(
   p_bfile         IN OUT         BFILE);

Parameters

Table 221-2 DOWNLOAD_FILE Procedure Parameters

Parameter Description
p_filename The file to download from the document table.
p_blob The BLOB to download.
p_bfile The BFILE to download (see Usage Notes).
p_bcaching Whether browser caching is enabled (see Usage Notes).

Usage Notes