October 2005
Intermediate to advanced
454 pages
14h 44m
English
Instead of dropping a window, you may want to disable it so that it will never open automatically. To disable a window, use the procedure DISABLE, as shown here.
BEGIN
DBMS_SCHEDULER.disable (NAME => 'window1');
END;If the window named window1 is currently open, this operation will fail. To forcibly disable a window, you must use the FORCE parameter as follows:
BEGIN
DBMS_SCHEDULER.disable (NAME => 'window1', FORCE=>TRUE);
END;This will not close the currently open window, but it will force the window not to open in the future.
Similarly, to enable a disabled window, use the ENABLE procedure :
BEGIN
DBMS_SCHEDULER.enable (NAME => 'window1');
END;Note that the ENABLE and DISABLE procedures shown here are the same ENABLE/DISABLE procedures used for other Scheduler objects, such as jobs, schedules, and programs.