46.2 Constants

AI Tool Constants

The following data format constants are used with AI Tools in APEX_PLUGIN:

subtype t_ai_tool_execution_point is varchar2(21);

c_ai_tool_augment_sys_prompt    constant t_ai_tool_execution_point := 'AUGMENT_SYSTEM_PROMPT';
c_ai_tool_on_demand             constant t_ai_tool_execution_point := 'ON_DEMAND';

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..3;

c_format_xml                constant t_data_format := 1;
c_format_json               constant t_data_format := 2;
c_format_csv                constant t_data_format := 3;

Database Operation Constants

The following database operation 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;

Web Source Parameter Constants

The following Web Source Parameter type 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;

The following Web Source Parameter direction constants are used with REST Data Sources in APEX_PLUGIN:

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 DML row status 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;