Home >	Contents >	Index >
Template Tag TOC  |   Alpha TOC  |   Tag Family TOC  |   Purpose TOC  |   Annotated TOC  |   Index

UNLOCKRECORD

Unlocks a locked row.

Syntax

<UNLOCKRECORD 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 unlock.

Description

The UNLOCKRECORD tag unlocks a locked row. Only the user who has the row locked or a user who has rtadmin privileges against the table may unlock the row. UNLOCKRECORD does not restore the row to its most recent revision.

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 UNLOCKRECORD parameters are exposed on an HTML form. It first checks whether the parameters exist, clears any values from errno, and then unlocks the row.

<!-- Make sure required parameters exist -->
<IF COND="IsVariable.tablename=false">
   <THEN>
      <SETVAR
 NAME="tablename" VALUE=""/>
   </THEN>
</IF>
<IF COND="IsVariable.asset=false">
   <THEN>
      <SETVAR
 NAME="asset" VALUE=""/>
   </THEN>
</IF>
<!-- clear out errno -->
<SETVAR
 NAME="errno" VALUE="0"/>
<!-- do the unlock -->
<UNLOCKRECORD TABLE="Variables.tablename"
   ASSET="Variables.asset"/>
<!-- See if unlock succeeded -->
<IF COND="Variables.errno=0">
   <THEN>
      <!-- if succeeded, brag about it -->
      Unlock succeeded for 
      <CSVAR
 NAME="Variables.asset"/>
      <BR/>
   </THEN>
   <ELSE>
      <!-- otherwise, call an error reporting element -->
      Unlock failed.<BR/>
   </ELSE>
</IF> 

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