14.2 GET_FILE_PROFILE Function

This function returns the file profile (determined by the data loading definition) in JSON format.

Syntax

APEX_DATA_LOADING.GET_FILE_PROFILE (
    p_application_id    IN NUMBER   DEFAULT apex_application.g_flow_id,
    p_static_id         IN VARCHAR2 )
    RETURN CLOB;

Parameters

Table 14-1 GET_FILE_PROFILE Parameters

Parameter	Description
p_application_id	ID of the application which contains the data load definition.
p_static_id	Static ID of the data loading definition to execute.

Example

This example parses and fetches the first 10 columns using a file uploaded from P1_FILE File Browse item and the file profile computed from the data load defintion.

select p.line_number,
    p.col001, p.col002, p.col003, p.col004, p.col005, p.col006, p.col007, p.col008, p.col009, p.col010
    from apex_application_temp_files f,
             table( apex_data_parser.parse(
                  p_content       =>  f.blob_content,
                  p_file_name     =>  f.filename,
                  p_file_profile  =>  apex_data_loading.get_file_profile( p_static_id =>
        'my-load-definition'),
                  p_max_rows      =>  100 ) )
    p where f.name = :P1_FILE