Oracle | DBMS_CLOUD

Oracle DBMS_CLOUD_TASK Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Undocumented

AUTHID DEFINER

Dependencies

DBA_LOAD_OPERATIONS	DBMS_CLOUD_CORE	DBMS_SQL
DBA_USERS	DBMS_CLOUD_INTERNAL	DBMS_STANDARD
DBMS_ASSERT	DBMS_CLOUD_TASKS	DBMS_SYS_SQL
DBMS_CLOUD	DBMS_CLOUD_TASK_CLASS

Documented No

First Available 21c

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvt_cloud_task.plb
{ORACLE_HOME}/rdbms/admin/prvt_cloud_task_body.plb

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

      

      Session altered.

      

      SP2-0808: Package created with compilation warnings

      

      Errors for PACKAGE DBMS_CLOUD_TASK:

      

      LINE/COL ERROR

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

      1/1 PLW-05018: unit DBMS_CLOUD_TASK omitted optional AUTHID clause;

      default value DEFINER used

      175/9 PLW-06010: keyword "FORCE" used as a defined name

      SP2-0808: Package created with compilation warnings

      

      Session altered.

      

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

      

      Session altered.

      

      Warning: Package Body created with compilation errors.

      

      Errors for PACKAGE BODY DBMS_CLOUD_TASK:

      

      LINE/COL ERROR

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

      0/0 PL/SQL: Compilation unit analysis terminated

      71/5 PL/SQL: SQL Statement ignored

      71/35 PL/SQL: ORA-00942: table or view does not exist

      83/3 PL/SQL: Item ignored

      86/32 PLS-00201: identifier 'DBMS_CLOUD_TASKS' must be declared

      143/3 PL/SQL: Item ignored

      146/32 PLS-00201: identifier 'DBMS_CLOUD_TASK_CLASS' must be declared

      273/3 PL/SQL: Item ignored

      274/32 PLS-00201: identifier 'DBMS_CLOUD_TASKS' must be declared

      356/5 PL/SQL: SQL Statement ignored

      356/17 PL/SQL: ORA-00942: table or view does not exist

      450/5 PL/SQL: SQL Statement ignored

      450/17 PL/SQL: ORA-00942: table or view does not exist

      486/7 PL/SQL: SQL Statement ignored

      486/14 PL/SQL: ORA-00942: table or view does not exist

      490/7 PL/SQL: SQL Statement ignored

      490/14 PL/SQL: ORA-00942: table or view does not exist

      494/7 PL/SQL: SQL Statement ignored

      494/14 PL/SQL: ORA-00942: table or view does not exist

      514/19 PLS-00201: identifier 'DBMS_CLOUD_TASKS' must be declared

      

      Warning: Package Body created with compilation errors.

      

      PL/SQL procedure successfully completed.

      

      Session altered.

Subprograms

CREATE_TASK	DELETE_TASK	UPDATE_TASK
DELETE_ALL_TASKS	REGISTER_TASK_CLASS	UPDATE_TASK_CLASS
DELETE_EXPIRED_TASKS

CREATE_TASK (new 21c)

Undocumented dbms_cloud_task.create_task( class_name IN VARCHAR2, userid IN NUMBER, status IN NUMBER, payload IN CLOB) RETURN NUMBER;

TBD

DELETE_ALL_TASKS (new 21c)

Undocumented dbms_cloud_task.delete_all_tasks( class_name IN VARCHAR2, userid IN NUMBER);

TBD

DELETE_EXPIRED_TASKS (new 21c)

Undocumented dbms_cloud_task.delete_expired_tasks( class_name IN VARCHAR2, userid IN NUMBER);

TBD

DELETE_TASK (new 21c)

Undocumented dbms_cloud_task.delete_task( id IN NUMBER, userid IN NUMBER, force IN BOOLEAN);

TBD

REGISTER_TASK_CLASS (new 21c)

Undocumented dbms_cloud_task.register_task_class( class_name IN VARCHAR2, userid IN NUMBER, task_retention IN INTERVAL DAY TO SECOND, task_deletion_cbk IN VARCHAR2, status IN NUMBER);

TBD

UPDATE_TASK (new 21c)

Undocumented dbms_cloud_task.update_task( id IN NUMBER, userid IN NUMBER, status IN NUMBER, payload IN CLOB);

TBD

UPDATE_TASK_CLASS (new 21c)

Undocumented dbms_cloud_task.update_task_class( class_name IN VARCHAR2, userid IN NUMBER, attribute_name IN VARCHAR2, attribute_value IN VARCHAR2);

TBD