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

Part Number E25788-04
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
PDF · Mobi · ePub
ARPLS200

239 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:

ARPLS71593

Using WPG_DOCLOAD

ARPLS71594

Constants

ARPLS71595

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;
ARPLS71596

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;
ARPLS71597

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;
ARPLS71598

Summary of WPG_DOCLOAD Subprograms

ARPLS71599Table 239-1 WPG_DOCLOAD Package Subprograms

Subprogram Description

DOWNLOAD_FILE Procedures

Downloads files, BLOBS and BFILES


ARPLS71600

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

ARPLS71601Table 239-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

Reader Comment

   

Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

This Page

This Document

New and changed documents:
RSS Feed HTML RSS Feed PDF