37.4 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.

Parent topic: APEX_ZIP