The DROP_PROGRAM procedure is used to delete a program. When a program is deleted, the parameters associated with the program are also deleted.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
DBMS_SCHEDULER.DROP_PROGRAM (
program_name IN VARCHAR2,
force IN BOOLEAN DEFAULT FALSE);
Parameters
| Parameter | Description |
|---|---|
| program_name | The name of the program to be deleted. The name can be a comma-separated list. |
| force | If force is set to FALSE, any job that references the program will result in an error. If force is set to TRUE, all jobs referencing the program will be disabled before the program is deleted. Running jobs that reference the program will continue to execute and are not affected by the DROP_PROGRAM call. |
Examples
BEGIN
DBMS_SCHEDULER.DROP_PROGRAM(program_name => 'program_test');
END;