Name
OPEN_WINDOW
Synopsis
This procedure manually opens a window. A window that has not yet reached its scheduled time is considered closed. You can manually open a closed window using this procedure. Doing so will make sure the jobs associated with the window are run.
Parameter name |
Datatype |
Description |
window_name |
VARCHAR2 |
Name of the window to be opened. |
duration |
INTERVAL DAY TO SECOND |
How long the window will stay open. |
force |
BOOLEAN |
If the window is already open, you cannot reopen it; this procedure will return an error. When this parameter is set to TRUE, the window opening will not cause an error but instead will reset the duration of the window to the duration specified in the previous parameter, starting from that instant. |
Get Oracle PL/SQL for DBAs now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.