Oracle Cloud Infrastructure Documentation
Try Free Tier

EM Warehouse Common Types

DBMS_CLOUD_OCI_EM_WAREHOUSE_VARCHAR2_TBL Type

Nested table type of varchar2(32767).

Syntax

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

DBMS_CLOUD_OCI_EM_WAREHOUSE_CHANGE_EM_WAREHOUSE_COMPARTMENT_DETAILS_T Type

The information to be updated.

Syntax

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

Fields

Field Description

compartment_id

(required) The OCID of the compartment into which the resource should be moved.

DBMS_CLOUD_OCI_EM_WAREHOUSE_CREATE_EM_WAREHOUSE_DETAILS_T Type

The information about new EmWarehouse.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_create_em_warehouse_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  em_bridge_id varchar2(32767),
  compartment_id varchar2(32767),
  operations_insights_warehouse_id varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_create_em_warehouse_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_create_em_warehouse_details_t (
    display_name varchar2,
    em_bridge_id varchar2,
    compartment_id varchar2,
    operations_insights_warehouse_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

display_name

(optional) EmWarehouse Identifier

em_bridge_id

(required) EMBridge Identifier

compartment_id

(required) Compartment Identifier

operations_insights_warehouse_id

(required) operations Insights Warehouse Identifier

freeform_tags

(optional) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: `{\"bar-key\": \"value\"}`

defined_tags

(optional) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: `{\"foo-namespace\": {\"bar-key\": \"value\"}}`

DBMS_CLOUD_OCI_EM_WAREHOUSE_EM_INSTANCES_DETAILS_T Type

Results of a emWarehouse search. Contains boh EmWarehouseSummary items and other information, such as metadata.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_em_instances_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  em_id varchar2(32767),
  targets_count number,
  em_host varchar2(32767),
  em_discoverer_url varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_em_instances_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_em_instances_details_t (
    em_id varchar2,
    targets_count number,
    em_host varchar2,
    em_discoverer_url varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

em_id

(required) operations Insights Warehouse Identifier

targets_count

(optional) EmInstance Target count

em_host

(optional) emHost name

em_discoverer_url

(optional) emdDiscoverer url

DBMS_CLOUD_OCI_EM_WAREHOUSE_EM_WAREHOUSE_T Type

Description of EmWarehouse.

Syntax

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

Fields

Field Description

operations_insights_warehouse_id

(required) operations Insights Warehouse Identifier

latest_etl_run_status

(optional) Data Flow Run Status

latest_etl_run_message

(optional) Data Flow Run Status Message

latest_etl_run_time

(optional) Data Flow Run Total Time

id

(required) Unique identifier that is immutable on creation

display_name

(required) EmWarehouse Identifier, can be renamed

compartment_id

(required) Compartment Identifier

em_warehouse_type

(required) Type of the EmWarehouse.

em_bridge_id

(optional) EMBridge Identifier

time_created

(required) The time the the EmWarehouse was created. An RFC3339 formatted datetime string

time_updated

(optional) The time the EmWarehouse was updated. An RFC3339 formatted datetime string

lifecycle_state

(required) The current state of the EmWarehouse.

Allowed values are: 'CREATING', 'UPDATING', 'ACTIVE', 'DELETING', 'DELETED', 'FAILED'

lifecycle_details

(optional) A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.

freeform_tags

(required) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: `{\"bar-key\": \"value\"}`

defined_tags

(required) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: `{\"foo-namespace\": {\"bar-key\": \"value\"}}`

system_tags

(optional) Usage of system tag keys. These predefined keys are scoped to namespaces. Example: `{\"orcl-cloud\": {\"free-tier-retained\": \"true\"}}`

DBMS_CLOUD_OCI_EM_WAREHOUSE_EM_WAREHOUSE_SUMMARY_T Type

Summary of the EmWarehouse.

Syntax

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

Fields

Field Description

operations_insights_warehouse_id

(required) operations Insights Warehouse Identifier

id

(required) Unique identifier that is immutable on creation

display_name

(required) EmWarehouse Identifier, can be renamed

compartment_id

(required) Compartment Identifier

em_warehouse_type

(required) Type of the EmWarehouse.

em_bridge_id

(optional) EMBridge Identifier

latest_etl_run_status

(optional) Data Flow Run Status

latest_etl_run_message

(optional) Data Flow Run Status Message

latest_etl_run_time

(optional) Data Flow Run Total Time

time_created

(required) The time the the EmWarehouse was created. An RFC3339 formatted datetime string

time_updated

(optional) The time the EmWarehouse was updated. An RFC3339 formatted datetime string

lifecycle_state

(required) The current state of the EmWarehouse.

lifecycle_details

(optional) A message describing the current state in more detail. For example, can be used to provide actionable information for a resource in Failed state.

freeform_tags

(required) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: `{\"bar-key\": \"value\"}`

defined_tags

(required) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: `{\"foo-namespace\": {\"bar-key\": \"value\"}}`

system_tags

(optional) Usage of system tag keys. These predefined keys are scoped to namespaces. Example: `{\"orcl-cloud\": {\"free-tier-retained\": \"true\"}}`

DBMS_CLOUD_OCI_EM_WAREHOUSE_EM_WAREHOUSE_SUMMARY_TBL Type

Nested table type of dbms_cloud_oci_em_warehouse_em_warehouse_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_em_warehouse_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_em_warehouse_em_warehouse_summary_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_EM_WAREHOUSE_EM_WAREHOUSE_COLLECTION_T Type

Results of a emWarehouse search. Contains boh EmWarehouseSummary items and other information, such as metadata.

Syntax

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

Fields

Field Description

items

(required) List of emWarehouses.

DBMS_CLOUD_OCI_EM_WAREHOUSE_ERROR_T Type

Error Information.

Syntax

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

Fields

Field Description

code

(required) A short error code that defines the error, meant for programmatic parsing.

message

(required) A human-readable error string.

DBMS_CLOUD_OCI_EM_WAREHOUSE_ETL_RUN_SUMMARY_T Type

Contains summary of a run.

Syntax

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

Fields

Field Description

compartment_id

(required) Compartment Identifier

data_read_in_bytes

(optional) Data read by the dataflow run

data_written

(optional) Data written by the dataflow run

lifecycle_state

(optional) The current state of the etlRun.

Allowed values are: 'ACCEPTED', 'IN_PROGRESS', 'CANCELING', 'CANCELED', 'FAILED', 'SUCCEEDED'

display_name

(optional) The name of the ETLRun.

lifecycle_details

(optional) Details of the lifecycle state

run_duration_in_milliseconds

(optional) Dataflow run duration

time_created

(optional) Time when the dataflow run was created

time_updated

(optional) Time when the dataflow run was updated

freeform_tags

(optional) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: `{\"bar-key\": \"value\"}`

defined_tags

(optional) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: `{\"foo-namespace\": {\"bar-key\": \"value\"}}`

DBMS_CLOUD_OCI_EM_WAREHOUSE_ETL_RUN_SUMMARY_TBL Type

Nested table type of dbms_cloud_oci_em_warehouse_etl_run_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_etl_run_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_em_warehouse_etl_run_summary_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_EM_WAREHOUSE_ETL_RUN_COLLECTION_T Type

The runs list.

Syntax

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

Fields

Field Description

items

(required) List of runs

DBMS_CLOUD_OCI_EM_WAREHOUSE_EM_INSTANCES_DETAILS_TBL Type

Nested table type of dbms_cloud_oci_em_warehouse_em_instances_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_em_instances_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_em_warehouse_em_instances_details_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_EM_WAREHOUSE_RESOURCE_USAGE_T Type

The resource usage information.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_resource_usage_t FORCE AUTHID CURRENT_USER IS OBJECT (
  operations_insights_warehouse_id varchar2(32767),
  id varchar2(32767),
  em_instance_count number,
  targets_count number,
  em_instances dbms_cloud_oci_em_warehouse_em_instances_details_tbl,
  schema_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_resource_usage_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_em_warehouse_resource_usage_t (
    operations_insights_warehouse_id varchar2,
    id varchar2,
    em_instance_count number,
    targets_count number,
    em_instances dbms_cloud_oci_em_warehouse_em_instances_details_tbl,
    schema_name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

operations_insights_warehouse_id

(required) operations Insights Warehouse Identifier

id

(required) Unique identifier that is immutable on creation

em_instance_count

(optional) EmInstanceCount

targets_count

(optional) EmInstance Target count

em_instances

(optional) List of emInstances

schema_name

(optional) schema name

DBMS_CLOUD_OCI_EM_WAREHOUSE_UPDATE_EM_WAREHOUSE_DETAILS_T Type

The information to be updated.

Syntax

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

Fields

Field Description

compartment_id

(optional) Compartment Identifier

em_bridge_id

(optional) EMBridge Identifier

freeform_tags

(optional) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: `{\"bar-key\": \"value\"}`

defined_tags

(optional) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: `{\"foo-namespace\": {\"bar-key\": \"value\"}}`

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_RESOURCE_T Type

A resource created or operated on by a work request.

Syntax

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

Fields

Field Description

entity_type

(required) The resource type the work request affects.

action_type

(required) The way in which this resource is affected by the work tracked in the work request. A resource being created, updated, or deleted will remain in the IN_PROGRESS state until work is complete for that resource at which point it will transition to CREATED, UPDATED, or DELETED, respectively.

Allowed values are: 'CREATED', 'UPDATED', 'DELETED', 'IN_PROGRESS', 'RELATED', 'FAILED'

identifier

(required) The identifier of the resource the work request affects.

entity_uri

(optional) The URI path that the user can do a GET on to access the resource metadata

metadata

(optional) Additional information that helps to explain the resource.

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_RESOURCE_TBL Type

Nested table type of dbms_cloud_oci_em_warehouse_work_request_resource_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_work_request_resource_tbl FORCE IS TABLE OF (dbms_cloud_oci_em_warehouse_work_request_resource_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_T Type

A description of workrequest status

Syntax

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

Fields

Field Description

operation_type

(required) Type of the work request

Allowed values are: 'CREATE_EM_WAREHOUSE', 'UPDATE_EM_WAREHOUSE', 'DELETE_EM_WAREHOUSE', 'MOVE_EM_WAREHOUSE'

status

(required) Status of current work request.

Allowed values are: 'ACCEPTED', 'IN_PROGRESS', 'WAITING', 'FAILED', 'SUCCEEDED', 'CANCELING', 'CANCELED'

id

(required) The id of the work request.

compartment_id

(required) The ocid of the compartment that contains the work request. Work requests should be scoped to the same compartment as the resource the work request affects. If the work request affects multiple resources, and those resources are not in the same compartment, it is up to the service team to pick the primary resource whose compartment should be used

resources

(required) The resources affected by this work request.

percent_complete

(required) Percentage of the request completed.

time_accepted

(required) The date and time the request was created, as described in RFC 3339, section 14.29.

time_started

(optional) The date and time the request was started, as described in RFC 3339, section 14.29.

time_finished

(optional) The date and time the object was finished, as described in RFC 3339.

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_ERROR_T Type

An error encountered while executing a work request.

Syntax

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

Fields

Field Description

code

(required) A machine-usable code for the error that occured. Error codes are listed on (https://docs.cloud.oracle.com/Content/API/References/apierrors.htm)

message

(required) A human readable description of the issue encountered.

l_timestamp

(required) The time the error occured. An RFC3339 formatted datetime string.

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_ERROR_TBL Type

Nested table type of dbms_cloud_oci_em_warehouse_work_request_error_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_work_request_error_tbl FORCE IS TABLE OF (dbms_cloud_oci_em_warehouse_work_request_error_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_ERROR_COLLECTION_T Type

Results of a workRequestError search. Contains both WorkRequestError items and other information, such as metadata.

Syntax

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

Fields

Field Description

items

(required) List of workRequestError objects.

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_LOG_ENTRY_T Type

A log message from the execution of a work request.

Syntax

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

Fields

Field Description

message

(required) Human-readable log message.

l_timestamp

(required) The time the log message was written. An RFC3339 formatted datetime string

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_LOG_ENTRY_TBL Type

Nested table type of dbms_cloud_oci_em_warehouse_work_request_log_entry_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_work_request_log_entry_tbl FORCE IS TABLE OF (dbms_cloud_oci_em_warehouse_work_request_log_entry_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_LOG_ENTRY_COLLECTION_T Type

Results of a workRequestLog search. Contains both workRequestLog items and other information, such as metadata.

Syntax

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

Fields

Field Description

items

(required) List of workRequestLogEntries.

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_SUMMARY_T Type

A summary of the status of a work request.

Syntax

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

Fields

Field Description

operation_type

(required) Type of the work request

Allowed values are: 'CREATE_EM_WAREHOUSE', 'UPDATE_EM_WAREHOUSE', 'DELETE_EM_WAREHOUSE', 'MOVE_EM_WAREHOUSE'

status

(required) Status of current work request.

Allowed values are: 'ACCEPTED', 'IN_PROGRESS', 'WAITING', 'FAILED', 'SUCCEEDED', 'CANCELING', 'CANCELED'

id

(required) The id of the work request.

compartment_id

(required) The ocid of the compartment that contains the work request. Work requests should be scoped to the same compartment as the resource the work request affects. If the work request affects multiple resources, and those resources are not in the same compartment, it is up to the service team to pick the primary resource whose compartment should be used

resources

(required) The resources affected by this work request.

percent_complete

(required) Percentage of the request completed.

time_accepted

(required) The date and time the request was created, as described in RFC 3339, section 14.29.

time_started

(optional) The date and time the request was started, as described in RFC 3339, section 14.29.

time_finished

(optional) The date and time the object was finished, as described in RFC 3339.

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_SUMMARY_TBL Type

Nested table type of dbms_cloud_oci_em_warehouse_work_request_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_em_warehouse_work_request_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_em_warehouse_work_request_summary_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_EM_WAREHOUSE_WORK_REQUEST_SUMMARY_COLLECTION_T Type

Results of a workRequest search. Contains both WorkRequest items and other information, such as metadata.

Syntax

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

Fields

Field Description

items

(required) List of workRequestSummary objects.

Was this article helpful?