36.1 SDO_WFS_LOCK.EnableDBTxns
Format
SDO_WFS_LOCK.EnableDBTxns();
Description
Enables database transactions on WFS tables.
Parameters
None.
Usage Notes
This procedure overrides, through the end of the session, the WFS-T standard restriction against database transactions on WFS tables, so that any transaction with the current session ID can perform update and delete operations on WFS tables. Oracle Database triggers still check the WFS locks before the current transaction is allowed to modify a row; and so if a WFS transaction has a lock on a row, the triggers will not allow the operation to be performed. However, if there is no WFS lock on the current row, the triggers will allow the current transaction to modify the row.
You must call this procedure to perform certain operations when using Oracle Workspace Manager to version-enable a WFS table, as explained in Using WFS with Oracle Workspace Manager. However, you can also use this procedure even if you do not use Workspace Manager with WFS tables.
For information about support for Web Feature Services, see Web Feature Service (WFS) Support.
Examples
The following example enables database transactions on WFS tables for the remainder of the current session.
BEGIN SDO_WFS_LOCK.enableDBTxns; END; /
Parent topic: SDO_WFS_LOCK Package (WFS)