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