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

---

CATALOGMANAGER.deleterevision

Deletes a revision of a row from a tracked table using the CATALOGMANAGER command.

Syntax

<CATALOGMANAGER>
<ARGUMENT NAME="ftcmd" VALUE="delterevision" />
<ARGUMENT NAME="tablename" VALUE="table" />
<ARGUMENT NAME="asset" VALUE="primarykey"/>
[<ARGUMENT NAME="version" VALUE="first, last, #, or date"]/>
</CATALOGMANAGER>   

Parameters

ftcmd (required)

Value must be set to deleterevision.

tablename (required)

Name of the tracked table.

asset (required)

Value of the primary key for the row to obtain history.

version (optional)

Possible values are:

• first - history of earliest revision of record.
• last - history of most recent revision of record.
• # - history of a specific revision number.
• date - history of the record to whatever revision was current at the specified date. The date must be in SQL format (yyyy-mm-dd hh:mm:ss) and is expected to be GMT (Greenwich Mean Time).

Description

The deleterevision command deletes a revision of a row from a tracked table. The current user must have rtadmin access to the tracked table to perform this operation.

Error Numbers

The possible values of errno include:

Value	Description
-103	No such table.
-104	No table definition.
-105	Database error.

Example

This example deletes version 5 of the row in movies whose primary key value is 95137.

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

See Also

The following CATALOGMANAGER command:

release

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