Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_WM , 28 of 52
This procedure controls access to versioned rows in a specified table and to corresponding rows in the parent workspace.
DBMS_WM.LockRows( workspace IN VARCHAR2, table_name IN VARCHAR2 [, where_clause IN VARCHAR2 DEFAULT ''] [, lock_mode IN VARCHAR2 DEFAULT 'E']);
This procedure affects Workspace Manager locking, which occurs in addition to any standard Oracle server locking. For an explanation of Workspace Manager locking, see Oracle9i Application Developer's Guide - Workspace Manager.
This procedure does not affect whether Workspace Manager locking is set on or off (determined by the SetLockingON Procedure and SetLockingOFF Procedure).
To unlock rows, use the UnlockRows Procedure.
The following example locks rows in the EMPLOYEES
table where last_name = 'Smith'
in the NEWWORKSPACE
workspace.
EXECUTE DBMS_WM.LockRows ('NEWWORKSPACE', 'employees', 'last_name = ''Smith''');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|