Oracle | DBMS_CLOUD

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