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 will be available on generic Linux platforms in January and soon on AIX and Windows

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.