Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_WM , 27 of 52
This function checks whether or not a workspace has any active sessions.
DBMS_WM.IsWorkspaceOccupied( workspace IN VARCHAR2) RETURN VARCHAR2;
Parameter | Description |
---|---|
workspace |
Name of the workspace. The name is case sensitive. |
This function returns YES
if the workspace has any active sessions and NO
if the workspace has no active sessions.
An exception is raised if the LIVE
workspace is specified or if the user does not have the privilege to access the workspace.
The following example checks if any sessions are active in the B_focus_2
workspace.
SELECT DBMS_WM.IsWorkspaceOccupied('B_focus_2') FROM DUAL; DBMS_WM.ISWORKSPACEOCCUPIED('B_FOCUS_2') -------------------------------------------------------------------------------- YES
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|