Note
This view is available starting with V3.2.3.
Purpose
This view displays information about all programs in the current tenant.
Applicability
This view is applicable only to OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | YES | The owner of the program. |
| PROGRAM_NAME | VARCHAR2(30) | NO | The name of the program. |
| PROGRAM_TYPE | VARCHAR2(16) | YES | The type of the program operation. Valid values: PLSQL_BLOCKSTORED_PROCEDUREEXECUTABLE |
| PROGRAM_ACTION | VARCHAR2(4000) | YES | The string that specifies the program operation. |
| NUMBER_OF_ARGUMENTS | NUMBER(38) | YES | The number of parameters accepted by the program. |
Sample query
Query information about all programs in the current tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_SCHEDULER_PROGRAM;
The query result is as follows:
+-------+--------------+------------------+----------------+---------------------+
| OWNER | PROGRAM_NAME | PROGRAM_TYPE | PROGRAM_ACTION | NUMBER_OF_ARGUMENTS |
+-------+--------------+------------------+----------------+---------------------+
| SYS | empprogram | STORED_PROCEDURE | hr.empprogram | 0 |
+-------+--------------+------------------+----------------+---------------------+
1 row in set