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 (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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_CLOUD
DBMS_CLOUD_ADMIN_INTERNAL
DBMS_CLOUD_CAPABILITY
DBMS_CLOUD_CORE
DBMS_CLOUD_INTERNAL
DBMS_CLOUD_MACADM
DBMS_CLOUD_REQUEST
DBMS_CLOUD_TYPES
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx