Home > Contents > Index >
RELEASE
Releases a lock on a row from a tracked table.
Syntax
<RELEASE TABLE="TABLE_NAME" ASSET="PRIMARY_KEY"/>Parameters
TABLE (required)
- Name of the tracked table.
ASSET (required)
- Value of the primary key for the row to release.
Description
The
RELEASE
tag releases a lock on a row from a tracked table. Only the user who has the row locked against the table can release it. This also reverts the row in the table to its last committed state, overwriting any changes the user made while the row was locked.Error Numbers
The possible values of
errno
include:
Value Description -1000 Command failure. Check theerrdetail
variable for the specific error.Example
This example assumes all
RELEASE
parameters are exposed on an HTML form. It first checks whether the parameters exist, clears any values fromerrno
, and then releases the row.
<!-- Make sure required parameters exist --> <ICS.ARGUMENT COND="IsVariable.tablename=false"> <THEN> <SETVAR NAME="tablename" VALUE=""/> </THEN> </IF> <ICS.ARGUMENT COND="IsVariable.asset=false"> <THEN> <SETVAR NAME="asset" VALUE=""/> </THEN> </IF> <!-- clear out errno --> <SETVAR NAME="errno" VALUE="0"/> <!-- do the release --> <RELEASE TABLE="Variables.tablename" ASSET="Variables.asset"/> <!-- see if the release succeeded --> <ICS.ARGUMENT COND="Variables.errno=0"> <THEN> <!-- if succeeded, note it--> Release succeeded for <CSVAR NAME="Variables.asset"/> <BR/> </THEN> <ELSE> <!-- otherwise, call an error reporting element --> Release failed.<BR/> </ELSE> </IF>See Also
Home > Contents > Index > ![]()
Oracle XML Tag Reference
Copyright (c) 2013, 2015, Oracle and/or its affiliates. All rights reserved.