Oracle | DBMS_CLOUD

Oracle DBMS_CLOUD_CAPABILITY Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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

DBMS_STANDARD

Documented No

Exceptions

Error Code	Reason
20001	EXCP_CAPABILITY_EXISTS
20002	EXCP_INVALID_OPERATION
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

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 (new 21c)

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

exec dbms_cloud_capability.add_capability('ENABLED');

CHECK_CAPABILITY (new 21c)

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');

CHECK_CAPABILITY_FUNC (new 21c)

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;

      /

DISABLE_CAPABILITY (new 21c)

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

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

ENABLE_CAPABILITY (new 21c)

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

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

GET_CONFIG_PARAM (new 21c)

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')

      FROM dual;

      

      
      DBMS_CLOUD_CAPABILITY.GET_CONFIG_PARAM('ROTATE_ENC_KEY')

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

REMOVE_CAPABILITY (new 21c)

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

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

SET_CONFIG_PARAM (new 21c)

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');