Nested table type of varchar2(32767).

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_varchar2_tbl FORCE IS TABLE OF (varchar2(32767)) NOT PERSISTABLE;

The configuration details for moving a service connector to a different compartment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_change_service_connector_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_change_service_connector_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_change_service_connector_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

An object that represents the source of the flow defined by the service connector. An example source is the VCNFlow logs within the NetworkLogs group. For more information about flows defined by service connectors, see Service Connector Hub Overview. For configuration instructions, see To create a service connector.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_source_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  kind varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_source_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_source_details_t (
    kind varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

An object that represents a task within the flow defined by the service connector. An example task is a filter for error logs. For more information about flows defined by service connectors, see Service Connector Hub Overview. For configuration instructions, see To create a service connector.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_task_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  kind varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_task_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_task_details_t (
    kind varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

An object that represents the target of the flow defined by the service connector. An example target is a stream (Streaming service). For more information about flows defined by service connectors, see Service Connector Hub Overview. For configuration instructions, see To create a service connector.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_target_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  kind varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_target_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_target_details_t (
    kind varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Nested table type of dbms_cloud_oci_sch_task_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_task_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_sch_task_details_t) NOT PERSISTABLE;

The configuration details for creating a service connector.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_create_service_connector_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  description varchar2(32767),
  source dbms_cloud_oci_sch_source_details_t,
  tasks dbms_cloud_oci_sch_task_details_tbl,
  target dbms_cloud_oci_sch_target_details_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_create_service_connector_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_create_service_connector_details_t (
    display_name varchar2,
    compartment_id varchar2,
    description varchar2,
    source dbms_cloud_oci_sch_source_details_t,
    tasks dbms_cloud_oci_sch_task_details_tbl,
    target dbms_cloud_oci_sch_target_details_t,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Instructions for extracting the value corresponding to the specified dimension key: Either extract the value as-is (static) or derive the value from a path (evaluated).

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_dimension_value_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  kind varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_dimension_value_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_dimension_value_details_t (
    kind varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

A dimension name and value.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_dimension_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  dimension_value dbms_cloud_oci_sch_dimension_value_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_dimension_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_dimension_details_t (
    name varchar2,
    dimension_value dbms_cloud_oci_sch_dimension_value_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Error Information.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_error_t FORCE AUTHID CURRENT_USER IS OBJECT (
  code varchar2(32767),
  message varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_error_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_error_t (
    code varchar2,
    message varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The Functions task. Batch input for a function can be limited by either size or time. The first limit reached determines the boundary of the batch. For configuration instructions, see To create a service connector.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_function_task_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_sch_task_details_t (
  function_id varchar2(32767),
  batch_size_in_kbs number,
  batch_time_in_sec number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_function_task_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_function_task_details_t (
    kind varchar2,
    function_id varchar2,
    batch_size_in_kbs number,
    batch_time_in_sec number
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_sch_function_task_details_t is a subtype of the dbms_cloud_oci_sch_task_details_t type.

Fields

The function used for the Functions target. For configuration instructions, see To create a service connector.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_functions_target_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_sch_target_details_t (
  function_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_functions_target_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_functions_target_details_t (
    kind varchar2,
    function_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_sch_functions_target_details_t is a subtype of the dbms_cloud_oci_sch_target_details_t type.

Fields

Evaluated type of dimension value.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_jmes_path_dimension_value_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_sch_dimension_value_details_t (
  path varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_jmes_path_dimension_value_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_jmes_path_dimension_value_t (
    kind varchar2,
    path varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_sch_jmes_path_dimension_value_t is a subtype of the dbms_cloud_oci_sch_dimension_value_details_t type.

Fields

The type of cursor, which determines the starting point from which the stream will be consumed.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_streaming_cursor_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  kind varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_streaming_cursor_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_streaming_cursor_details_t (
    kind varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

`LATEST` cursor type. Sets the starting point for consuming the stream at messages published after saving the service connector. For more information about Streaming cursors, see Using Cursors.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_latest_streaming_cursor_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_sch_streaming_cursor_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_latest_streaming_cursor_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_latest_streaming_cursor_t (
    kind varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_sch_latest_streaming_cursor_t is a subtype of the dbms_cloud_oci_sch_streaming_cursor_details_t type.

The log rule task. For configuration instructions, see To create a service connector.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_log_rule_task_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_sch_task_details_t (
  condition varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_log_rule_task_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_log_rule_task_details_t (
    kind varchar2,
    condition varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_sch_log_rule_task_details_t is a subtype of the dbms_cloud_oci_sch_task_details_t type.

Fields

The logs for this Logging source.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_log_source_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  log_group_id varchar2(32767),
  log_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_log_source_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_log_source_t (
    compartment_id varchar2,
    log_group_id varchar2,
    log_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The log group used for the Logging Analytics target. For configuration instructions, see To create a service connector.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_logging_analytics_target_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_sch_target_details_t (
  log_group_id varchar2(32767),
  log_source_identifier varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_logging_analytics_target_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_logging_analytics_target_details_t (
    kind varchar2,
    log_group_id varchar2,
    log_source_identifier varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_sch_logging_analytics_target_details_t is a subtype of the dbms_cloud_oci_sch_target_details_t type.

Fields

Nested table type of dbms_cloud_oci_sch_log_source_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_log_source_tbl FORCE IS TABLE OF (dbms_cloud_oci_sch_log_source_t) NOT PERSISTABLE;

The Logging source. For configuration instructions, see To create a service connector.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_logging_source_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_sch_source_details_t (
  log_sources dbms_cloud_oci_sch_log_source_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_logging_source_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_logging_source_details_t (
    kind varchar2,
    log_sources dbms_cloud_oci_sch_log_source_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_sch_logging_source_details_t is a subtype of the dbms_cloud_oci_sch_source_details_t type.

Fields

Discriminator for namespaces in the compartment-specific list.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_monitoring_source_namespace_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  kind varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_monitoring_source_namespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_monitoring_source_namespace_details_t (
    kind varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

A compartment-specific list of metric namespaces to retrieve data from.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_monitoring_source_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  namespace_details dbms_cloud_oci_sch_monitoring_source_namespace_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_monitoring_source_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_monitoring_source_t (
    compartment_id varchar2,
    namespace_details dbms_cloud_oci_sch_monitoring_source_namespace_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The metrics to query for the specified metric namespace.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_monitoring_source_metric_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  kind varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_monitoring_source_metric_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_monitoring_source_metric_details_t (
    kind varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Discriminator for metrics in the compartment-specific list.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_monitoring_source_all_metrics_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_sch_monitoring_source_metric_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_monitoring_source_all_metrics_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_monitoring_source_all_metrics_t (
    kind varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_sch_monitoring_source_all_metrics_t is a subtype of the dbms_cloud_oci_sch_monitoring_source_metric_details_t type.

Nested table type of dbms_cloud_oci_sch_monitoring_source_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_monitoring_source_tbl FORCE IS TABLE OF (dbms_cloud_oci_sch_monitoring_source_t) NOT PERSISTABLE;

The Monitoring source. For configuration instructions, see To create a service connector.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_monitoring_source_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_sch_source_details_t (
  monitoring_sources dbms_cloud_oci_sch_monitoring_source_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_monitoring_source_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_monitoring_source_details_t (
    kind varchar2,
    monitoring_sources dbms_cloud_oci_sch_monitoring_source_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_sch_monitoring_source_details_t is a subtype of the dbms_cloud_oci_sch_source_details_t type.

Fields

A metric namespace for the compartment-specific list.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_monitoring_source_selected_namespace_t FORCE AUTHID CURRENT_USER IS OBJECT (
  namespace varchar2(32767),
  metrics dbms_cloud_oci_sch_monitoring_source_metric_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_monitoring_source_selected_namespace_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_monitoring_source_selected_namespace_t (
    namespace varchar2,
    metrics dbms_cloud_oci_sch_monitoring_source_metric_details_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_sch_monitoring_source_selected_namespace_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_monitoring_source_selected_namespace_tbl FORCE IS TABLE OF (dbms_cloud_oci_sch_monitoring_source_selected_namespace_t) NOT PERSISTABLE;

The namespaces for the compartment-specific list.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_monitoring_source_selected_namespace_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_sch_monitoring_source_namespace_details_t (
  namespaces dbms_cloud_oci_sch_monitoring_source_selected_namespace_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_monitoring_source_selected_namespace_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_monitoring_source_selected_namespace_details_t (
    kind varchar2,
    namespaces dbms_cloud_oci_sch_monitoring_source_selected_namespace_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_sch_monitoring_source_selected_namespace_details_t is a subtype of the dbms_cloud_oci_sch_monitoring_source_namespace_details_t type.

Fields

Nested table type of dbms_cloud_oci_sch_dimension_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_dimension_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_sch_dimension_details_t) NOT PERSISTABLE;

The metric and metric namespace used for the Monitoring target. For configuration instructions, see To create a service connector.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_monitoring_target_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_sch_target_details_t (
  compartment_id varchar2(32767),
  metric_namespace varchar2(32767),
  metric varchar2(32767),
  dimensions dbms_cloud_oci_sch_dimension_details_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_monitoring_target_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_monitoring_target_details_t (
    kind varchar2,
    compartment_id varchar2,
    metric_namespace varchar2,
    metric varchar2,
    dimensions dbms_cloud_oci_sch_dimension_details_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_sch_monitoring_target_details_t is a subtype of the dbms_cloud_oci_sch_target_details_t type.

Fields

The topic used for the Notifications target. For configuration instructions, see To create a service connector.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_notifications_target_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_sch_target_details_t (
  topic_id varchar2(32767),
  enable_formatted_messaging number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_notifications_target_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_notifications_target_details_t (
    kind varchar2,
    topic_id varchar2,
    enable_formatted_messaging number
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_sch_notifications_target_details_t is a subtype of the dbms_cloud_oci_sch_target_details_t type.

Fields

The bucket used for the Object Storage target. For configuration instructions, see To create a service connector.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_object_storage_target_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_sch_target_details_t (
  namespace varchar2(32767),
  bucket_name varchar2(32767),
  object_name_prefix varchar2(32767),
  batch_rollover_size_in_m_bs number,
  batch_rollover_time_in_ms number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_object_storage_target_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_object_storage_target_details_t (
    kind varchar2,
    namespace varchar2,
    bucket_name varchar2,
    object_name_prefix varchar2,
    batch_rollover_size_in_m_bs number,
    batch_rollover_time_in_ms number
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_sch_object_storage_target_details_t is a subtype of the dbms_cloud_oci_sch_target_details_t type.

Fields

The configuration details of the flow defined by the service connector. For more information about flows defined by service connectors, see Service Connector Hub Overview.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_service_connector_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecyle_details varchar2(32767),
  source dbms_cloud_oci_sch_source_details_t,
  tasks dbms_cloud_oci_sch_task_details_tbl,
  target dbms_cloud_oci_sch_target_details_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_service_connector_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_service_connector_t (
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecyle_details varchar2,
    source dbms_cloud_oci_sch_source_details_t,
    tasks dbms_cloud_oci_sch_task_details_tbl,
    target dbms_cloud_oci_sch_target_details_t,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A summary of properties for the specified service connector.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_service_connector_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_service_connector_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_service_connector_summary_t (
    id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_sch_service_connector_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_service_connector_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_sch_service_connector_summary_t) NOT PERSISTABLE;

Collection of service connector property summaries.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_service_connector_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_sch_service_connector_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_service_connector_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_service_connector_collection_t (
    items dbms_cloud_oci_sch_service_connector_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Static type of dimension value (passed as-is).

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_static_dimension_value_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_sch_dimension_value_details_t (
  value varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_static_dimension_value_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_static_dimension_value_t (
    kind varchar2,
    value varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_sch_static_dimension_value_t is a subtype of the dbms_cloud_oci_sch_dimension_value_details_t type.

Fields

The Streaming source.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_streaming_source_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_sch_source_details_t (
  stream_id varchar2(32767),
  l_cursor dbms_cloud_oci_sch_streaming_cursor_details_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_streaming_source_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_streaming_source_details_t (
    kind varchar2,
    stream_id varchar2,
    l_cursor dbms_cloud_oci_sch_streaming_cursor_details_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_sch_streaming_source_details_t is a subtype of the dbms_cloud_oci_sch_source_details_t type.

Fields

The stream used for the Streaming target. For configuration instructions, see To create a service connector.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_streaming_target_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_sch_target_details_t (
  stream_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_streaming_target_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_streaming_target_details_t (
    kind varchar2,
    stream_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_sch_streaming_target_details_t is a subtype of the dbms_cloud_oci_sch_target_details_t type.

Fields

`TRIM_HORIZON` cursor type. Sets the starting point for consuming the stream at the oldest available message in the stream. For more information about Streaming cursors, see Using Cursors.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_trim_horizon_streaming_cursor_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_sch_streaming_cursor_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_trim_horizon_streaming_cursor_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_trim_horizon_streaming_cursor_t (
    kind varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_sch_trim_horizon_streaming_cursor_t is a subtype of the dbms_cloud_oci_sch_streaming_cursor_details_t type.

The configuration details for updating a service connector.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_update_service_connector_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  description varchar2(32767),
  source dbms_cloud_oci_sch_source_details_t,
  tasks dbms_cloud_oci_sch_task_details_tbl,
  target dbms_cloud_oci_sch_target_details_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_update_service_connector_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_update_service_connector_details_t (
    display_name varchar2,
    description varchar2,
    source dbms_cloud_oci_sch_source_details_t,
    tasks dbms_cloud_oci_sch_task_details_tbl,
    target dbms_cloud_oci_sch_target_details_t,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A resource created or operated on by a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_work_request_resource_t FORCE AUTHID CURRENT_USER IS OBJECT (
  entity_type varchar2(32767),
  action_type varchar2(32767),
  identifier varchar2(32767),
  entity_uri varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_work_request_resource_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_work_request_resource_t (
    entity_type varchar2,
    action_type varchar2,
    identifier varchar2,
    entity_uri varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_sch_work_request_resource_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_work_request_resource_tbl FORCE IS TABLE OF (dbms_cloud_oci_sch_work_request_resource_t) NOT PERSISTABLE;

An object representing an asynchronous work flow. Many of the API requests you use to create and configure service connectors do not take effect immediately. In these cases, the request spawns an asynchronous work flow to fulfill the request. WorkRequest objects provide visibility for in-progress work flows. For more information about work requests, see Viewing the State of a Work Request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_work_request_t FORCE AUTHID CURRENT_USER IS OBJECT (
  operation_type varchar2(32767),
  status varchar2(32767),
  id varchar2(32767),
  compartment_id varchar2(32767),
  resources dbms_cloud_oci_sch_work_request_resource_tbl,
  percent_complete number,
  time_accepted timestamp with time zone,
  time_started timestamp with time zone,
  time_finished timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_work_request_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_work_request_t (
    operation_type varchar2,
    status varchar2,
    id varchar2,
    compartment_id varchar2,
    resources dbms_cloud_oci_sch_work_request_resource_tbl,
    percent_complete number,
    time_accepted timestamp with time zone,
    time_started timestamp with time zone,
    time_finished timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_sch_work_request_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_work_request_tbl FORCE IS TABLE OF (dbms_cloud_oci_sch_work_request_t) NOT PERSISTABLE;

Collection of work requests.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_work_request_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_sch_work_request_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_work_request_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_work_request_collection_t (
    items dbms_cloud_oci_sch_work_request_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

An error encountered while executing a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_work_request_error_t FORCE AUTHID CURRENT_USER IS OBJECT (
  code varchar2(32767),
  message varchar2(32767),
  l_timestamp timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_work_request_error_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_work_request_error_t (
    code varchar2,
    message varchar2,
    l_timestamp timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_sch_work_request_error_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_work_request_error_tbl FORCE IS TABLE OF (dbms_cloud_oci_sch_work_request_error_t) NOT PERSISTABLE;

Collection of work request errors.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_work_request_error_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_sch_work_request_error_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_work_request_error_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_work_request_error_collection_t (
    items dbms_cloud_oci_sch_work_request_error_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A log message from the execution of a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_work_request_log_entry_t FORCE AUTHID CURRENT_USER IS OBJECT (
  message varchar2(32767),
  l_timestamp timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_work_request_log_entry_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_work_request_log_entry_t (
    message varchar2,
    l_timestamp timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_sch_work_request_log_entry_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_work_request_log_entry_tbl FORCE IS TABLE OF (dbms_cloud_oci_sch_work_request_log_entry_t) NOT PERSISTABLE;

Collection of work request logs.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_sch_work_request_log_entry_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_sch_work_request_log_entry_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_work_request_log_entry_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_sch_work_request_log_entry_collection_t (
    items dbms_cloud_oci_sch_work_request_log_entry_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields