Nested table type of varchar2(32767).

Syntax

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

The information to be updated.

Syntax

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

Fields

List of IDs of non-empty channels.

Syntax

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

Fields

The information about a new queue.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_create_queue_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  retention_in_seconds number,
  visibility_in_seconds number,
  timeout_in_seconds number,
  channel_consumption_limit number,
  dead_letter_queue_delivery_count number,
  custom_encryption_key_id varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_create_queue_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_create_queue_details_t (
    display_name varchar2,
    compartment_id varchar2,
    retention_in_seconds number,
    visibility_in_seconds number,
    timeout_in_seconds number,
    channel_consumption_limit number,
    dead_letter_queue_delivery_count number,
    custom_encryption_key_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Object that represents a message to delete from a queue.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_queue_delete_messages_details_entry_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_delete_messages_details_entry_tbl FORCE IS TABLE OF (dbms_cloud_oci_queue_delete_messages_details_entry_t) NOT PERSISTABLE;

The details of a DeleteMessages request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_delete_messages_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  entries dbms_cloud_oci_queue_delete_messages_details_entry_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_delete_messages_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_delete_messages_details_t (
    entries dbms_cloud_oci_queue_delete_messages_details_entry_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Represents the result of a DeleteMessages request, whether it was successful or not. If a message was successfully deleted from the queue, the entry does not contain any fields. If a message failed to be deleted from the queue, the entry includes the `errorCode` and `errorMessage` fields.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_queue_delete_messages_result_entry_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_delete_messages_result_entry_tbl FORCE IS TABLE OF (dbms_cloud_oci_queue_delete_messages_result_entry_t) NOT PERSISTABLE;

The response to a DeleteMessages request. It indicates the number of server and client failures as well as an array of entries for successful and failed actions.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_delete_messages_result_t FORCE AUTHID CURRENT_USER IS OBJECT (
  server_failures number,
  client_failures number,
  entries dbms_cloud_oci_queue_delete_messages_result_entry_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_delete_messages_result_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_delete_messages_result_t (
    server_failures number,
    client_failures number,
    entries dbms_cloud_oci_queue_delete_messages_result_entry_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Error Information.

Syntax

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

Fields

Object that represents metadata for message.

Syntax

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

Fields

A message consumed from a queue.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_get_message_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id number,
  content varchar2(32767),
  receipt varchar2(32767),
  delivery_count number,
  visible_after timestamp with time zone,
  expire_after timestamp with time zone,
  metadata dbms_cloud_oci_queue_message_metadata_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_get_message_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_get_message_t (
    id number,
    content varchar2,
    receipt varchar2,
    delivery_count number,
    visible_after timestamp with time zone,
    expire_after timestamp with time zone,
    metadata dbms_cloud_oci_queue_message_metadata_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_queue_get_message_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_get_message_tbl FORCE IS TABLE OF (dbms_cloud_oci_queue_get_message_t) NOT PERSISTABLE;

A list of messages from a queue.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_get_messages_t FORCE AUTHID CURRENT_USER IS OBJECT (
  messages dbms_cloud_oci_queue_get_message_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_get_messages_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_get_messages_t (
    messages dbms_cloud_oci_queue_get_message_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Purge parameters.

Syntax

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

Fields

A message that has been published to a queue.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_put_message_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id number,
  expire_after timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_put_message_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_put_message_t (
    id number,
    expire_after timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_queue_put_message_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_put_message_tbl FORCE IS TABLE OF (dbms_cloud_oci_queue_put_message_t) NOT PERSISTABLE;

A list of the messages published to a queue.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_put_messages_t FORCE AUTHID CURRENT_USER IS OBJECT (
  messages dbms_cloud_oci_queue_put_message_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_put_messages_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_put_messages_t (
    messages dbms_cloud_oci_queue_put_message_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Object that represents a message to publish into a queue.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_queue_put_messages_details_entry_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_put_messages_details_entry_tbl FORCE IS TABLE OF (dbms_cloud_oci_queue_put_messages_details_entry_t) NOT PERSISTABLE;

The details of a PutMessages request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_put_messages_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  messages dbms_cloud_oci_queue_put_messages_details_entry_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_put_messages_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_put_messages_details_t (
    messages dbms_cloud_oci_queue_put_messages_details_entry_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A detailed representation of a queue and its configuration.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_queue_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  messages_endpoint varchar2(32767),
  retention_in_seconds number,
  visibility_in_seconds number,
  timeout_in_seconds number,
  dead_letter_queue_delivery_count number,
  custom_encryption_key_id varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  channel_consumption_limit number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_queue_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_queue_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    messages_endpoint varchar2,
    retention_in_seconds number,
    visibility_in_seconds number,
    timeout_in_seconds number,
    dead_letter_queue_delivery_count number,
    custom_encryption_key_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t,
    channel_consumption_limit number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of the queue.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_queue_queue_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_queue_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_queue_queue_summary_t) NOT PERSISTABLE;

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

Syntax

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

Fields

The stats for a queue or a dead letter queue.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_stats_t FORCE AUTHID CURRENT_USER IS OBJECT (
  visible_messages number,
  in_flight_messages number,
  size_in_bytes number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_stats_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_stats_t (
    visible_messages number,
    in_flight_messages number,
    size_in_bytes number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The stats for a queue and its dead letter queue. If channelId is specified in request field, it will return channel specific stats response.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_queue_stats_t FORCE AUTHID CURRENT_USER IS OBJECT (
  queue dbms_cloud_oci_queue_stats_t,
  dlq dbms_cloud_oci_queue_stats_t,
  channel_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_queue_stats_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_queue_stats_t (
    queue dbms_cloud_oci_queue_stats_t,
    dlq dbms_cloud_oci_queue_stats_t,
    channel_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Updates the visibility of a message

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_update_message_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  visibility_in_seconds number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_update_message_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_update_message_details_t (
    visibility_in_seconds number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Object that represents a message to update in a queue.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_queue_update_messages_details_entry_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_update_messages_details_entry_tbl FORCE IS TABLE OF (dbms_cloud_oci_queue_update_messages_details_entry_t) NOT PERSISTABLE;

The details of an UpdateMessages request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_update_messages_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  entries dbms_cloud_oci_queue_update_messages_details_entry_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_update_messages_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_update_messages_details_t (
    entries dbms_cloud_oci_queue_update_messages_details_entry_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Represents the result of a UpdateMessages request, whether it was successful or not. If a message was successfully updated in the queue, the entry includes the `id` and `visibleAfter` fields. If a message failed to be updated in the queue, the entry includes the `errorCode` and `errorMessage` fields.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_update_messages_result_entry_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id number,
  visible_after timestamp with time zone,
  error_code number,
  error_message varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_update_messages_result_entry_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_update_messages_result_entry_t (
    id number,
    visible_after timestamp with time zone,
    error_code number,
    error_message varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_queue_update_messages_result_entry_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_update_messages_result_entry_tbl FORCE IS TABLE OF (dbms_cloud_oci_queue_update_messages_result_entry_t) NOT PERSISTABLE;

The response to a UpdateMessages request. It indicates the number of server and client failures as well as an array of entries for successful and failed actions.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_update_messages_result_t FORCE AUTHID CURRENT_USER IS OBJECT (
  server_failures number,
  client_failures number,
  entries dbms_cloud_oci_queue_update_messages_result_entry_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_update_messages_result_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_update_messages_result_t (
    server_failures number,
    client_failures number,
    entries dbms_cloud_oci_queue_update_messages_result_entry_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The information to be updated.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_update_queue_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  visibility_in_seconds number,
  timeout_in_seconds number,
  channel_consumption_limit number,
  dead_letter_queue_delivery_count number,
  custom_encryption_key_id varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_update_queue_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_update_queue_details_t (
    display_name varchar2,
    visibility_in_seconds number,
    timeout_in_seconds number,
    channel_consumption_limit number,
    dead_letter_queue_delivery_count number,
    custom_encryption_key_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

An updated message with the new visibility.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_updated_message_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id number,
  visible_after timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_updated_message_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_updated_message_t (
    id number,
    visible_after timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A resource created or operated on by a work request.

Syntax

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

Fields

Nested table type of dbms_cloud_oci_queue_work_request_resource_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_work_request_resource_tbl FORCE IS TABLE OF (dbms_cloud_oci_queue_work_request_resource_t) NOT PERSISTABLE;

A description of workrequest status

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_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_queue_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_queue_work_request_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_work_request_t (
    operation_type varchar2,
    status varchar2,
    id varchar2,
    compartment_id varchar2,
    resources dbms_cloud_oci_queue_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

An error encountered while executing a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_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_queue_work_request_error_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_work_request_error_t (
    code varchar2,
    message varchar2,
    l_timestamp timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_queue_work_request_error_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_work_request_error_tbl FORCE IS TABLE OF (dbms_cloud_oci_queue_work_request_error_t) NOT PERSISTABLE;

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

Syntax

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

Fields

A log message from the execution of a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_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_queue_work_request_log_entry_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_work_request_log_entry_t (
    message varchar2,
    l_timestamp timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_queue_work_request_log_entry_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_work_request_log_entry_tbl FORCE IS TABLE OF (dbms_cloud_oci_queue_work_request_log_entry_t) NOT PERSISTABLE;

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

Syntax

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

Fields

A summary of the status of a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_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_queue_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_queue_work_request_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_queue_work_request_summary_t (
    operation_type varchar2,
    status varchar2,
    id varchar2,
    compartment_id varchar2,
    resources dbms_cloud_oci_queue_work_request_resource_tbl,
    percent_complete number,
    time_accepted timestamp with time zone,
    time_started timestamp with time zone,
    time_finished timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_queue_work_request_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_queue_work_request_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_queue_work_request_summary_t) NOT PERSISTABLE;

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

Syntax

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

Fields