DBMS_CLOUD_FUNCTION Views
The DBMS_CLOUD_FUNCTION package uses the following views.
- DBA_CLOUD_FUNCTION View
TheDBA_CLOUD_FUNCTIONview lists all the functions created in your Autonomous AI Database. - DBA_CLOUD_FUNCTION_CATALOG View
TheDBA_CLOUD_FUNCTION_CATALOGview lists all the catalogs created in an Autonomous AI Database instance. - DBA_CLOUD_FUNCTION_REMOTE_EXECUTION_GRANT View
TheDBA_CLOUD_FUNCTION_REMOTE_EXECUTION_GRANTview describes the permissions granted for all remote endpoints. - DBA_CLOUD_FUNCTION_RUN_DETAILS View
TheDBA_CLOUD_FUNCTION_RUN_DETAILSview displays log run details for all Scheduler jobs in your Autonomous AI Database. - USER_CLOUD_FUNCTION View
TheUSER_CLOUD_FUNCTIONview lists all the functions created by the user. - USER_CLOUD_FUNCTION_CATALOG View
TheUSER_CLOUD_FUNCTION_CATALOGview lists all the catalogs created by the user. - USER_CLOUD_FUNCTION_ERRORS View
TheUSER_CLOUD_FUNCTION_ERRORSview lists the errors generated during the connection validation to the remote library location. - USER_CLOUD_FUNCTION_RUN_DETAILS View
TheUSER_CLOUD_FUNCTION_RUN_DETAILSdisplays log run details for the Scheduler jobs owned by the current user.
Parent topic: Autonomous AI Database Views
DBA_CLOUD_FUNCTION View
The DBA_CLOUD_FUNCTION view lists all the functions created in your Autonomous AI Database.
| Column | Datatype | Description |
|---|---|---|
OWNER |
VARCHAR2(128) |
Owner of the catalog |
CATALOG_NAME |
VARCHAR2(128) |
Name of the catalog |
APPLICATION_ID |
VARCHAR2(2000) |
OCI Application ID or Azure Application ID |
CLOUD_FUNCTION_NAME |
VARCHAR2(128) |
Remote cloud function name |
FUNCTION_NAME |
VARCHAR2(128) |
Function Name |
FUNCTION_ID |
VARCHAR2(2000) |
OCI Function ID or AWS Function ARN or Azure Function ID or GCP Function ID |
API_TYPE |
VARCHAR2(128) |
API type (Function or procedure) |
Parent topic: DBMS_CLOUD_FUNCTION Views
DBA_CLOUD_FUNCTION_CATALOG View
The DBA_CLOUD_FUNCTION_CATALOG view lists all the catalogs created in an Autonomous AI Database instance.
| Column | Datatype | Description |
|---|---|---|
OWNER |
VARCHAR2(128) |
Owner of the catalog |
CATALOG_NAME |
VARCHAR2(128) |
Name of the catalog |
CLOUD_PROVIDER |
VARCHAR2(128) |
OCI or AWS or Azure or GCP |
Parent topic: DBMS_CLOUD_FUNCTION Views
DBA_CLOUD_FUNCTION_REMOTE_EXECUTION_GRANT View
The DBA_CLOUD_FUNCTION_REMOTE_EXECUTION_GRANT view describes the permissions granted for all remote endpoints.
| Column | Datatype | Description |
|---|---|---|
REMOTE_ENDPOINT_NAME |
VARCHAR2(128) |
Name of the remote endpoint |
USER_NAME |
VARCHAR2(128) |
Name of the user |
Parent topic: DBMS_CLOUD_FUNCTION Views
DBA_CLOUD_FUNCTION_RUN_DETAILS View
The DBA_CLOUD_FUNCTION_RUN_DETAILS view displays log run details for all Scheduler jobs in your Autonomous AI Database.
| Column | Datatype | Description |
|---|---|---|
JOB_OWNER |
VARCHAR2(128) |
Owner of the Scheduler job |
ID |
NUMBER |
Unique identifier of the job |
Job_NAME |
VARCHAR2(256) |
Name of the Scheduler job |
Status |
VARCHAR2(256) |
Status of the job run |
Output |
CLOB |
Output messages generated by this job run |
ERROR_OUTPUT |
CLOB |
Error messages generated by this job run |
Parent topic: DBMS_CLOUD_FUNCTION Views
USER_CLOUD_FUNCTION View
The USER_CLOUD_FUNCTION view lists all the functions created by the user.
| Column | Datatype | Description |
|---|---|---|
CATALOG_NAME |
VARCHAR2(128) |
Name of the catalog |
APPLICATION_NAME |
VARCHAR2(128) |
OCI Application Name |
APPLICATION_ID |
VARCHAR2(2000) |
OCI Application ID or Azure Application ID |
CLOUD_FUNCTION_NAME |
VARCHAR2(128) |
Remote cloud function name |
FUNCTION_NAME |
VARCHAR2(128) |
Function Name |
FUNCTION_ID |
VARCHAR2(2000) |
OCI Function ID or AWS Function ARN or Azure Function ID or GCP Function ID |
API_TYPE |
VARCHAR2(128) |
API type (Function or procedure) |
Parent topic: DBMS_CLOUD_FUNCTION Views
USER_CLOUD_FUNCTION_CATALOG View
The USER_CLOUD_FUNCTION_CATALOG view lists all the catalogs created by the user.
| Column | Datatype | Description |
|---|---|---|
CATALOG_NAME |
VARCHAR2(128) |
Name of the catalog |
CLOUD_PROVIDER |
VARCHAR2(128) |
OCI or AWS or Azure or GCP |
Parent topic: DBMS_CLOUD_FUNCTION Views
USER_CLOUD_FUNCTION_ERRORS View
The USER_CLOUD_FUNCTION_ERRORS view lists the errors generated during the connection validation to the remote library location.
| Column | Datatype | Description |
|---|---|---|
CATALOG_NAME |
VARCHAR2(128) |
Name of the catalog |
CREATE_TIMESTAMP |
TIMESTAMP |
Timestamp when error was generated |
log_error_msg |
CLOB |
The error message |
Parent topic: DBMS_CLOUD_FUNCTION Views
USER_CLOUD_FUNCTION_RUN_DETAILS View
The USER_CLOUD_FUNCTION_RUN_DETAILS displays log run details for the Scheduler jobs owned by the current user.
| Column | Datatype | Description |
|---|---|---|
ID |
NUMBER |
Unique identifier of the job |
Job_NAME |
VARCHAR2(256) |
Name of the Scheduler job |
Status |
VARCHAR2(256) |
Status of the job run |
Output |
CLOB |
Output messages generated by this job run |
ERROR_OUTPUT |
CLOB |
Error messages generated by this job run |
Parent topic: DBMS_CLOUD_FUNCTION Views