Oracle | DBMS_CLOUD

Oracle DBMS_CLOUD_TASK 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 Undocumented

AUTHID DEFINER

Dependencies

DBA_LOAD_OPERATIONS	DBMS_CLOUD_CORE	DBMS_SQL
DBA_USERS	DBMS_CLOUD_TASK$	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

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

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

TBD

DELETE_EXPIRED_TASKS

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

TBD

DELETE_TASK

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

TBD

REGISTER_TASK_CLASS

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

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

TBD

UPDATE_TASK_CLASS

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

TBD