17.9 JSON_TO_PROFILE Function

This function converts a file profile in JSON format to an instance of the t_file_profile record type.

Syntax

FUNCTION JSON_TO_PROFILE( p_json inclob ) RETURN t_file_profile;

Parameter

Table 17-6 JSON_TO_PROFILE Parameters

Parameter Description

p_json

The data profile in JSON format.

Returns

Returns the the file profile in JSON format.

Example

declare
    l_profile t_file_profile;
begin
    l_profile := apex_data_parser.json_to_profile( '{"file-type", "csv-delimiter" : "", ... }' );
     
end;