Home >	Contents >	Index >
Template Tag TOC  |   Alpha TOC  |   Tag Family TOC  |   Purpose TOC  |   Annotated TOC  |   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 the errdetail 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 from errno, 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

UNLOCKRECORD

		Home >	Contents >	Index >
	Oracle XML Tag Reference Copyright (c) 2013, 2015, Oracle and/or its affiliates. All rights reserved.