GET_FILE_CONTENT Function

This function returns the BLOB of a file contained in a provided zip file.

Syntax

APEX_ZIP.GET_FILE_CONTENT (
    p_zipped_blob IN BLOB,
    p_file_name   IN VARCHAR2,
    p_encoding    IN VARCHAR2 DEFAULT NULL )
RETURN BLOB;

Parameters

Table 37-3 GET_FILE_CONTENT Function Parameters

Parameter Description

p_zipped_blob

This is the BLOB containing the zip file.

p_file_name

File name, including path, of a file located in the zip file.

p_encoding

Encoding used to zip the file.

Returns

Table 37-4 GET_FILE_CONTENT Function Returns

Return Description

BLOB

BLOB containing the zip file.

Example

See "GET_FILES Function" for an example.