Constants and Data Types

The APEX_EXPORT package uses the following constants.

c_type_apexlang           constant t_export_type := 'APEXLANG';
c_type_sql                constant t_export_type := 'SQL';
c_type_embedded_code      constant t_export_type := 'EMBEDDED_CODE';
c_type_checksum_sh1       constant t_export_type := 'CHECKSUM-SH1';
c_type_checksum_sh256     constant t_export_type := 'CHECKSUM-SH256';
c_audit_dates_only        constant t_audit_type  := 'DATES_ONLY';
c_audit_names_dates       constant t_audit_type  := 'NAMES_AND_DATES';

The APEX_EXPORT package uses the following data types.

type t_export_file is object (
   name                    varchar2(1024),
   contents                clob,
   contents_blob           blob,
   component_display_name  varchar2(1024),
   component_type          varchar2(255),
   component_type_label    varchar2(1024),
   component_id            varchar2(255) );

type t_export_files is table of t_export_file;

subtype t_export_type     is varchar2( 255 );
subtype t_audit_type      is varchar2( 255 );

Note: contents_blob is for binary file export and only is used when using APEXLANG application export. Either contents or contents_blob must always have a value, but never both at the same time. contents_blob only has a value if contents is null and vice versa. You need to conditionally check if consuming this type.