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

---

CATALOGMANAGER.release

Releases a lock on a row from a tracked table using the CATALOGMANAGER command.

Syntax

<CATALOGMANAGER>
   <ARGUMENT NAME="ftcmd" VALUE="release" />
   <ARGUMENT NAME="tablename" VALUE="table" />
   <ARGUMENT NAME="asset" VALUE="primarykey"/>
</CATALOGMANAGER>   

Parameters

ftcmd (required)

Value must be set to release.

tablename (required)

Name of the tracked table.

asset (required)

Value of the primary key for the row to lock.

Description

The release command 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
-103	No such table.
-104	No table definition.
-105	Database error.

Example

This example releases the locked record whose primary key value is 95137 in the table movies.

<SETVAR NAME="errno" VALUE="0"/>
<CATALOGMANAGER>
   <ARGUMENT NAME="ftcmd" VALUE="release"/>
   <ARGUMENT NAME="tablename" VALUE="movies"/>
   <ARGUMENT NAME="asset" VALUE="95137"/>
</CATALOGMANAGER>
<IF COND="IsError.Variables.errno=true">
	 	 <THEN>
	 	 <!--Handle error-->
	 	 </THEN>
</IF>

See Also

lock

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