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

LOCK

Locks a record for the current user in a tracked table.

Syntax

<LOCK 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 lock.

Description

The LOCK tag locks a record for the current user in a tracked table. Once a row is locked, the current user can modify fields in the row. The current user must have write access to the table.

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 LOCK parameters are exposed on an HTML form. It first checks whether the parameters exist, clears any values from errno, and then locks 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 lock -->
<LOCK TABLE="Variables.tablename"
      ASSET="Variables.asset"/>
<!-- See if lock succeeded -->

<IF COND="Variables.errno=0">
   <THEN>
      <!-- if succeeded, note it-->
      Lock succeeded for 
         <CSVAR
 NAME="Variables.asset"/>
         <BR/>
   </THEN>
   <ELSE>
      <!-- otherwise, call an error reporting element -->
      Lock failed.<BR/>
   </ELSE>
</IF> 

See Also

UNLOCKRECORD

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