34.2 Constants Used by APEX_PLUGIN

Data Format Constants

The following data format constants are used with REST Data Sources in APEX_PLUGIN:

subtype t_data_format           is pls_integer range 1..2;
 
c_format_xml                constant t_data_format := 1;
c_format_json               constant t_data_format := 2;

Database Operation Constants

The following constants are used with REST Data Sources in APEX_PLUGIN:

subtype t_db_operation          is pls_integer range 1..6;
  
c_db_operation_fetch_rows   constant t_db_operation          := 1;
c_db_operation_insert       constant t_db_operation          := 2;
c_db_operation_update       constant t_db_operation          := 3;
c_db_operation_delete       constant t_db_operation          := 4;
c_db_operation_fetch_row    constant t_db_operation          := 5;
c_db_operation_execute      constant t_db_operation          := 6;

REST Data Source Parameter Constants

The following constants are used with REST Data Sources in APEX_PLUGIN:

subtype t_web_source_param_type is pls_integer range 1..5;
  
c_web_src_param_header      constant t_web_source_param_type := 1;
c_web_src_param_query       constant t_web_source_param_type := 2;
c_web_src_param_url_pattern constant t_web_source_param_type := 3;
c_web_src_param_body        constant t_web_source_param_type := 4;
c_web_src_param_cookie      constant t_web_source_param_type := 5;
 
subtype t_web_source_param_dir is pls_integer range 1..3;
 
 
c_direction_in              constant t_web_source_param_dir  := 1;
c_direction_out             constant t_web_source_param_dir  := 2;
c_direction_in_out          constant t_web_source_param_dir  := 3;

REST Data Source DML Row Status Constants

The following constants are used with REST Data Sources in APEX_PLUGIN:

subtype t_web_source_row_check_result is pls_integer range 1..5;
 
c_row_ok                    constant t_web_source_row_check_result := 1;
c_row_version_changed       constant t_web_source_row_check_result := 2;
c_row_data_not_changed      constant t_web_source_row_check_result := 3;
c_row_refetch_error         constant t_web_source_row_check_result := 4;
c_row_dml_not_allowed       constant t_web_source_row_check_result := 5;