22.2 データ型

APEX_DATA_PARSERパッケージでは、次のデータ型が使用されます。

汎用

type t_file_profile is record(
    file_type               t_file_type,
    file_charset            VARCHAR2(128),
    row_selector            VARCHAR2(32767),
    is_single_row           BOOLEAN,
    first_row_headings      BOOLEAN,
    xlsx_worksheet          VARCHAR2(128),
    xml_namespaces          VARCHAR2(4000),
    csv_delimiter           VARCHAR2(4),
    csv_enclosed            VARCHAR2(4),
    null_if                 VARCHAR2(20),
    force_trim_whitespace   BOOLEAN,
    skip_rows               PLS_INTEGER,
    file_columns            t_file_columns
);

type t_file_columns is table of t_file_column index by pls_integer;

type t_file_column is record(
    col_seq         PLS_INTEGER,
    name            VARCHAR2(128),
    data_type       apex_exec_api.t_data_type,
    data_type_len   PLS_INTEGER,
    is_json         BOOLEAN,
    selector        VARCHAR2(32767),
    decimal_char    VARCHAR2(4),
    group_char      VARCHAR2(4),
    format_mask     VARCHAR2(128),
    clob_column     PLS_INTEGER
);