Nested table type of varchar2(32767).

Syntax

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

The abstract write attribute.

Syntax

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

Fields

A reference to the object's parent.

Syntax

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

Fields

Base type for the type system.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_base_type_t FORCE AUTHID CURRENT_USER IS OBJECT (
  model_type varchar2(32767),
  key varchar2(32767),
  model_version varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  name varchar2(32767),
  object_status number,
  description varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_base_type_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_base_type_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    object_status number,
    description varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

The configurable properties of an object type.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_config_parameter_definition_t FORCE AUTHID CURRENT_USER IS OBJECT (
  parameter_type dbms_cloud_oci_dataintegration_base_type_t,
  parameter_name varchar2(32767),
  description varchar2(32767),
  default_value json_element_t,
  class_field_name varchar2(32767),
  is_static number,
  is_class_field_value number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_config_parameter_definition_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_config_parameter_definition_t (
    parameter_type dbms_cloud_oci_dataintegration_base_type_t,
    parameter_name varchar2,
    description varchar2,
    default_value json_element_t,
    class_field_name varchar2,
    is_static number,
    is_class_field_value number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The configuration details of a configurable object. This contains one or more config param definitions.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_config_definition_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  model_type varchar2(32767),
  model_version varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  name varchar2(32767),
  is_contained number,
  object_status number,
  config_parameter_definitions json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_config_definition_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_config_definition_t (
    key varchar2,
    model_type varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    is_contained number,
    object_status number,
    config_parameter_definitions json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A `DataType` object is a simple primitive type that describes the type of a single atomic unit of data. For example, `INT`, `VARCHAR`, `NUMBER`, and so on.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_data_type_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_base_type_t (
  dt_type varchar2(32767),
  type_system_name varchar2(32767),
  config_definition dbms_cloud_oci_dataintegration_config_definition_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_data_type_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_data_type_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    object_status number,
    description varchar2,
    dt_type varchar2,
    type_system_name varchar2,
    config_definition dbms_cloud_oci_dataintegration_config_definition_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_data_type_t is a subtype of the dbms_cloud_oci_dataintegration_base_type_t type.

Fields

Nested table type of dbms_cloud_oci_dataintegration_data_type_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_data_type_tbl FORCE IS TABLE OF (dbms_cloud_oci_dataintegration_data_type_t) NOT PERSISTABLE;

The type system maps from and to a type.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_type_system_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  model_type varchar2(32767),
  model_version varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  name varchar2(32767),
  description varchar2(32767),
  object_version number,
  type_mapping_to json_element_t,
  type_mapping_from json_element_t,
  object_status number,
  identifier varchar2(32767),
  types dbms_cloud_oci_dataintegration_data_type_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_type_system_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_type_system_t (
    key varchar2,
    model_type varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    type_mapping_to json_element_t,
    type_mapping_from json_element_t,
    object_status number,
    identifier varchar2,
    types dbms_cloud_oci_dataintegration_data_type_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A summary type containing information about the object's aggregator including its type, key, name and description.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_aggregator_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_type varchar2(32767),
  key varchar2(32767),
  name varchar2(32767),
  identifier varchar2(32767),
  description varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_aggregator_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_aggregator_summary_t (
    l_type varchar2,
    key varchar2,
    name varchar2,
    identifier varchar2,
    description varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details of the count statistic summary object.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_dataintegration_count_statistic_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_count_statistic_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_dataintegration_count_statistic_summary_t) NOT PERSISTABLE;

A count statistics.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_count_statistic_t FORCE AUTHID CURRENT_USER IS OBJECT (
  object_type_count_list dbms_cloud_oci_dataintegration_count_statistic_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_count_statistic_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_count_statistic_t (
    object_type_count_list dbms_cloud_oci_dataintegration_count_statistic_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A summary type containing information about the object including its key, name and when/who created/updated it.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_object_metadata_t FORCE AUTHID CURRENT_USER IS OBJECT (
  created_by varchar2(32767),
  created_by_name varchar2(32767),
  updated_by varchar2(32767),
  updated_by_name varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  aggregator_key varchar2(32767),
  aggregator dbms_cloud_oci_dataintegration_aggregator_summary_t,
  identifier_path varchar2(32767),
  info_fields json_element_t,
  registry_version number,
  labels dbms_cloud_oci_dataintegration_varchar2_tbl,
  is_favorite number,
  count_statistics dbms_cloud_oci_dataintegration_count_statistic_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_object_metadata_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_object_metadata_t (
    created_by varchar2,
    created_by_name varchar2,
    updated_by varchar2,
    updated_by_name varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    aggregator_key varchar2,
    aggregator dbms_cloud_oci_dataintegration_aggregator_summary_t,
    identifier_path varchar2,
    info_fields json_element_t,
    registry_version number,
    labels dbms_cloud_oci_dataintegration_varchar2_tbl,
    is_favorite number,
    count_statistics dbms_cloud_oci_dataintegration_count_statistic_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The schema object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_schema_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  model_type varchar2(32767),
  model_version varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  name varchar2(32767),
  resource_name varchar2(32767),
  description varchar2(32767),
  object_version number,
  external_key varchar2(32767),
  is_has_containers number,
  default_connection varchar2(32767),
  object_status number,
  identifier varchar2(32767),
  metadata dbms_cloud_oci_dataintegration_object_metadata_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_schema_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_schema_t (
    key varchar2,
    model_type varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    resource_name varchar2,
    description varchar2,
    object_version number,
    external_key varchar2,
    is_has_containers number,
    default_connection varchar2,
    object_status number,
    identifier varchar2,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The connection name/value pair.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_dataintegration_connection_property_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_property_tbl FORCE IS TABLE OF (dbms_cloud_oci_dataintegration_connection_property_t) NOT PERSISTABLE;

The connection summary object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  model_type varchar2(32767),
  key varchar2(32767),
  model_version varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  name varchar2(32767),
  description varchar2(32767),
  object_version number,
  object_status number,
  identifier varchar2(32767),
  primary_schema dbms_cloud_oci_dataintegration_schema_t,
  connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
  is_default number,
  metadata dbms_cloud_oci_dataintegration_object_metadata_t,
  key_map json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

The connection details for an Oracle Object Storage data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_summary_from_object_storage_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_summary_t (
  credential_file_content varchar2(32767),
  user_id varchar2(32767),
  finger_print varchar2(32767),
  pass_phrase varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_object_storage_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_object_storage_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    credential_file_content varchar2,
    user_id varchar2,
    finger_print varchar2,
    pass_phrase varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_summary_from_object_storage_t is a subtype of the dbms_cloud_oci_dataintegration_connection_summary_t type.

Fields

The summary object for data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_data_asset_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  model_type varchar2(32767),
  key varchar2(32767),
  model_version varchar2(32767),
  name varchar2(32767),
  description varchar2(32767),
  object_status number,
  identifier varchar2(32767),
  external_key varchar2(32767),
  asset_properties json_element_t,
  native_type_system dbms_cloud_oci_dataintegration_type_system_t,
  object_version number,
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  metadata dbms_cloud_oci_dataintegration_object_metadata_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_data_asset_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_data_asset_summary_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    name varchar2,
    description varchar2,
    object_status number,
    identifier varchar2,
    external_key varchar2,
    asset_properties json_element_t,
    native_type_system dbms_cloud_oci_dataintegration_type_system_t,
    object_version number,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Summary details for the Oracle Object storage data asset type.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_data_asset_summary_from_object_storage_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_data_asset_summary_t (
  oci_region varchar2(32767),
  url varchar2(32767),
  tenancy_id varchar2(32767),
  namespace varchar2(32767),
  default_connection dbms_cloud_oci_dataintegration_connection_summary_from_object_storage_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_data_asset_summary_from_object_storage_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_data_asset_summary_from_object_storage_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    name varchar2,
    description varchar2,
    object_status number,
    identifier varchar2,
    external_key varchar2,
    asset_properties json_element_t,
    native_type_system dbms_cloud_oci_dataintegration_type_system_t,
    object_version number,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    oci_region varchar2,
    url varchar2,
    tenancy_id varchar2,
    namespace varchar2,
    default_connection dbms_cloud_oci_dataintegration_connection_summary_from_object_storage_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_data_asset_summary_from_object_storage_t is a subtype of the dbms_cloud_oci_dataintegration_data_asset_summary_t type.

Fields

Properties to configure reading from a FUSION_APP BIP data asset / connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_bip_call_attribute_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_abstract_call_attribute_t (
  offset_parameter varchar2(32767),
  fetch_next_rows_parameter varchar2(32767),
  staging_data_asset dbms_cloud_oci_dataintegration_data_asset_summary_from_object_storage_t,
  staging_connection dbms_cloud_oci_dataintegration_connection_summary_from_object_storage_t,
  bucket_schema dbms_cloud_oci_dataintegration_schema_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_bip_call_attribute_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_bip_call_attribute_t (
    model_type varchar2,
    fetch_size number,
    offset_parameter varchar2,
    fetch_next_rows_parameter varchar2,
    staging_data_asset dbms_cloud_oci_dataintegration_data_asset_summary_from_object_storage_t,
    staging_connection dbms_cloud_oci_dataintegration_connection_summary_from_object_storage_t,
    bucket_schema dbms_cloud_oci_dataintegration_schema_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_bip_call_attribute_t is a subtype of the dbms_cloud_oci_dataintegration_abstract_call_attribute_t type.

Fields

The information about the data operation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_abstract_data_operation_config_t FORCE AUTHID CURRENT_USER IS OBJECT (
  model_type varchar2(32767),
  metadata_config_properties json_element_t,
  derived_attributes json_element_t,
  call_attribute dbms_cloud_oci_dataintegration_bip_call_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_abstract_data_operation_config_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_abstract_data_operation_config_t (
    model_type varchar2,
    metadata_config_properties json_element_t,
    derived_attributes json_element_t,
    call_attribute dbms_cloud_oci_dataintegration_bip_call_attribute_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Contains the parameter configuration values.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_config_parameter_value_t FORCE AUTHID CURRENT_USER IS OBJECT (
  string_value varchar2(32767),
  int_value number,
  object_value json_element_t,
  ref_value json_element_t,
  parameter_value varchar2(32767),
  root_object_value json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_config_parameter_value_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_config_parameter_value_t (
    string_value varchar2,
    int_value number,
    object_value json_element_t,
    ref_value json_element_t,
    parameter_value varchar2,
    root_object_value json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Configuration values can be string, objects, or parameters.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_config_values_t FORCE AUTHID CURRENT_USER IS OBJECT (
  config_param_values json_element_t,
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_config_values_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_config_values_t (
    config_param_values json_element_t,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The `TypedObject` class is a base class for any model object that has a type.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_typed_object_t FORCE AUTHID CURRENT_USER IS OBJECT (
  model_type varchar2(32767),
  key varchar2(32767),
  model_version varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  config_values dbms_cloud_oci_dataintegration_config_values_t,
  object_status number,
  name varchar2(32767),
  description varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_typed_object_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_typed_object_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    config_values dbms_cloud_oci_dataintegration_config_values_t,
    object_status number,
    name varchar2,
    description varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

The type representing the abstract field concept.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_abstract_field_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_typed_object_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_abstract_field_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_abstract_field_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    config_values dbms_cloud_oci_dataintegration_config_values_t,
    object_status number,
    name varchar2,
    description varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_abstract_field_t is a subtype of the dbms_cloud_oci_dataintegration_typed_object_t type.

The abstract format attribute.

Syntax

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

Fields

The type of the formatted text.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_abstract_formatted_text_t FORCE AUTHID CURRENT_USER IS OBJECT (
  config_values dbms_cloud_oci_dataintegration_config_values_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_abstract_formatted_text_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_abstract_formatted_text_t (
    config_values dbms_cloud_oci_dataintegration_config_values_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The model that holds the frequency details.

Syntax

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

Fields

The abstract read attribute.

Syntax

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

Fields

The abstract write attribute.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_dataintegration_typed_object_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_typed_object_tbl FORCE IS TABLE OF (dbms_cloud_oci_dataintegration_typed_object_t) NOT PERSISTABLE;

The input port details.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_input_port_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_typed_object_t (
  port_type varchar2(32767),
  fields dbms_cloud_oci_dataintegration_typed_object_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_input_port_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_input_port_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    config_values dbms_cloud_oci_dataintegration_config_values_t,
    object_status number,
    name varchar2,
    description varchar2,
    port_type varchar2,
    fields dbms_cloud_oci_dataintegration_typed_object_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_input_port_t is a subtype of the dbms_cloud_oci_dataintegration_typed_object_t type.

Fields

Parameters are created and assigned values that can be configured for each integration task.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_parameter_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_typed_object_t (
  l_type json_element_t,
  default_value json_element_t,
  root_object_default_value json_element_t,
  is_input number,
  is_output number,
  output_aggregation_type varchar2(32767),
  type_name varchar2(32767),
  used_for varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_parameter_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_parameter_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    config_values dbms_cloud_oci_dataintegration_config_values_t,
    object_status number,
    name varchar2,
    description varchar2,
    l_type json_element_t,
    default_value json_element_t,
    root_object_default_value json_element_t,
    is_input number,
    is_output number,
    output_aggregation_type varchar2,
    type_name varchar2,
    used_for varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_parameter_t is a subtype of the dbms_cloud_oci_dataintegration_typed_object_t type.

Fields

The type representing the dynamic proxy field concept. Dynamic proxy fields have a reference to another field.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_dynamic_proxy_field_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_typed_object_t (
  l_type dbms_cloud_oci_dataintegration_base_type_t,
  labels dbms_cloud_oci_dataintegration_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_dynamic_proxy_field_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_dynamic_proxy_field_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    config_values dbms_cloud_oci_dataintegration_config_values_t,
    object_status number,
    name varchar2,
    description varchar2,
    l_type dbms_cloud_oci_dataintegration_base_type_t,
    labels dbms_cloud_oci_dataintegration_varchar2_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_dynamic_proxy_field_t is a subtype of the dbms_cloud_oci_dataintegration_typed_object_t type.

Fields

A `MaterializedCompositeType` represents a type that is composed of a list of sub-types, for example an `Address` type. The sub-types can be simple `DataType` or other `CompositeType` objects. Typically, a `CompositeType` may represent an arbitrarily deep hierarchy of types.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_materialized_composite_type_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_base_type_t (
  elements dbms_cloud_oci_dataintegration_varchar2_tbl,
  path_names dbms_cloud_oci_dataintegration_varchar2_tbl,
  config_definition dbms_cloud_oci_dataintegration_config_definition_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_materialized_composite_type_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_materialized_composite_type_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    object_status number,
    description varchar2,
    elements dbms_cloud_oci_dataintegration_varchar2_tbl,
    path_names dbms_cloud_oci_dataintegration_varchar2_tbl,
    config_definition dbms_cloud_oci_dataintegration_config_definition_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_materialized_composite_type_t is a subtype of the dbms_cloud_oci_dataintegration_base_type_t type.

Fields

A materialized dynamic field, rules have been applied and all fields are concrete.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_materialized_dynamic_field_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_typed_object_t (
  scope varchar2(32767),
  l_type dbms_cloud_oci_dataintegration_materialized_composite_type_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_materialized_dynamic_field_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_materialized_dynamic_field_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    config_values dbms_cloud_oci_dataintegration_config_values_t,
    object_status number,
    name varchar2,
    description varchar2,
    scope varchar2,
    l_type dbms_cloud_oci_dataintegration_materialized_composite_type_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_materialized_dynamic_field_t is a subtype of the dbms_cloud_oci_dataintegration_typed_object_t type.

Fields

Nested table type of dbms_cloud_oci_dataintegration_input_port_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_input_port_tbl FORCE IS TABLE OF (dbms_cloud_oci_dataintegration_input_port_t) NOT PERSISTABLE;

Nested table type of dbms_cloud_oci_dataintegration_parameter_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_parameter_tbl FORCE IS TABLE OF (dbms_cloud_oci_dataintegration_parameter_t) NOT PERSISTABLE;

An operator defines some data integration semantics in a data flow. It may be reading/writing data or transforming the data.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_operator_t FORCE AUTHID CURRENT_USER IS OBJECT (
  model_type varchar2(32767),
  key varchar2(32767),
  model_version varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  name varchar2(32767),
  description varchar2(32767),
  object_version number,
  input_ports dbms_cloud_oci_dataintegration_input_port_tbl,
  output_ports dbms_cloud_oci_dataintegration_typed_object_tbl,
  object_status number,
  identifier varchar2(32767),
  parameters dbms_cloud_oci_dataintegration_parameter_tbl,
  op_config_values dbms_cloud_oci_dataintegration_config_values_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_operator_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_operator_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    input_ports dbms_cloud_oci_dataintegration_input_port_tbl,
    output_ports dbms_cloud_oci_dataintegration_typed_object_tbl,
    object_status number,
    identifier varchar2,
    parameters dbms_cloud_oci_dataintegration_parameter_tbl,
    op_config_values dbms_cloud_oci_dataintegration_config_values_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

The information about the aggregator operator. The aggregate operator performs calculations, like sum or count, on all rows or a group of rows to create new, derivative attributes.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_aggregator_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_operator_t (
  group_by_columns dbms_cloud_oci_dataintegration_dynamic_proxy_field_t,
  materialized_group_by_columns dbms_cloud_oci_dataintegration_materialized_dynamic_field_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_aggregator_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_aggregator_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    input_ports dbms_cloud_oci_dataintegration_input_port_tbl,
    output_ports dbms_cloud_oci_dataintegration_typed_object_tbl,
    object_status number,
    identifier varchar2,
    parameters dbms_cloud_oci_dataintegration_parameter_tbl,
    op_config_values dbms_cloud_oci_dataintegration_config_values_t,
    group_by_columns dbms_cloud_oci_dataintegration_dynamic_proxy_field_t,
    materialized_group_by_columns dbms_cloud_oci_dataintegration_materialized_dynamic_field_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_aggregator_t is a subtype of the dbms_cloud_oci_dataintegration_operator_t type.

Fields

A summary type containing information about the object including its key, name and when/who created/updated it.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_patch_object_metadata_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  name varchar2(32767),
  name_path varchar2(32767),
  l_type varchar2(32767),
  object_version number,
  identifier varchar2(32767),
  action varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_patch_object_metadata_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_patch_object_metadata_t (
    key varchar2,
    name varchar2,
    name_path varchar2,
    l_type varchar2,
    object_version number,
    identifier varchar2,
    action varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The information about the application.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_source_application_info_t FORCE AUTHID CURRENT_USER IS OBJECT (
  workspace_id varchar2(32767),
  application_key varchar2(32767),
  application_version varchar2(32767),
  last_patch_key varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_source_application_info_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_source_application_info_t (
    workspace_id varchar2,
    application_key varchar2,
    application_version varchar2,
    last_patch_key varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_dataintegration_patch_object_metadata_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_patch_object_metadata_tbl FORCE IS TABLE OF (dbms_cloud_oci_dataintegration_patch_object_metadata_t) NOT PERSISTABLE;

The application type contains the audit summary information and the definition of the application.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_application_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  model_type varchar2(32767),
  model_version varchar2(32767),
  name varchar2(32767),
  description varchar2(32767),
  application_version number,
  object_status number,
  identifier varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  object_version number,
  dependent_object_metadata dbms_cloud_oci_dataintegration_patch_object_metadata_tbl,
  published_object_metadata json_element_t,
  source_application_info dbms_cloud_oci_dataintegration_source_application_info_t,
  time_patched timestamp with time zone,
  id varchar2(32767),
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  lifecycle_state varchar2(32767),
  metadata dbms_cloud_oci_dataintegration_object_metadata_t,
  key_map json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_application_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_application_t (
    key varchar2,
    model_type varchar2,
    model_version varchar2,
    name varchar2,
    description varchar2,
    application_version number,
    object_status number,
    identifier varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    object_version number,
    dependent_object_metadata dbms_cloud_oci_dataintegration_patch_object_metadata_tbl,
    published_object_metadata json_element_t,
    source_application_info dbms_cloud_oci_dataintegration_source_application_info_t,
    time_patched timestamp with time zone,
    id varchar2,
    compartment_id varchar2,
    display_name varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    lifecycle_state varchar2,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The information about the application.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_application_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  model_type varchar2(32767),
  model_version varchar2(32767),
  name varchar2(32767),
  description varchar2(32767),
  application_version number,
  object_status number,
  identifier varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  object_version number,
  metadata dbms_cloud_oci_dataintegration_object_metadata_t,
  display_name varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  lifecycle_state varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_application_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_application_details_t (
    key varchar2,
    model_type varchar2,
    model_version varchar2,
    name varchar2,
    description varchar2,
    application_version number,
    object_status number,
    identifier varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    object_version number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    display_name varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    lifecycle_state varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The application summary type contains the audit summary information and the definition of the application.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_application_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  model_type varchar2(32767),
  model_version varchar2(32767),
  name varchar2(32767),
  description varchar2(32767),
  application_version number,
  object_status number,
  identifier varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  object_version number,
  dependent_object_metadata dbms_cloud_oci_dataintegration_patch_object_metadata_tbl,
  published_object_metadata json_element_t,
  source_application_info dbms_cloud_oci_dataintegration_source_application_info_t,
  time_patched timestamp with time zone,
  id varchar2(32767),
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  lifecycle_state varchar2(32767),
  metadata dbms_cloud_oci_dataintegration_object_metadata_t,
  key_map json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_application_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_application_summary_t (
    key varchar2,
    model_type varchar2,
    model_version varchar2,
    name varchar2,
    description varchar2,
    application_version number,
    object_status number,
    identifier varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    object_version number,
    dependent_object_metadata dbms_cloud_oci_dataintegration_patch_object_metadata_tbl,
    published_object_metadata json_element_t,
    source_application_info dbms_cloud_oci_dataintegration_source_application_info_t,
    time_patched timestamp with time zone,
    id varchar2,
    compartment_id varchar2,
    display_name varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    lifecycle_state varchar2,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_dataintegration_application_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_application_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_dataintegration_application_summary_t) NOT PERSISTABLE;

This is the collection of application summaries, it may be a collection of lightweight details or full definitions.

Syntax

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

Fields

Array type object.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_array_type_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_base_type_t (
  element_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_array_type_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_array_type_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    object_status number,
    description varchar2,
    element_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_array_type_t is a subtype of the dbms_cloud_oci_dataintegration_base_type_t type.

Fields

Authentication configuration for Generic REST invocation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_auth_config_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  model_version varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  model_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_auth_config_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_auth_config_t (
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    model_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Authentication type to be used for Generic REST invocation. This is deprecated.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_auth_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  model_version varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  model_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_auth_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_auth_details_t (
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    model_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The AVRO format attribute.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_avro_format_attribute_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_abstract_format_attribute_t (
  compression varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_avro_format_attribute_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_avro_format_attribute_t (
    model_type varchar2,
    is_file_pattern number,
    compression varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_avro_format_attribute_t is a subtype of the dbms_cloud_oci_dataintegration_abstract_format_attribute_t type.

Fields

Marker class for connector attributes.

Syntax

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

Fields

BICC Connector Attribute.Object Storage as External storage where the BICC extracted files are written

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_external_storage_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connector_attribute_t (
  storage_id varchar2(32767),
  storage_name varchar2(32767),
  host varchar2(32767),
  tenancy_id varchar2(32767),
  namespace varchar2(32767),
  bucket varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_external_storage_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_external_storage_t (
    model_type varchar2,
    storage_id varchar2,
    storage_name varchar2,
    host varchar2,
    tenancy_id varchar2,
    namespace varchar2,
    bucket varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_external_storage_t is a subtype of the dbms_cloud_oci_dataintegration_connector_attribute_t type.

Fields

Properties to configure reading from BICC.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_bicc_read_attributes_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_abstract_read_attribute_t (
  fetch_size number,
  extract_strategy varchar2(32767),
  external_storage dbms_cloud_oci_dataintegration_external_storage_t,
  initial_extract_date timestamp with time zone,
  last_extract_date timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_bicc_read_attributes_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_bicc_read_attributes_t (
    model_type varchar2,
    fetch_size number,
    extract_strategy varchar2,
    external_storage dbms_cloud_oci_dataintegration_external_storage_t,
    initial_extract_date timestamp with time zone,
    last_extract_date timestamp with time zone
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_bicc_read_attributes_t is a subtype of the dbms_cloud_oci_dataintegration_abstract_read_attribute_t type.

Fields

Report parameter name and value to be passed for BIP Report extraction.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_dataintegration_bip_report_parameter_value_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_bip_report_parameter_value_tbl FORCE IS TABLE OF (dbms_cloud_oci_dataintegration_bip_report_parameter_value_t) NOT PERSISTABLE;

Properties to configure reading from a FUSION_APP BIP data asset / connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_bip_read_attributes_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_abstract_read_attribute_t (
  fetch_size number,
  row_limit number,
  offset_parameter varchar2(32767),
  fetch_next_rows_parameter varchar2(32767),
  custom_parameters dbms_cloud_oci_dataintegration_bip_report_parameter_value_tbl,
  staging_data_asset dbms_cloud_oci_dataintegration_data_asset_summary_from_object_storage_t,
  staging_connection dbms_cloud_oci_dataintegration_connection_summary_from_object_storage_t,
  bucket_schema dbms_cloud_oci_dataintegration_schema_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_bip_read_attributes_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_bip_read_attributes_t (
    model_type varchar2,
    fetch_size number,
    row_limit number,
    offset_parameter varchar2,
    fetch_next_rows_parameter varchar2,
    custom_parameters dbms_cloud_oci_dataintegration_bip_report_parameter_value_tbl,
    staging_data_asset dbms_cloud_oci_dataintegration_data_asset_summary_from_object_storage_t,
    staging_connection dbms_cloud_oci_dataintegration_connection_summary_from_object_storage_t,
    bucket_schema dbms_cloud_oci_dataintegration_schema_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_bip_read_attributes_t is a subtype of the dbms_cloud_oci_dataintegration_abstract_read_attribute_t type.

Fields

The REST API configuration for cancelling the task.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_cancel_rest_call_config_t FORCE AUTHID CURRENT_USER IS OBJECT (
  method_type varchar2(32767),
  request_headers json_element_t,
  config_values dbms_cloud_oci_dataintegration_config_values_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_cancel_rest_call_config_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_cancel_rest_call_config_t (
    method_type varchar2,
    request_headers json_element_t,
    config_values dbms_cloud_oci_dataintegration_config_values_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The information needed to change the workspace compartment.

Syntax

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

Fields

The information needed to change the DIS Application compartment.

Syntax

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

Fields

Referenced object information.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_dataintegration_reference_used_by_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_reference_used_by_tbl FORCE IS TABLE OF (dbms_cloud_oci_dataintegration_reference_used_by_t) NOT PERSISTABLE;

Child reference contains application configuration information.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_child_reference_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  name varchar2(32767),
  identifier varchar2(32767),
  identifier_path varchar2(32767),
  description varchar2(32767),
  l_type varchar2(32767),
  target_object json_element_t,
  aggregator_key varchar2(32767),
  used_by dbms_cloud_oci_dataintegration_reference_used_by_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_child_reference_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_child_reference_t (
    key varchar2,
    name varchar2,
    identifier varchar2,
    identifier_path varchar2,
    description varchar2,
    l_type varchar2,
    target_object json_element_t,
    aggregator_key varchar2,
    used_by dbms_cloud_oci_dataintegration_reference_used_by_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

References used in an application.

Syntax

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

Fields

A field map is a way to map a source row shape to a target row shape that may be different.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_dataintegration_field_map_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_field_map_tbl FORCE IS TABLE OF (dbms_cloud_oci_dataintegration_field_map_t) NOT PERSISTABLE;

A composite field map.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_composite_field_map_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_field_map_t (
  key varchar2(32767),
  model_version varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  config_values dbms_cloud_oci_dataintegration_config_values_t,
  object_status number,
  field_maps dbms_cloud_oci_dataintegration_field_map_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_composite_field_map_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_composite_field_map_t (
    model_type varchar2,
    description varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    config_values dbms_cloud_oci_dataintegration_config_values_t,
    object_status number,
    field_maps dbms_cloud_oci_dataintegration_field_map_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_composite_field_map_t is a subtype of the dbms_cloud_oci_dataintegration_field_map_t type.

Fields

User defined value for a parameter.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_parameter_value_t FORCE AUTHID CURRENT_USER IS OBJECT (
  simple_value json_element_t,
  root_object_value json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_parameter_value_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_parameter_value_t (
    simple_value json_element_t,
    root_object_value json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

State stored in All States Map of Composite State

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_state_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  parameter_value dbms_cloud_oci_dataintegration_parameter_value_t,
  time_value timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_state_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_state_t (
    name varchar2,
    parameter_value dbms_cloud_oci_dataintegration_parameter_value_t,
    time_value timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Information about the object and its parent.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_registry_metadata_t FORCE AUTHID CURRENT_USER IS OBJECT (
  aggregator_key varchar2(32767),
  labels dbms_cloud_oci_dataintegration_varchar2_tbl,
  registry_version number,
  key varchar2(32767),
  is_favorite number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_registry_metadata_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_registry_metadata_t (
    aggregator_key varchar2,
    labels dbms_cloud_oci_dataintegration_varchar2_tbl,
    registry_version number,
    key varchar2,
    is_favorite number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The composite state object provides information on the state of a task or schedule.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_composite_state_t FORCE AUTHID CURRENT_USER IS OBJECT (
  composite_state_aggregator varchar2(32767),
  key varchar2(32767),
  model_type varchar2(32767),
  model_version varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  name varchar2(32767),
  identifier varchar2(32767),
  description varchar2(32767),
  object_version number,
  object_status number,
  all_states_map json_element_t,
  registry_metadata dbms_cloud_oci_dataintegration_registry_metadata_t,
  metadata dbms_cloud_oci_dataintegration_object_metadata_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_composite_state_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_composite_state_t (
    composite_state_aggregator varchar2,
    key varchar2,
    model_type varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    identifier varchar2,
    description varchar2,
    object_version number,
    object_status number,
    all_states_map json_element_t,
    registry_metadata dbms_cloud_oci_dataintegration_registry_metadata_t,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A `CompositeType` represents a type that is composed of a list of sub-types, for example an `Address` type. The sub-types can be simple `DataType` or other `CompositeType` objects. Typically, a `CompositeType` may represent an arbitrarily deep hierarchy of types.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_composite_type_abs_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_base_type_t (
  elements dbms_cloud_oci_dataintegration_typed_object_tbl,
  config_definition dbms_cloud_oci_dataintegration_config_definition_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_composite_type_abs_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_composite_type_abs_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    object_status number,
    description varchar2,
    elements dbms_cloud_oci_dataintegration_typed_object_tbl,
    config_definition dbms_cloud_oci_dataintegration_config_definition_t
  ) RETURN SELF AS RESULT
) NOT FINAL;

dbms_cloud_oci_dataintegration_composite_type_t is a subtype of the dbms_cloud_oci_dataintegration_base_type_t type.

Fields

A `CompositeType` represents a type that is composed of a list of sub-types, for example an `Address` type. The sub-types can be simple `DataType` or other `CompositeType` objects. Typically, a `CompositeType` may represent an arbitrarily deep hierarchy of types.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_composite_type_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_composite_type_abs_t (
  parent_type dbms_cloud_oci_dataintegration_composite_type_abs_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_composite_type_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_composite_type_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    object_status number,
    description varchar2,
    elements dbms_cloud_oci_dataintegration_typed_object_tbl,
    config_definition dbms_cloud_oci_dataintegration_config_definition_t,
    parent_type dbms_cloud_oci_dataintegration_composite_type_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_composite_type_t is a subtype of the dbms_cloud_oci_dataintegration_composite_type_abs_t type.

Fields

The optional compression configuration.

Syntax

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

Fields

Base type for how fields are projected. There are many different mechanisms for doing this such as by a name pattern, datatype and so on. See the `modelType` property for the types.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_projection_rule_t FORCE AUTHID CURRENT_USER IS OBJECT (
  model_type varchar2(32767),
  key varchar2(32767),
  model_version varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  is_java_regex_syntax number,
  config_values dbms_cloud_oci_dataintegration_config_values_t,
  object_status number,
  description varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_projection_rule_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_projection_rule_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    is_java_regex_syntax number,
    config_values dbms_cloud_oci_dataintegration_config_values_t,
    object_status number,
    description varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Nested table type of dbms_cloud_oci_dataintegration_projection_rule_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_projection_rule_tbl FORCE IS TABLE OF (dbms_cloud_oci_dataintegration_projection_rule_t) NOT PERSISTABLE;

A conditional composite field map.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_conditional_composite_field_map_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_field_map_t (
  field_map_scope dbms_cloud_oci_dataintegration_projection_rule_tbl,
  key varchar2(32767),
  model_version varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  config_values dbms_cloud_oci_dataintegration_config_values_t,
  object_status number,
  field_maps dbms_cloud_oci_dataintegration_field_map_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_conditional_composite_field_map_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_conditional_composite_field_map_t (
    model_type varchar2,
    description varchar2,
    field_map_scope dbms_cloud_oci_dataintegration_projection_rule_tbl,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    config_values dbms_cloud_oci_dataintegration_config_values_t,
    object_status number,
    field_maps dbms_cloud_oci_dataintegration_field_map_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_conditional_composite_field_map_t is a subtype of the dbms_cloud_oci_dataintegration_field_map_t type.

Fields

Details about the link between two data flow operators.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_flow_port_link_t FORCE AUTHID CURRENT_USER IS OBJECT (
  model_type varchar2(32767),
  key varchar2(32767),
  model_version varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  object_status number,
  description varchar2(32767),
  port varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_flow_port_link_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_flow_port_link_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    object_status number,
    description varchar2,
    port varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Details about the outgoing data of an operator in a data flow design.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_output_link_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_flow_port_link_t (
  to_links dbms_cloud_oci_dataintegration_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_output_link_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_output_link_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    object_status number,
    description varchar2,
    port varchar2,
    to_links dbms_cloud_oci_dataintegration_varchar2_tbl
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_output_link_t is a subtype of the dbms_cloud_oci_dataintegration_flow_port_link_t type.

Fields

An expression node.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_expression_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  model_type varchar2(32767),
  model_version varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  expr_string varchar2(32767),
  config_values dbms_cloud_oci_dataintegration_config_values_t,
  object_status number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_expression_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_expression_t (
    key varchar2,
    model_type varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    expr_string varchar2,
    config_values dbms_cloud_oci_dataintegration_config_values_t,
    object_status number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The information about the conditional input link.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_conditional_input_link_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_flow_port_link_t (
  from_link dbms_cloud_oci_dataintegration_output_link_t,
  field_map dbms_cloud_oci_dataintegration_field_map_t,
  condition dbms_cloud_oci_dataintegration_expression_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_conditional_input_link_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_conditional_input_link_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    object_status number,
    description varchar2,
    port varchar2,
    from_link dbms_cloud_oci_dataintegration_output_link_t,
    field_map dbms_cloud_oci_dataintegration_field_map_t,
    condition dbms_cloud_oci_dataintegration_expression_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_conditional_input_link_t is a subtype of the dbms_cloud_oci_dataintegration_flow_port_link_t type.

Fields

The conditional output port details, used in operators such as split.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_conditional_output_port_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_typed_object_t (
  port_type varchar2(32767),
  fields dbms_cloud_oci_dataintegration_typed_object_tbl,
  split_condition dbms_cloud_oci_dataintegration_expression_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_conditional_output_port_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_conditional_output_port_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    config_values dbms_cloud_oci_dataintegration_config_values_t,
    object_status number,
    name varchar2,
    description varchar2,
    port_type varchar2,
    fields dbms_cloud_oci_dataintegration_typed_object_tbl,
    split_condition dbms_cloud_oci_dataintegration_expression_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_conditional_output_port_t is a subtype of the dbms_cloud_oci_dataintegration_typed_object_t type.

Fields

The information about the configuration provider.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_config_provider_abs_t FORCE AUTHID CURRENT_USER IS OBJECT (
  bindings json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_config_provider_abs_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_config_provider_abs_t (
    bindings json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

The information about the configuration provider.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_config_provider_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_config_provider_abs_t (
  child_providers json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_config_provider_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_config_provider_t (
    bindings json_element_t,
    child_providers json_element_t
  ) RETURN SELF AS RESULT
);

Fields

Represents a data source in the Data Integration service.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_data_asset_t FORCE AUTHID CURRENT_USER IS OBJECT (
  model_type varchar2(32767),
  key varchar2(32767),
  model_version varchar2(32767),
  name varchar2(32767),
  description varchar2(32767),
  object_status number,
  identifier varchar2(32767),
  external_key varchar2(32767),
  asset_properties json_element_t,
  native_type_system dbms_cloud_oci_dataintegration_type_system_t,
  object_version number,
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  metadata dbms_cloud_oci_dataintegration_object_metadata_t,
  key_map json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_data_asset_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_data_asset_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    name varchar2,
    description varchar2,
    object_status number,
    identifier varchar2,
    external_key varchar2,
    asset_properties json_element_t,
    native_type_system dbms_cloud_oci_dataintegration_type_system_t,
    object_version number,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

The connection for a data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  model_type varchar2(32767),
  key varchar2(32767),
  model_version varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  name varchar2(32767),
  description varchar2(32767),
  object_version number,
  object_status number,
  identifier varchar2(32767),
  primary_schema dbms_cloud_oci_dataintegration_schema_t,
  connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
  is_default number,
  metadata dbms_cloud_oci_dataintegration_object_metadata_t,
  key_map json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

A key map. If provided, key is replaced with generated key.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_configuration_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  data_asset dbms_cloud_oci_dataintegration_data_asset_t,
  connection dbms_cloud_oci_dataintegration_connection_t,
  compartment_id varchar2(32767),
  schema dbms_cloud_oci_dataintegration_schema_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_configuration_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_configuration_details_t (
    data_asset dbms_cloud_oci_dataintegration_data_asset_t,
    connection dbms_cloud_oci_dataintegration_connection_t,
    compartment_id varchar2,
    schema dbms_cloud_oci_dataintegration_schema_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A `ConfiguredType` represents a type that has built-in configuration to the type itself. An example is a `SSN` type whose basic type is `VARCHAR`, but the type itself also has a built-in configuration like length=10.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_configured_type_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_base_type_t (
  wrapped_type json_element_t,
  config_values dbms_cloud_oci_dataintegration_config_values_t,
  config_definition dbms_cloud_oci_dataintegration_config_definition_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_configured_type_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_configured_type_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    object_status number,
    description varchar2,
    wrapped_type json_element_t,
    config_values dbms_cloud_oci_dataintegration_config_values_t,
    config_definition dbms_cloud_oci_dataintegration_config_definition_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_configured_type_t is a subtype of the dbms_cloud_oci_dataintegration_base_type_t type.

Fields

The connection details for a data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  model_type varchar2(32767),
  key varchar2(32767),
  model_version varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  name varchar2(32767),
  description varchar2(32767),
  object_version number,
  object_status number,
  identifier varchar2(32767),
  primary_schema dbms_cloud_oci_dataintegration_schema_t,
  connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
  is_default number,
  metadata dbms_cloud_oci_dataintegration_object_metadata_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_details_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Secret configuration if used for storing sensitive info

Syntax

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

Fields

The sensitive attribute to be used for sensitive content (for password/wallet).

Syntax

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

Fields

The connection details for an Autonomous Data Warehouse data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_adwc_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_t (
  tns_alias varchar2(32767),
  tns_names dbms_cloud_oci_dataintegration_varchar2_tbl,
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_adwc_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_adwc_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    tns_alias varchar2,
    tns_names dbms_cloud_oci_dataintegration_varchar2_tbl,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_adwc_t is a subtype of the dbms_cloud_oci_dataintegration_connection_t type.

Fields

The connection details for an Autonomous Data Warehouse data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_adwc_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_details_t (
  tns_alias varchar2(32767),
  tns_names dbms_cloud_oci_dataintegration_varchar2_tbl,
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_adwc_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_adwc_details_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    tns_alias varchar2,
    tns_names dbms_cloud_oci_dataintegration_varchar2_tbl,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_adwc_details_t is a subtype of the dbms_cloud_oci_dataintegration_connection_details_t type.

Fields

The connection details for Amazon s3 data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_amazon_s3_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_t (
  access_key dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  secret_key dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_amazon_s3_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_amazon_s3_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    access_key dbms_cloud_oci_dataintegration_sensitive_attribute_t,
    secret_key dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_amazon_s3_t is a subtype of the dbms_cloud_oci_dataintegration_connection_t type.

Fields

The connection details for an Oracle Database data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_amazon_s3_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_details_t (
  access_key dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  secret_key dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_amazon_s3_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_amazon_s3_details_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    access_key dbms_cloud_oci_dataintegration_sensitive_attribute_t,
    secret_key dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_amazon_s3_details_t is a subtype of the dbms_cloud_oci_dataintegration_connection_details_t type.

Fields

The connection details for an Autonomous Transaction Processing data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_atp_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_t (
  tns_alias varchar2(32767),
  tns_names dbms_cloud_oci_dataintegration_varchar2_tbl,
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_atp_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_atp_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    tns_alias varchar2,
    tns_names dbms_cloud_oci_dataintegration_varchar2_tbl,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_atp_t is a subtype of the dbms_cloud_oci_dataintegration_connection_t type.

Fields

The connection details for an Autonomous Transaction Processing data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_atp_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_details_t (
  tns_alias varchar2(32767),
  tns_names dbms_cloud_oci_dataintegration_varchar2_tbl,
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_atp_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_atp_details_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    tns_alias varchar2,
    tns_names dbms_cloud_oci_dataintegration_varchar2_tbl,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_atp_details_t is a subtype of the dbms_cloud_oci_dataintegration_connection_details_t type.

Fields

The connection details for a FUSION_APP BICC Connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_bicc_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_t (
  username varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  default_external_storage dbms_cloud_oci_dataintegration_external_storage_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_bicc_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_bicc_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    username varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
    default_external_storage dbms_cloud_oci_dataintegration_external_storage_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_bicc_t is a subtype of the dbms_cloud_oci_dataintegration_connection_t type.

Fields

The connection details for a FUSION_APP BICC connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_bicc_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_details_t (
  username varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  default_external_storage dbms_cloud_oci_dataintegration_external_storage_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_bicc_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_bicc_details_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    username varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
    default_external_storage dbms_cloud_oci_dataintegration_external_storage_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_bicc_details_t is a subtype of the dbms_cloud_oci_dataintegration_connection_details_t type.

Fields

The connection details for a Fusion applications BIP connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_bip_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_t (
  username varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_bip_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_bip_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    username varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_bip_t is a subtype of the dbms_cloud_oci_dataintegration_connection_t type.

Fields

The connection details for a Fusion applications BIP connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_bip_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_details_t (
  username varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_bip_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_bip_details_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    username varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_bip_details_t is a subtype of the dbms_cloud_oci_dataintegration_connection_details_t type.

Fields

The connection details for the HDFS data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_hdfs_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_t (
  hdfs_principal varchar2(32767),
  data_node_principal varchar2(32767),
  name_node_principal varchar2(32767),
  realm varchar2(32767),
  key_distribution_center varchar2(32767),
  key_tab_content dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_hdfs_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_hdfs_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    hdfs_principal varchar2,
    data_node_principal varchar2,
    name_node_principal varchar2,
    realm varchar2,
    key_distribution_center varchar2,
    key_tab_content dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_hdfs_t is a subtype of the dbms_cloud_oci_dataintegration_connection_t type.

Fields

The connection details for the HDFS data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_hdfs_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_details_t (
  hdfs_principal varchar2(32767),
  data_node_principal varchar2(32767),
  name_node_principal varchar2(32767),
  realm varchar2(32767),
  key_distribution_center varchar2(32767),
  key_tab_content dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_hdfs_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_hdfs_details_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    hdfs_principal varchar2,
    data_node_principal varchar2,
    name_node_principal varchar2,
    realm varchar2,
    key_distribution_center varchar2,
    key_tab_content dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_hdfs_details_t is a subtype of the dbms_cloud_oci_dataintegration_connection_details_t type.

Fields

The connection details for a generic JDBC data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_jdbc_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_t (
  username varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_jdbc_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_jdbc_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    username varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_jdbc_t is a subtype of the dbms_cloud_oci_dataintegration_connection_t type.

Fields

The connection details for a generic JDBC data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_jdbc_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_details_t (
  username varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_jdbc_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_jdbc_details_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    username varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_jdbc_details_t is a subtype of the dbms_cloud_oci_dataintegration_connection_details_t type.

Fields

The connection details for a Lake connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_lake_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_lake_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_lake_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_lake_t is a subtype of the dbms_cloud_oci_dataintegration_connection_t type.

The connection details for a Lake connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_lake_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_lake_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_lake_details_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_lake_details_t is a subtype of the dbms_cloud_oci_dataintegration_connection_details_t type.

The connection details for a MYSQL data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_my_sql_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_t (
  username varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_my_sql_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_my_sql_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    username varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_my_sql_t is a subtype of the dbms_cloud_oci_dataintegration_connection_t type.

Fields

The connection details for a MYSQL data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_my_sql_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_details_t (
  username varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_my_sql_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_my_sql_details_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    username varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_my_sql_details_t is a subtype of the dbms_cloud_oci_dataintegration_connection_details_t type.

Fields

The connection details for a MYSQL HeatWave data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_my_sql_heat_wave_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_t (
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_my_sql_heat_wave_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_my_sql_heat_wave_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_my_sql_heat_wave_t is a subtype of the dbms_cloud_oci_dataintegration_connection_t type.

Fields

The connection details for a MYSQL HeatWave data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_my_sql_heat_wave_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_details_t (
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_my_sql_heat_wave_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_my_sql_heat_wave_details_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_my_sql_heat_wave_details_t is a subtype of the dbms_cloud_oci_dataintegration_connection_details_t type.

Fields

The connection details for an Oracle Object Storage data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_object_storage_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_t (
  credential_file_content varchar2(32767),
  user_id varchar2(32767),
  finger_print varchar2(32767),
  pass_phrase varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_object_storage_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_object_storage_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    credential_file_content varchar2,
    user_id varchar2,
    finger_print varchar2,
    pass_phrase varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_object_storage_t is a subtype of the dbms_cloud_oci_dataintegration_connection_t type.

Fields

The connection summary details for an Oracle Object Storage data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_object_storage_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_details_t (
  credential_file_content varchar2(32767),
  user_id varchar2(32767),
  finger_print varchar2(32767),
  pass_phrase varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_object_storage_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_object_storage_details_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    credential_file_content varchar2,
    user_id varchar2,
    finger_print varchar2,
    pass_phrase varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_object_storage_details_t is a subtype of the dbms_cloud_oci_dataintegration_connection_details_t type.

Fields

The connection details for an Oracle Database data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_oracle_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_t (
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_oracle_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_oracle_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_oracle_t is a subtype of the dbms_cloud_oci_dataintegration_connection_t type.

Fields

The connection details for an Oracle Database data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_oracle_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_details_t (
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_oracle_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_oracle_details_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_oracle_details_t is a subtype of the dbms_cloud_oci_dataintegration_connection_details_t type.

Fields

The connection details for E-Business Suite data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_oracle_ebs_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_t (
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_oracle_ebs_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_oracle_ebs_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_oracle_ebs_t is a subtype of the dbms_cloud_oci_dataintegration_connection_t type.

Fields

The connection details for an E-Business Suite data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_oracle_ebs_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_details_t (
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_oracle_ebs_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_oracle_ebs_details_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_oracle_ebs_details_t is a subtype of the dbms_cloud_oci_dataintegration_connection_details_t type.

Fields

The connection details for an Oracle PeopleSoft data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_oracle_people_soft_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_t (
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_oracle_people_soft_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_oracle_people_soft_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_oracle_people_soft_t is a subtype of the dbms_cloud_oci_dataintegration_connection_t type.

Fields

The connection details for an Oracle PeopleSoft data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_oracle_people_soft_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_details_t (
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_oracle_people_soft_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_oracle_people_soft_details_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_oracle_people_soft_details_t is a subtype of the dbms_cloud_oci_dataintegration_connection_details_t type.

Fields

The connection details for an Oracle Siebel data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_oracle_siebel_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_t (
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_oracle_siebel_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_oracle_siebel_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_oracle_siebel_t is a subtype of the dbms_cloud_oci_dataintegration_connection_t type.

Fields

The connection details for an Oracle Siebel data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_oracle_siebel_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_details_t (
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_oracle_siebel_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_oracle_siebel_details_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_oracle_siebel_details_t is a subtype of the dbms_cloud_oci_dataintegration_connection_details_t type.

Fields

The connection details for a basic auth rest connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_rest_basic_auth_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_t (
  username varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  auth_header varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_rest_basic_auth_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_rest_basic_auth_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    username varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
    auth_header varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_rest_basic_auth_t is a subtype of the dbms_cloud_oci_dataintegration_connection_t type.

Fields

The connection details for a basic auth rest connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_rest_basic_auth_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_details_t (
  username varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  auth_header varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_rest_basic_auth_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_rest_basic_auth_details_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    username varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
    auth_header varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_rest_basic_auth_details_t is a subtype of the dbms_cloud_oci_dataintegration_connection_details_t type.

Fields

The connection details for a no auth rest connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_rest_no_auth_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_rest_no_auth_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_rest_no_auth_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_rest_no_auth_t is a subtype of the dbms_cloud_oci_dataintegration_connection_t type.

The connection details for a no auth rest connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_from_rest_no_auth_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_rest_no_auth_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_from_rest_no_auth_details_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_from_rest_no_auth_details_t is a subtype of the dbms_cloud_oci_dataintegration_connection_details_t type.

Nested table type of dbms_cloud_oci_dataintegration_connection_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_dataintegration_connection_summary_t) NOT PERSISTABLE;

This is the collection of connection summaries, it may be a collection of lightweight details or full definitions.

Syntax

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

Fields

The connection summary details for an Autonomous Data Warehouse data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_summary_from_adwc_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_summary_t (
  tns_alias varchar2(32767),
  tns_names dbms_cloud_oci_dataintegration_varchar2_tbl,
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_adwc_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_adwc_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    tns_alias varchar2,
    tns_names dbms_cloud_oci_dataintegration_varchar2_tbl,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_summary_from_adwc_t is a subtype of the dbms_cloud_oci_dataintegration_connection_summary_t type.

Fields

The connection summary details for Amazons3 data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_summary_from_amazon_s3_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_summary_t (
  access_key dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  secret_key dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_amazon_s3_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_amazon_s3_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    access_key dbms_cloud_oci_dataintegration_sensitive_attribute_t,
    secret_key dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_summary_from_amazon_s3_t is a subtype of the dbms_cloud_oci_dataintegration_connection_summary_t type.

Fields

The connection details for an Autonomous Transaction Processing data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_summary_from_atp_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_summary_t (
  tns_alias varchar2(32767),
  tns_names dbms_cloud_oci_dataintegration_varchar2_tbl,
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_atp_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_atp_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    tns_alias varchar2,
    tns_names dbms_cloud_oci_dataintegration_varchar2_tbl,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_summary_from_atp_t is a subtype of the dbms_cloud_oci_dataintegration_connection_summary_t type.

Fields

The connection summary details for a FUSION_APP BICC connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_summary_from_bicc_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_summary_t (
  username varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_bicc_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_bicc_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    username varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_summary_from_bicc_t is a subtype of the dbms_cloud_oci_dataintegration_connection_summary_t type.

Fields

The connection summary details for a Fusion applications BIP connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_summary_from_bip_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_summary_t (
  username varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_bip_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_bip_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    username varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_summary_from_bip_t is a subtype of the dbms_cloud_oci_dataintegration_connection_summary_t type.

Fields

The connection summary details for the HDFS data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_summary_from_hdfs_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_summary_t (
  hdfs_principal varchar2(32767),
  data_node_principal varchar2(32767),
  name_node_principal varchar2(32767),
  realm varchar2(32767),
  key_distribution_center varchar2(32767),
  key_tab_content dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_hdfs_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_hdfs_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    hdfs_principal varchar2,
    data_node_principal varchar2,
    name_node_principal varchar2,
    realm varchar2,
    key_distribution_center varchar2,
    key_tab_content dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_summary_from_hdfs_t is a subtype of the dbms_cloud_oci_dataintegration_connection_summary_t type.

Fields

The connection details for a generic JDBC data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_summary_from_jdbc_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_summary_t (
  username varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_jdbc_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_jdbc_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    username varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_summary_from_jdbc_t is a subtype of the dbms_cloud_oci_dataintegration_connection_summary_t type.

Fields

The connection summary details for a Lake connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_summary_from_lake_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_summary_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_lake_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_lake_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_summary_from_lake_t is a subtype of the dbms_cloud_oci_dataintegration_connection_summary_t type.

The connection details for a MYSQL data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_summary_from_my_sql_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_summary_t (
  username varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_my_sql_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_my_sql_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    username varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_summary_from_my_sql_t is a subtype of the dbms_cloud_oci_dataintegration_connection_summary_t type.

Fields

The connection details for a MYSQL HeatWave data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_summary_from_my_sql_heat_wave_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_summary_t (
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_my_sql_heat_wave_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_my_sql_heat_wave_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_summary_from_my_sql_heat_wave_t is a subtype of the dbms_cloud_oci_dataintegration_connection_summary_t type.

Fields

The connection summary details for an Oracle Database data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_summary_from_oracle_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_summary_t (
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_oracle_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_oracle_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_summary_from_oracle_t is a subtype of the dbms_cloud_oci_dataintegration_connection_summary_t type.

Fields

The connection summary details for E-Business Suite data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_summary_from_oracle_ebs_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_summary_t (
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_oracle_ebs_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_oracle_ebs_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_summary_from_oracle_ebs_t is a subtype of the dbms_cloud_oci_dataintegration_connection_summary_t type.

Fields

The connection summary details for an Oracle PeopleSoft data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_summary_from_oracle_people_soft_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_summary_t (
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_oracle_people_soft_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_oracle_people_soft_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_summary_from_oracle_people_soft_t is a subtype of the dbms_cloud_oci_dataintegration_connection_summary_t type.

Fields

The connection summary details for an Oracle Siebel data asset.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_summary_from_oracle_siebel_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_summary_t (
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_oracle_siebel_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_oracle_siebel_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_summary_from_oracle_siebel_t is a subtype of the dbms_cloud_oci_dataintegration_connection_summary_t type.

Fields

The connection summary for a basic auth rest connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_summary_from_rest_basic_auth_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_summary_t (
  username varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  auth_header varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_rest_basic_auth_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_rest_basic_auth_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t,
    username varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
    auth_header varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_summary_from_rest_basic_auth_t is a subtype of the dbms_cloud_oci_dataintegration_connection_summary_t type.

Fields

The connection summary for a no auth rest connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_summary_from_rest_no_auth_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_connection_summary_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_rest_no_auth_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_summary_from_rest_no_auth_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    primary_schema dbms_cloud_oci_dataintegration_schema_t,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    is_default number,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t,
    key_map json_element_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_connection_summary_from_rest_no_auth_t is a subtype of the dbms_cloud_oci_dataintegration_connection_summary_t type.

The details of a message.

Syntax

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

Fields

The information about connection validation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_validation_t FORCE AUTHID CURRENT_USER IS OBJECT (
  validation_message dbms_cloud_oci_dataintegration_message_t,
  key varchar2(32767),
  model_type varchar2(32767),
  model_version varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  name varchar2(32767),
  description varchar2(32767),
  object_version number,
  object_status number,
  identifier varchar2(32767),
  metadata dbms_cloud_oci_dataintegration_object_metadata_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_validation_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_validation_t (
    validation_message dbms_cloud_oci_dataintegration_message_t,
    key varchar2,
    model_type varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The information about connection validation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_validation_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  validation_message dbms_cloud_oci_dataintegration_message_t,
  key varchar2(32767),
  model_type varchar2(32767),
  model_version varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  name varchar2(32767),
  description varchar2(32767),
  object_version number,
  object_status number,
  identifier varchar2(32767),
  metadata dbms_cloud_oci_dataintegration_object_metadata_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_validation_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_connection_validation_summary_t (
    validation_message dbms_cloud_oci_dataintegration_message_t,
    key varchar2,
    model_type varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_version number,
    object_status number,
    identifier varchar2,
    metadata dbms_cloud_oci_dataintegration_object_metadata_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_dataintegration_connection_validation_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_connection_validation_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_dataintegration_connection_validation_summary_t) NOT PERSISTABLE;

A list of connection validation summaries.

Syntax

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

Fields

Copy Object Conflict resolution.

Syntax

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

Fields

Details of copied objects.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_copy_object_metadata_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  old_key varchar2(32767),
  new_key varchar2(32767),
  name varchar2(32767),
  identifier varchar2(32767),
  object_type varchar2(32767),
  object_version varchar2(32767),
  aggregator_key varchar2(32767),
  name_path varchar2(32767),
  time_updated_in_millis number,
  resolution_action varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_copy_object_metadata_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_copy_object_metadata_summary_t (
    old_key varchar2,
    new_key varchar2,
    name varchar2,
    identifier varchar2,
    object_type varchar2,
    object_version varchar2,
    aggregator_key varchar2,
    name_path varchar2,
    time_updated_in_millis number,
    resolution_action varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_dataintegration_copy_object_metadata_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_copy_object_metadata_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_dataintegration_copy_object_metadata_summary_t) NOT PERSISTABLE;

Copy metadata object request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_copy_object_request_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  source_workspace_id varchar2(32767),
  object_keys dbms_cloud_oci_dataintegration_varchar2_tbl,
  copy_conflict_resolution dbms_cloud_oci_dataintegration_copy_conflict_resolution_t,
  copy_metadata_object_request_status varchar2(32767),
  created_by varchar2(32767),
  created_by_name varchar2(32767),
  total_source_object_count number,
  total_objects_copied_into_target number,
  time_started_in_millis number,
  time_ended_in_millis number,
  copied_items dbms_cloud_oci_dataintegration_copy_object_metadata_summary_tbl,
  referenced_items dbms_cloud_oci_dataintegration_copy_object_metadata_summary_tbl,
  name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_copy_object_request_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_copy_object_request_t (
    key varchar2,
    source_workspace_id varchar2,
    object_keys dbms_cloud_oci_dataintegration_varchar2_tbl,
    copy_conflict_resolution dbms_cloud_oci_dataintegration_copy_conflict_resolution_t,
    copy_metadata_object_request_status varchar2,
    created_by varchar2,
    created_by_name varchar2,
    total_source_object_count number,
    total_objects_copied_into_target number,
    time_started_in_millis number,
    time_ended_in_millis number,
    copied_items dbms_cloud_oci_dataintegration_copy_object_metadata_summary_tbl,
    referenced_items dbms_cloud_oci_dataintegration_copy_object_metadata_summary_tbl,
    name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Copy metadata object response summary.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_copy_object_request_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  source_workspace_id varchar2(32767),
  object_keys dbms_cloud_oci_dataintegration_varchar2_tbl,
  copy_conflict_resolution dbms_cloud_oci_dataintegration_copy_conflict_resolution_t,
  copy_metadata_object_request_status varchar2(32767),
  created_by varchar2(32767),
  created_by_name varchar2(32767),
  total_source_object_count number,
  total_objects_copied_into_target number,
  time_started_in_millis number,
  time_ended_in_millis number,
  copied_items dbms_cloud_oci_dataintegration_copy_object_metadata_summary_tbl,
  referenced_items dbms_cloud_oci_dataintegration_copy_object_metadata_summary_tbl,
  name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_copy_object_request_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_copy_object_request_summary_t (
    key varchar2,
    source_workspace_id varchar2,
    object_keys dbms_cloud_oci_dataintegration_varchar2_tbl,
    copy_conflict_resolution dbms_cloud_oci_dataintegration_copy_conflict_resolution_t,
    copy_metadata_object_request_status varchar2,
    created_by varchar2,
    created_by_name varchar2,
    total_source_object_count number,
    total_objects_copied_into_target number,
    time_started_in_millis number,
    time_ended_in_millis number,
    copied_items dbms_cloud_oci_dataintegration_copy_object_metadata_summary_tbl,
    referenced_items dbms_cloud_oci_dataintegration_copy_object_metadata_summary_tbl,
    name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_dataintegration_copy_object_request_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_copy_object_request_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_dataintegration_copy_object_request_summary_t) NOT PERSISTABLE;

This is the collection of copy object requests.

Syntax

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

Fields

The information about the application.

Syntax

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

Fields

Properties used in application create operations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_create_application_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  model_version varchar2(32767),
  model_type varchar2(32767),
  name varchar2(32767),
  description varchar2(32767),
  object_status number,
  identifier varchar2(32767),
  display_name varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  lifecycle_state varchar2(32767),
  source_application_info dbms_cloud_oci_dataintegration_create_source_application_info_t,
  registry_metadata dbms_cloud_oci_dataintegration_registry_metadata_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_application_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_application_details_t (
    key varchar2,
    model_version varchar2,
    model_type varchar2,
    name varchar2,
    description varchar2,
    object_status number,
    identifier varchar2,
    display_name varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    lifecycle_state varchar2,
    source_application_info dbms_cloud_oci_dataintegration_create_source_application_info_t,
    registry_metadata dbms_cloud_oci_dataintegration_registry_metadata_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The type to create a config provider.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_create_config_provider_t FORCE AUTHID CURRENT_USER IS OBJECT (
  bindings json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_config_provider_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_config_provider_t (
    bindings json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Properties used in connection create operations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_create_connection_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  model_type varchar2(32767),
  key varchar2(32767),
  model_version varchar2(32767),
  parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
  name varchar2(32767),
  description varchar2(32767),
  object_status number,
  identifier varchar2(32767),
  connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
  registry_metadata dbms_cloud_oci_dataintegration_registry_metadata_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_details_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_status number,
    identifier varchar2,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    registry_metadata dbms_cloud_oci_dataintegration_registry_metadata_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

The details to create an Autonomous Data Warehouse data asset connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_create_connection_from_adwc_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_create_connection_details_t (
  tns_alias varchar2(32767),
  tns_names dbms_cloud_oci_dataintegration_varchar2_tbl,
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_from_adwc_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_from_adwc_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_status number,
    identifier varchar2,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    registry_metadata dbms_cloud_oci_dataintegration_registry_metadata_t,
    tns_alias varchar2,
    tns_names dbms_cloud_oci_dataintegration_varchar2_tbl,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_create_connection_from_adwc_t is a subtype of the dbms_cloud_oci_dataintegration_create_connection_details_t type.

Fields

The details to create a Amazon S3 connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_create_connection_from_amazon_s3_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_create_connection_details_t (
  access_key dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  secret_key dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_from_amazon_s3_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_from_amazon_s3_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_status number,
    identifier varchar2,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    registry_metadata dbms_cloud_oci_dataintegration_registry_metadata_t,
    access_key dbms_cloud_oci_dataintegration_sensitive_attribute_t,
    secret_key dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_create_connection_from_amazon_s3_t is a subtype of the dbms_cloud_oci_dataintegration_create_connection_details_t type.

Fields

The details to create an Autonomous Transaction Processing data asset connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_create_connection_from_atp_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_create_connection_details_t (
  tns_alias varchar2(32767),
  tns_names dbms_cloud_oci_dataintegration_varchar2_tbl,
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_from_atp_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_from_atp_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_status number,
    identifier varchar2,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    registry_metadata dbms_cloud_oci_dataintegration_registry_metadata_t,
    tns_alias varchar2,
    tns_names dbms_cloud_oci_dataintegration_varchar2_tbl,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_create_connection_from_atp_t is a subtype of the dbms_cloud_oci_dataintegration_create_connection_details_t type.

Fields

The connection summary details for a FUSION_APP BICC connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_create_connection_from_bicc_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_create_connection_details_t (
  username varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  default_external_storage dbms_cloud_oci_dataintegration_external_storage_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_from_bicc_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_from_bicc_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_status number,
    identifier varchar2,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    registry_metadata dbms_cloud_oci_dataintegration_registry_metadata_t,
    username varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
    default_external_storage dbms_cloud_oci_dataintegration_external_storage_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_create_connection_from_bicc_t is a subtype of the dbms_cloud_oci_dataintegration_create_connection_details_t type.

Fields

The details to create a Fusion applications BIP connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_create_connection_from_bip_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_create_connection_details_t (
  username varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_from_bip_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_from_bip_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_status number,
    identifier varchar2,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    registry_metadata dbms_cloud_oci_dataintegration_registry_metadata_t,
    username varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_create_connection_from_bip_t is a subtype of the dbms_cloud_oci_dataintegration_create_connection_details_t type.

Fields

The details to create the HDFS data asset connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_create_connection_from_hdfs_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_create_connection_details_t (
  hdfs_principal varchar2(32767),
  data_node_principal varchar2(32767),
  name_node_principal varchar2(32767),
  realm varchar2(32767),
  key_distribution_center varchar2(32767),
  key_tab_content dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_from_hdfs_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_from_hdfs_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_status number,
    identifier varchar2,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    registry_metadata dbms_cloud_oci_dataintegration_registry_metadata_t,
    hdfs_principal varchar2,
    data_node_principal varchar2,
    name_node_principal varchar2,
    realm varchar2,
    key_distribution_center varchar2,
    key_tab_content dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_create_connection_from_hdfs_t is a subtype of the dbms_cloud_oci_dataintegration_create_connection_details_t type.

Fields

The details to create a generic JDBC data asset connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_create_connection_from_jdbc_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_create_connection_details_t (
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_from_jdbc_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_from_jdbc_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_status number,
    identifier varchar2,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    registry_metadata dbms_cloud_oci_dataintegration_registry_metadata_t,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_create_connection_from_jdbc_t is a subtype of the dbms_cloud_oci_dataintegration_create_connection_details_t type.

Fields

The details to create a Lake connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_create_connection_from_lake_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_create_connection_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_from_lake_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_from_lake_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_status number,
    identifier varchar2,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    registry_metadata dbms_cloud_oci_dataintegration_registry_metadata_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_create_connection_from_lake_t is a subtype of the dbms_cloud_oci_dataintegration_create_connection_details_t type.

The details to create a MYSQL data asset connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_create_connection_from_my_sql_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_create_connection_details_t (
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_from_my_sql_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_from_my_sql_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_status number,
    identifier varchar2,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    registry_metadata dbms_cloud_oci_dataintegration_registry_metadata_t,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_create_connection_from_my_sql_t is a subtype of the dbms_cloud_oci_dataintegration_create_connection_details_t type.

Fields

The details to create a MYSQL HeatWave data asset connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_dataintegration_create_connection_from_my_sql_heat_wave_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_dataintegration_create_connection_details_t (
  username varchar2(32767),
  password varchar2(32767),
  password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_from_my_sql_heat_wave_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_dataintegration_create_connection_from_my_sql_heat_wave_t (
    model_type varchar2,
    key varchar2,
    model_version varchar2,
    parent_ref dbms_cloud_oci_dataintegration_parent_reference_t,
    name varchar2,
    description varchar2,
    object_status number,
    identifier varchar2,
    connection_properties dbms_cloud_oci_dataintegration_connection_property_tbl,
    registry_metadata dbms_cloud_oci_dataintegration_registry_metadata_t,
    username varchar2,
    password varchar2,
    password_secret dbms_cloud_oci_dataintegration_sensitive_attribute_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_dataintegration_create_connection_from_my_sql_heat_wave_t is a subtype of the dbms_cloud_oci_dataintegration_create_connection_details_t type.

Fields