16.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 16-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
Parent topic: APEX_DATA_LOADING