Oracle | DBMS_CLOUD

Oracle DBMS_CLOUD_CAPABILITY Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Procedures to check DBMS_CLOUD capabilities

AUTHID DEFINER

Constants

Name	Data Type	Value
General
M_VCSIZ_4K	PLS_INTEGER	4000
Capabilities
CHANGE_CHAR_SET	DBMS_ID	'CHANGE CHARACTER SET'
DBLINK_USING_CRED	DBMS_ID	'DBLINK USING CREDENTIAL'
OCI_NATIVE_CRED	DBMS_ID	'OCI_NATIVE_CREDENTIAL'
ROTATE_ENC_KEY	DBMS_ID	'ROTATE_ENC_KEY'
SEED_CACHING	DBMS_ID	'SEED_CACHING'
Capability Statuses
CAP_STATUS_DISABLED	DBMS_ID	'DISABLED'
CAP_STATUS_ENABLED	DBMS_ID	'ENABLED'

Dependencies (WHAT TYPE OF OBJECT IS DBMS_CLOUD_CONFIG_PARAM?)

DBA_CLOUD_CAPABILITIES	DBMS_CLOUD_CONFIG_PARAM	DBMS_STANDARD
DBMS_CLOUD_ADMIN	DBMS_CLOUD_REQUEST	DUAL

Documented No

Exceptions

Error Code	Reason
ORA-20001	EXCP_CAPABILITY_EXISTS
ORA-20002	EXCP_INVALID_OPERATION
ORA-20998	EXCP_DISABLED_CAPABILTY

First Available 21c

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/dbms_cloud_capability.sql
{ORACLE_HOME}/rdbms/admin/prvt_cloud_capability_body.plb

-- prerequisite

      @?/rdbms/admin/dbms_cloud_catalog.sql

      

      SQL> @?/rdbms/admin/dbms_cloud_capability.sql

      

      Session altered.

      

      SP2-0808: Package created with compilation warnings

      

      Errors for PACKAGE DBMS_CLOUD_CAPABILITY:

      

      LINE/COL ERROR

      ------------------------------------------------------------------------

      1/1 PLW-05018: unit DBMS_CLOUD_CAPABILITY omitted optional AUTHID

      clause; default value DEFINER used

      

      Session altered.

      

      SQL> @?/rdbms/admin/prvt_cloud_capability_body.plb

      

      Session altered.

      

      Warning: Package Body created with compilation errors.

      

      Errors for PACKAGE BODY DBMS_CLOUD_CAPABILITY:

      

      LINE/COL ERROR

      -------- -----------------------------------------------------------------

      45/9 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY

      compiler hint

      

      Session altered.

Subprograms

ADD_CAPABILITY	DISABLE_CAPABILITY	REMOVE_CAPABILITY
CHECK_CAPABILITY	ENABLE_CAPABILITY	SET_CONFIG_PARAM
CHECK_CAPABILITY_FUNC	GET_CONFIG_PARAM

ADD_CAPABILITY

Adds a Cloud capability dbms_cloud_capability.add_capability( capability IN VARCHAR2, status IN VARCHAR2 DEFAULT 'DISABLED');

exec dbms_cloud_capability.add_capability('ENABLED');

      

      PL/SQL procedure successfully completed.

CHECK_CAPABILITY

Verifies the status of a DBMS_CLOUD capability and raise an exception if the capability is disabled or not found. dbms_cloud_capability.check_capability(capability IN VARCHAR2);

exec dbms_cloud_capability.check_capability('DBLINK USING CREDENTIAL');

      

      PL/SQL procedure successfully completed.

CHECK_CAPABILITY_FUNC

Check the status of a DBMS_CLOUD capability and return the status dbms_cloud_capability.check_capability_func(capability IN VARCHAR2) RETURN BOOLEAN;

BEGIN

        IF dbms_cloud_capability.check_capability_func('OCI_NATIVE_CREDIBILITY') THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      T

      

      PL/SQL procedure successfully completed.

DISABLE_CAPABILITY

Disables a Cloud capability dbms_cloud_capability.disable_capability(capability IN VARCHAR2);

exec dbms_cloud_capability.disable_capability('DBLINK USING CREDENTIAL');

      

      PL/SQL procedure successfully completed.

ENABLE_CAPABILITY

Enables a Cloud capability dbms_cloud_capability.enable_capability(capability IN VARCHAR2);

exec dbms_cloud_capability.enable_capability('DBLINK USING CREDENTIAL');

      

      PL/SQL procedure successfully completed.

GET_CONFIG_PARAM

Returns a Cloud configuration parameter value dbms_cloud_capability.get_config_param(param_name IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_cloud_capability.get_config_param('ROTATE_ENC_KEY');

      

      
      DBMS_CLOUD_CAPABILITY.GET_CONFIG_PARAM('ROTATE_ENC_KEY')

      --------------------------------------------------------

REMOVE_CAPABILITY

Removes a Cloud capability dbms_cloud_capability.remove_capability(capability IN VARCHAR2);

exec dbms_cloud_capability.remove_capability('DBLINK USING CREDENTIAL');

      

      PL/SQL procedure successfully completed.

SET_CONFIG_PARAM

Sets a Cloud configuration parameter value dbms_cloud_capability.set_config_param( param_name IN VARCHAR2, param_value IN VARCHAR2);

exec dbms_cloud_capability.set_config_param('ROTATE_ENC_KEY');

      

      PL/SQL procedure successfully completed.