Oracle Cloud Infrastructure Documentation
Try Free Tier

Service Catalog Common Types

DBMS_CLOUD_OCI_SERVICE_CATALOG_VARCHAR2_TBL Type

Nested table type of varchar2(32767).

Syntax

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

DBMS_CLOUD_OCI_SERVICE_CATALOG_PUBLISHER_SUMMARY_T Type

Summary details about the publisher of the resource.

Syntax

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

Fields

Field Description

id

(required) The unique identifier for the publisher.

display_name

(required) The name of the publisher.

DBMS_CLOUD_OCI_SERVICE_CATALOG_UPLOAD_DATA_T Type

The model for uploaded binary data, like logos and images.

Syntax

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

Fields

Field Description

display_name

(optional) The name used to refer to the uploaded data.

content_url

(optional) The content URL of the uploaded data.

mime_type

(optional) The MIME type of the uploaded data.

DBMS_CLOUD_OCI_SERVICE_CATALOG_APPLICATION_SUMMARY_T Type

The model for summary of an application in service catalog.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_application_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  entity_id varchar2(32767),
  entity_type varchar2(32767),
  display_name varchar2(32767),
  is_featured number,
  publisher dbms_cloud_oci_service_catalog_publisher_summary_t,
  short_description varchar2(32767),
  logo dbms_cloud_oci_service_catalog_upload_data_t,
  pricing_type varchar2(32767),
  package_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_application_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_application_summary_t (
    entity_id varchar2,
    entity_type varchar2,
    display_name varchar2,
    is_featured number,
    publisher dbms_cloud_oci_service_catalog_publisher_summary_t,
    short_description varchar2,
    logo dbms_cloud_oci_service_catalog_upload_data_t,
    pricing_type varchar2,
    package_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

entity_id

(required) Identifier of the application from a service catalog.

entity_type

(required) The type of an application in the service catalog.

display_name

(required) The name that service catalog should use to display this application.

is_featured

(optional) Indicates whether the application is featured.

publisher

(optional)

short_description

(optional) A short description of the application.

logo

(optional)

pricing_type

(optional) Summary of the pricing types available across all packages in the application.

Allowed values are: 'FREE', 'BYOL', 'PAYGO'

package_type

(optional) The type of the packages withing the application.

Allowed values are: 'STACK'

DBMS_CLOUD_OCI_SERVICE_CATALOG_APPLICATION_SUMMARY_TBL Type

Nested table type of dbms_cloud_oci_service_catalog_application_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_application_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_service_catalog_application_summary_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_SERVICE_CATALOG_APPLICATION_COLLECTION_T Type

Collection of applications in a given service catalog or a tenancy.

Syntax

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

Fields

Field Description

items

(required) Collection of service catalog applications.

DBMS_CLOUD_OCI_SERVICE_CATALOG_CREATE_SERVICE_CATALOG_ASSOCIATION_DETAILS_T Type

The model to create a single association between a service catalog and a resource.

Syntax

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

Fields

Field Description

service_catalog_id

(required) Identifier of the service catalog.

entity_id

(required) Identifier of the entity being associated with service catalog.

entity_type

(optional) The type of the entity that is associated with the service catalog.

DBMS_CLOUD_OCI_SERVICE_CATALOG_CREATE_SERVICE_CATALOG_ASSOCIATION_DETAILS_TBL Type

Nested table type of dbms_cloud_oci_service_catalog_create_service_catalog_association_details_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_create_service_catalog_association_details_tbl FORCE IS TABLE OF (dbms_cloud_oci_service_catalog_create_service_catalog_association_details_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_SERVICE_CATALOG_BULK_REPLACE_SERVICE_CATALOG_ASSOCIATIONS_DETAILS_T Type

The model to replace service catalog associations in bulk.

Syntax

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

Fields

Field Description

items

(required) Collection of CreateServiceCatalogAssociationDetails for bulk operation.

DBMS_CLOUD_OCI_SERVICE_CATALOG_CHANGE_PRIVATE_APPLICATION_COMPARTMENT_DETAILS_T Type

All the parameters required to make the move.

Syntax

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

Fields

Field Description

compartment_id

(optional) The OCID of the compartment where you want to move the private application.

DBMS_CLOUD_OCI_SERVICE_CATALOG_CHANGE_SERVICE_CATALOG_COMPARTMENT_DETAILS_T Type

The model for the parameters needed move a service catalog from one compartment to another.

Syntax

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

Fields

Field Description

compartment_id

(optional) The OCID of the compartment where you want to move the service catalog.

DBMS_CLOUD_OCI_SERVICE_CATALOG_CREATE_PRIVATE_APPLICATION_PACKAGE_T Type

A base object for creating a private application package.

Syntax

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

Fields

Field Description

package_type

(required) The package's type.

Allowed values are: 'STACK'

version

(required) The package version.

DBMS_CLOUD_OCI_SERVICE_CATALOG_CREATE_PRIVATE_APPLICATION_DETAILS_T Type

The model for the parameters needed to create a private application.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_create_private_application_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  short_description varchar2(32767),
  long_description varchar2(32767),
  logo_file_base64_encoded varchar2(32767),
  package_details dbms_cloud_oci_service_catalog_create_private_application_package_t,
  defined_tags json_element_t,
  freeform_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_create_private_application_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_create_private_application_details_t (
    compartment_id varchar2,
    display_name varchar2,
    short_description varchar2,
    long_description varchar2,
    logo_file_base64_encoded varchar2,
    package_details dbms_cloud_oci_service_catalog_create_private_application_package_t,
    defined_tags json_element_t,
    freeform_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

compartment_id

(required) The OCID of the compartment where you want to create the private application.

display_name

(required) The name of the private application.

short_description

(required) A short description of the private application.

long_description

(optional) A long description of the private application.

logo_file_base64_encoded

(optional) Base64-encoded logo to use as the private application icon. Template icon file requirements: PNG format, 50 KB maximum, 130 x 130 pixels.

package_details

(required)

defined_tags

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

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\"}`

DBMS_CLOUD_OCI_SERVICE_CATALOG_CREATE_PRIVATE_APPLICATION_STACK_PACKAGE_T Type

An object for creating a private application stack package.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_create_private_application_stack_package_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_service_catalog_create_private_application_package_t (
  zip_file_base64_encoded varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_create_private_application_stack_package_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_create_private_application_stack_package_t (
    package_type varchar2,
    version varchar2,
    zip_file_base64_encoded varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_service_catalog_create_private_application_stack_package_t is a subtype of the dbms_cloud_oci_service_catalog_create_private_application_package_t type.

Fields

Field Description

zip_file_base64_encoded

(optional) Base-64 payload of the Terraform zip package.

DBMS_CLOUD_OCI_SERVICE_CATALOG_CREATE_SERVICE_CATALOG_DETAILS_T Type

The model for parameter needed to create service catalog.

Syntax

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

Fields

Field Description

compartment_id

(required) The unique identifier for the compartment where the service catalog will be created.

display_name

(required) The display name of the service catalog.

defined_tags

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

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\"}`

DBMS_CLOUD_OCI_SERVICE_CATALOG_ERROR_ENTITY_T Type

The model for the error entity.

Syntax

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

Fields

Field Description

code

(required) A short error code that defines the error.

message

(required) A human-readable error string.

DBMS_CLOUD_OCI_SERVICE_CATALOG_PRIVATE_APPLICATION_T Type

Full details of an application or a solution, which lives inside the tenancy and may be included into service catalogs.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_private_application_t FORCE AUTHID CURRENT_USER IS OBJECT (
  lifecycle_state varchar2(32767),
  compartment_id varchar2(32767),
  id varchar2(32767),
  display_name varchar2(32767),
  short_description varchar2(32767),
  long_description varchar2(32767),
  logo dbms_cloud_oci_service_catalog_upload_data_t,
  package_type varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  defined_tags json_element_t,
  freeform_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_private_application_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_private_application_t (
    lifecycle_state varchar2,
    compartment_id varchar2,
    id varchar2,
    display_name varchar2,
    short_description varchar2,
    long_description varchar2,
    logo dbms_cloud_oci_service_catalog_upload_data_t,
    package_type varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    defined_tags json_element_t,
    freeform_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

lifecycle_state

(required) The lifecycle state of the private application.

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

compartment_id

(required) The OCID of the compartment where the private application resides.

id

(required) The unique identifier for the private application in Marketplace.

display_name

(required) The name of the private application.

short_description

(optional) A short description of the private application.

long_description

(optional) A long description of the private application.

logo

(optional)

package_type

(required) Type of packages within this private application.

Allowed values are: 'STACK'

time_created

(required) The date and time the private application was created, expressed in RFC 3339 timestamp format. Example: `2021-05-26T21:10:29.600Z`

time_updated

(optional) The date and time the private application was last modified, expressed in RFC 3339 timestamp format. Example: `2021-12-10T05:10:29.721Z`

defined_tags

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

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\"}`

DBMS_CLOUD_OCI_SERVICE_CATALOG_PRIVATE_APPLICATION_SUMMARY_T Type

Brief data about an application or a solution, which lives inside the tenancy and may be included into service catalogs.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_private_application_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  lifecycle_state varchar2(32767),
  compartment_id varchar2(32767),
  id varchar2(32767),
  display_name varchar2(32767),
  short_description varchar2(32767),
  logo dbms_cloud_oci_service_catalog_upload_data_t,
  package_type varchar2(32767),
  time_created timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_private_application_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_private_application_summary_t (
    lifecycle_state varchar2,
    compartment_id varchar2,
    id varchar2,
    display_name varchar2,
    short_description varchar2,
    logo dbms_cloud_oci_service_catalog_upload_data_t,
    package_type varchar2,
    time_created timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

lifecycle_state

(required) The lifecycle state of the private application.

compartment_id

(required) The OCID of the compartment where the private application resides.

id

(required) The OCID of the private application.

display_name

(required) The name of the private application.

short_description

(optional) A short description of the private application.

logo

(optional)

package_type

(required) Type of the packages, which are hosted by the private application.

Allowed values are: 'STACK'

time_created

(required) The date and time the private application was created, expressed in RFC 3339 timestamp format. Example: `2021-05-27T21:10:29.600Z`

DBMS_CLOUD_OCI_SERVICE_CATALOG_PRIVATE_APPLICATION_SUMMARY_TBL Type

Nested table type of dbms_cloud_oci_service_catalog_private_application_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_private_application_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_service_catalog_private_application_summary_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_SERVICE_CATALOG_PRIVATE_APPLICATION_COLLECTION_T Type

Collection of private applications.

Syntax

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

Fields

Field Description

items

(required) Collection of items.

DBMS_CLOUD_OCI_SERVICE_CATALOG_PRIVATE_APPLICATION_PACKAGE_T Type

A base object for all types of private application packages.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_private_application_package_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  private_application_id varchar2(32767),
  display_name varchar2(32767),
  version varchar2(32767),
  package_type varchar2(32767),
  time_created timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_private_application_package_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_private_application_package_t (
    id varchar2,
    private_application_id varchar2,
    display_name varchar2,
    version varchar2,
    package_type varchar2,
    time_created timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Field Description

id

(required) The OCID of the private application package.

private_application_id

(required) The OCID of the private application where the package is hosted.

display_name

(optional) The display name of the package.

version

(required) The package version.

package_type

(required) The specified package's type.

Allowed values are: 'STACK'

time_created

(required) The date and time the private application package was created, expressed in RFC 3339 timestamp format. Example: `2021-05-27T21:10:29.600Z`

DBMS_CLOUD_OCI_SERVICE_CATALOG_PRIVATE_APPLICATION_PACKAGE_SUMMARY_T Type

The model for a summary of a private application package.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_private_application_package_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  private_application_id varchar2(32767),
  display_name varchar2(32767),
  version varchar2(32767),
  package_type varchar2(32767),
  time_created timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_private_application_package_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_private_application_package_summary_t (
    id varchar2,
    private_application_id varchar2,
    display_name varchar2,
    version varchar2,
    package_type varchar2,
    time_created timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

id

(required) The OCID of the private application package.

private_application_id

(required) The OCID of the private application where the package is hosted.

display_name

(optional) The display name of the specified package.

version

(required) The version of the specified package.

package_type

(required) The type of the package.

Allowed values are: 'STACK'

time_created

(required) The date and time the private application package was created, expressed in RFC 3339 timestamp format. Example: `2021-05-27T21:10:29.600Z`

DBMS_CLOUD_OCI_SERVICE_CATALOG_PRIVATE_APPLICATION_PACKAGE_SUMMARY_TBL Type

Nested table type of dbms_cloud_oci_service_catalog_private_application_package_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_private_application_package_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_service_catalog_private_application_package_summary_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_SERVICE_CATALOG_PRIVATE_APPLICATION_PACKAGE_COLLECTION_T Type

Collection of Private Application Package summary objects.

Syntax

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

Fields

Field Description

items

(required) Collection of items.

DBMS_CLOUD_OCI_SERVICE_CATALOG_PRIVATE_APPLICATION_STACK_PACKAGE_T Type

A stack package for private applications.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_private_application_stack_package_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_service_catalog_private_application_package_t (
  content_url varchar2(32767),
  mime_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_private_application_stack_package_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_private_application_stack_package_t (
    id varchar2,
    private_application_id varchar2,
    display_name varchar2,
    version varchar2,
    package_type varchar2,
    time_created timestamp with time zone,
    content_url varchar2,
    mime_type varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_service_catalog_private_application_stack_package_t is a subtype of the dbms_cloud_oci_service_catalog_private_application_package_t type.

Fields

Field Description

content_url

(optional) The content URL of the terraform configuration.

mime_type

(optional) The MIME type of the terraform configuration.

DBMS_CLOUD_OCI_SERVICE_CATALOG_SERVICE_CATALOG_T Type

The model for an Oracle Cloud Infrastructure Service Catalog.

Syntax

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

Fields

Field Description

id

(required) The unique identifier for the Service catalog.

compartment_id

(required) The Compartment id where the service catalog exists

display_name

(required) The name of the service catalog.

lifecycle_state

(required) The lifecycle state of the service catalog.

Allowed values are: 'ACTIVE', 'DELETED'

time_created

(required) The date and time the service catalog was created, expressed in RFC 3339 timestamp format. Example: `2021-05-26T21:10:29.600Z`

time_updated

(optional) The date and time the service catalog was last modified, expressed in RFC 3339 timestamp format. Example: `2021-12-10T05:10:29.721Z`

defined_tags

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

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\"}`

DBMS_CLOUD_OCI_SERVICE_CATALOG_SERVICE_CATALOG_ASSOCIATION_T Type

The detailed model for service catalog association.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_service_catalog_association_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  service_catalog_id varchar2(32767),
  entity_id varchar2(32767),
  entity_type varchar2(32767),
  time_created timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_service_catalog_association_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_service_catalog_association_t (
    id varchar2,
    service_catalog_id varchar2,
    entity_id varchar2,
    entity_type varchar2,
    time_created timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

id

(required) Identifier of the association.

service_catalog_id

(required) Identifier of the service catalog.

entity_id

(required) Identifier of the entity being associated with service catalog.

entity_type

(optional) The type of the entity that is associated with the service catalog.

time_created

(required) Timestamp of when the resource was associated with service catalog.

DBMS_CLOUD_OCI_SERVICE_CATALOG_SERVICE_CATALOG_ASSOCIATION_SUMMARY_T Type

The model for a summary of a service catalog association.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_service_catalog_association_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  service_catalog_id varchar2(32767),
  entity_id varchar2(32767),
  entity_type varchar2(32767),
  time_created timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_service_catalog_association_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_service_catalog_association_summary_t (
    id varchar2,
    service_catalog_id varchar2,
    entity_id varchar2,
    entity_type varchar2,
    time_created timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

id

(required) The unique identifier of the service catalog association.

service_catalog_id

(required) The unique identifier of the service catalog.

entity_id

(required) The unique identifier of the resource being associated to service catalog.

entity_type

(optional) The type of the entity that is associated with the service catalog.

time_created

(required) Timestamp of when the resource was associated with service catalog.

DBMS_CLOUD_OCI_SERVICE_CATALOG_SERVICE_CATALOG_ASSOCIATION_SUMMARY_TBL Type

Nested table type of dbms_cloud_oci_service_catalog_service_catalog_association_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_service_catalog_association_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_service_catalog_service_catalog_association_summary_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_SERVICE_CATALOG_SERVICE_CATALOG_ASSOCIATION_COLLECTION_T Type

Collection of service catalog associations.

Syntax

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

Fields

Field Description

items

(required) Collection of service catalog and the resources associated with it.

DBMS_CLOUD_OCI_SERVICE_CATALOG_SERVICE_CATALOG_SUMMARY_T Type

The model for a summary of an Oracle Cloud Infrastructure service catalog.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_service_catalog_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  lifecycle_state varchar2(32767),
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  time_created timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_service_catalog_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_service_catalog_summary_t (
    id varchar2,
    lifecycle_state varchar2,
    compartment_id varchar2,
    display_name varchar2,
    time_created timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

id

(required) The unique identifier for the Service catalog.

lifecycle_state

(required) The lifecycle state of the service catalog.

compartment_id

(required) The Compartment id where the service catalog exists.

display_name

(required) The name of the service catalog.

time_created

(required) The date and time this service catalog was created, expressed in RFC 3339 timestamp format. Example: `2021-08-25T21:10:29.600Z`

DBMS_CLOUD_OCI_SERVICE_CATALOG_SERVICE_CATALOG_SUMMARY_TBL Type

Nested table type of dbms_cloud_oci_service_catalog_service_catalog_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_service_catalog_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_service_catalog_service_catalog_summary_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_SERVICE_CATALOG_SERVICE_CATALOG_COLLECTION_T Type

Collection of Service Catalog Summaries.

Syntax

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

Fields

Field Description

items

(required) Collection of catalog summaries.

DBMS_CLOUD_OCI_SERVICE_CATALOG_UPDATE_PRIVATE_APPLICATION_DETAILS_T Type

The model for the parameters needed to update a private application.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_update_private_application_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  short_description varchar2(32767),
  long_description varchar2(32767),
  logo_file_base64_encoded varchar2(32767),
  defined_tags json_element_t,
  freeform_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_update_private_application_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_update_private_application_details_t (
    display_name varchar2,
    short_description varchar2,
    long_description varchar2,
    logo_file_base64_encoded varchar2,
    defined_tags json_element_t,
    freeform_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

display_name

(optional) The name of the private application.

short_description

(optional) A short description of the private application.

long_description

(optional) A long description of the private application.

logo_file_base64_encoded

(optional) Base64-encoded logo to use as the private application icon. Template icon file requirements: PNG format, 50 KB maximum, 130 x 130 pixels.

defined_tags

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

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\"}`

DBMS_CLOUD_OCI_SERVICE_CATALOG_UPDATE_SERVICE_CATALOG_DETAILS_T Type

The model for the parameters needed to update a service catalog.

Syntax

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

Fields

Field Description

display_name

(required) A display name of the service catalog.

defined_tags

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

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\"}`

DBMS_CLOUD_OCI_SERVICE_CATALOG_WORK_REQUEST_RESOURCE_T Type

A resource created or operated on by a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_work_request_resource_t FORCE AUTHID CURRENT_USER IS OBJECT (
  entity_type varchar2(32767),
  action_type varchar2(32767),
  entity_id varchar2(32767),
  entity_uri varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_work_request_resource_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_work_request_resource_t (
    entity_type varchar2,
    action_type varchar2,
    entity_id varchar2,
    entity_uri varchar2
  ) 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', 'FAILED'

entity_id

(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

DBMS_CLOUD_OCI_SERVICE_CATALOG_WORK_REQUEST_RESOURCE_TBL Type

Nested table type of dbms_cloud_oci_service_catalog_work_request_resource_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_work_request_resource_tbl FORCE IS TABLE OF (dbms_cloud_oci_service_catalog_work_request_resource_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_SERVICE_CATALOG_WORK_REQUEST_T Type

A description of workrequest status

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_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_service_catalog_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_service_catalog_work_request_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_work_request_t (
    operation_type varchar2,
    status varchar2,
    id varchar2,
    compartment_id varchar2,
    resources dbms_cloud_oci_service_catalog_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_PRIVATE_APPLICATION', 'UPDATE_PRIVATE_APPLICATION', 'DELETE_PRIVATE_APPLICATION', 'MOVE_PRIVATE_APPLICATION'

status

(required) Status of current work request.

Allowed values are: 'ACCEPTED', 'FAILED', 'SUCCEEDED'

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_SERVICE_CATALOG_WORK_REQUEST_ERROR_T Type

An error encountered while executing a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_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_service_catalog_work_request_error_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_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_SERVICE_CATALOG_WORK_REQUEST_ERROR_TBL Type

Nested table type of dbms_cloud_oci_service_catalog_work_request_error_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_work_request_error_tbl FORCE IS TABLE OF (dbms_cloud_oci_service_catalog_work_request_error_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_SERVICE_CATALOG_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_service_catalog_work_request_error_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_service_catalog_work_request_error_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_work_request_error_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_work_request_error_collection_t (
    items dbms_cloud_oci_service_catalog_work_request_error_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

items

(required) List of workRequestError objects.

DBMS_CLOUD_OCI_SERVICE_CATALOG_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_service_catalog_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_service_catalog_work_request_log_entry_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_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_SERVICE_CATALOG_WORK_REQUEST_LOG_ENTRY_TBL Type

Nested table type of dbms_cloud_oci_service_catalog_work_request_log_entry_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_work_request_log_entry_tbl FORCE IS TABLE OF (dbms_cloud_oci_service_catalog_work_request_log_entry_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_SERVICE_CATALOG_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_service_catalog_work_request_log_entry_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_service_catalog_work_request_log_entry_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_work_request_log_entry_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_work_request_log_entry_collection_t (
    items dbms_cloud_oci_service_catalog_work_request_log_entry_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

items

(required) List of workRequestLogEntries.

DBMS_CLOUD_OCI_SERVICE_CATALOG_WORK_REQUEST_SUMMARY_T Type

A summary of the status of a work request.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_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_service_catalog_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_service_catalog_work_request_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_work_request_summary_t (
    operation_type varchar2,
    status varchar2,
    id varchar2,
    compartment_id varchar2,
    resources dbms_cloud_oci_service_catalog_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_PRIVATE_APPLICATION', 'UPDATE_PRIVATE_APPLICATION', 'DELETE_PRIVATE_APPLICATION', 'MOVE_PRIVATE_APPLICATION'

status

(required) Status of current work request.

Allowed values are: 'ACCEPTED', 'FAILED', 'SUCCEEDED'

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_SERVICE_CATALOG_WORK_REQUEST_SUMMARY_TBL Type

Nested table type of dbms_cloud_oci_service_catalog_work_request_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_service_catalog_work_request_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_service_catalog_work_request_summary_t) NOT PERSISTABLE;

DBMS_CLOUD_OCI_SERVICE_CATALOG_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_service_catalog_work_request_summary_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_service_catalog_work_request_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_work_request_summary_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_service_catalog_work_request_summary_collection_t (
    items dbms_cloud_oci_service_catalog_work_request_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Field Description

items

(required) List of workRequestSummary objects.

Was this article helpful?