PACKAGE: MDSYS.SDO_WFS_LOCK

Source

1 PACKAGE       SDO_WFS_LOCK authid current_user AS
2 
3 cleanup number := 1;
4 ROWCNT_THRESHOLD number := 100;
5 
6 procedure registerFeatureTable(userName IN varchar2, tableName IN varchar2) ;
7 procedure unRegisterFeatureTable(userName IN varchar2, tableName IN varchar2) ;
8 function lockRowsById(userName IN VARCHAR2,
9                   tableName IN varchar2,
10                   tableAlias varchar2,
11                   expiryTime IN number,
12                   rowsLocked OUT mdsys.RowPointerList,
13                   rowsNotLocked OUT mdsys.RowPointerList,
14                   lockAll varchar2,
15                   pkeyCols mdsys.StringList,
16                   autoCommit varchar2,
17                   rowsToBeLocked IN  mdsys.RowPointerList,
18                   orderClause varchar2,
19                   indexClause varchar2,
20                   maxcnt number) return number;
21 procedure lockRowsById(pTokenId IN varchar2,
22                 userName IN VARCHAR2,
23                 tableName IN varchar2,
24                 tableAlias varchar2,
25                 expiryTime IN number,
26                 rowsLocked OUT mdsys.RowPointerList,
27                 rowsNotLocked OUT mdsys.RowPointerList,
28                 lockAll varchar2,
29                 pkeyCols mdsys.StringList,
30                 autoCommit varchar2,
31                 rowsToBeLocked IN  mdsys.RowPointerList,
32                 orderClause varchar2,
33                 indexClause varchar2,
34                 maxcnt number) ;
35 procedure unlockRowsById(pTokenId IN varchar2,
36                 userName IN VARCHAR2,
37                 tableName IN varchar2,
38                 tableAlias IN varchar2,
39                 pkeyCols IN mdsys.StringList,
40                 autoCommit IN varchar2,
41                 rowsToBeUnLocked IN  mdsys.RowPointerList);
42 procedure transferTokenById (pTokenId IN varchar2) ;
43 
44 procedure updateTokenSessionMap(tId varchar2, sId varchar2) ;
45 
46 procedure deleteTokenSessionMap(tId varchar2) ;
47 
48 function queryTokenSessionMap (tId varchar2) return varchar2 ;
49 
50 procedure resetTokenExpiry(tId varchar2) ;
51 
52 function generateTokenId return varchar2;
53 
54 procedure enableDBTxns;
55 end;