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 Database. - DBA_CLOUD_FUNCTION_CATALOG View
TheDBA_CLOUD_FUNCTION_CATALOGview lists all the catalogs created in an Autonomous Database instance. - 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.
Parent topic: Autonomous Database Views
DBA_CLOUD_FUNCTION View
The DBA_CLOUD_FUNCTION view lists all the functions created in your Autonomous Database.
| Column | Datatype | Description |
|---|---|---|
OWNER |
VARCHAR2(128) |
Owner of the catalog |
CATALOG_NAME |
VARCHAR2(128) |
Name of the catalog |
APPLICATION_ID |
VARCHAR2(2000) |
OCI Function ID or NULL for AWS 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 |
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 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 Function ID or AWS Function ARN or Azure Application ID |
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 |
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 Function ID or AWS Function ARN or Azure Application ID |
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