15.2 Data Types

The APEX_DATA_EXPORT package uses the following data types.

Generic

subtype t_alignment             is varchar2(255);
subtype t_label                 is varchar2(255);
subtype t_color                 is varchar2(4000);
subtype t_format                is varchar2(20);
subtype t_content_disposition   is varchar2(30);
subtype t_unit                  is varchar2(4000);
subtype t_size                  is varchar2(4000);
subtype t_width_unit            is varchar2(255);
subtype t_orientation           is varchar2(4000);
subtype t_font_family           is varchar2(4000);
subtype t_font_weight           is varchar2(4000);

Resulting Object of an Export

type t_export is record (
    file_name               varchar2(32767),
    format                  t_format,
    mime_type               varchar2(32767),
    as_clob                 boolean,
    content_blob            blob,
    content_clob            clob );

Column Groups

type t_column_group is record (
    name                    varchar2(255),
    alignment               t_alignment,
    parent_group_idx        pls_integer );

type t_column_groups        is table of t_column_group  index by pls_integer;

Columns

type t_column is record (
    name                    apex_exec.t_column_name,
    heading                 varchar2(255),
    format_mask             varchar2(4000),
    heading_alignment       t_alignment,
    value_alignment         t_alignment,
    width                   number,
    is_column_break         boolean,
    is_frozen               boolean,
    column_group_idx        pls_integer );

type t_columns              is table of t_column        index by pls_integer;

Highlights

type t_highlight is record (
    id                      number,
    name                    varchar2(4000),
    value_column            apex_exec.t_column_name,
    display_column          apex_exec.t_column_name,
    text_color              t_color,
    background_color        t_color );

type t_highlights           is table of t_highlight     index by pls_integer;

Aggregates

type t_aggregate is record (
    label                   t_label,
    format_mask             varchar2(4000),
    display_column          apex_exec.t_column_name,
    value_column            apex_exec.t_column_name,
    overall_label           t_label,
    overall_value_column    apex_exec.t_column_name );

type t_aggregates           is table of t_aggregate     index by pls_integer;

Print Config

type t_print_config is record (
    units                       t_unit,
    paper_size                  t_size,
    width_units                 t_width_unit,
    width                       number,
    height                      number,
    orientation                 t_orientation,
    page_header                 varchar2(4000),
    page_header_font_color      t_color,
    page_header_font_family     t_font_family,
    page_header_font_weight     t_font_weight,
    page_header_font_size       varchar2(4000),
    page_header_alignment       t_alignment,
    page_footer                 varchar2(4000),
    page_footer_font_color      t_color,
    page_footer_font_family     t_font_family,
    page_footer_font_weight     t_font_weight,
    page_footer_font_size       varchar2(4000),
    page_footer_alignment       t_alignment,
    header_bg_color             t_color,
    header_font_color           t_color,
    header_font_family          t_font_family,
    header_font_weight          t_font_weight,
    header_font_size            varchar2(4000),
    body_bg_color               t_color,
    body_font_color             t_color,
    body_font_family            t_font_family,
    body_font_weight            t_font_weight,
    body_font_size              varchar2(4000),
    border_width                number,
    border_color                t_color );