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 available only in Oracle-compatible mode of OceanBase Database.
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:
|
| 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