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

---

CATALOGMANAGER.rollback

Reverts a row in a tracked table to a previous revision using the CATALOGMANAGER command.

Syntax

<CATALOGMANAGER>
<ARGUMENT NAME="ftcmd" VALUE="rollback" />
<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 rollback.

tablename (required)

Name of the tracked table.

asset (required)

Value of the primary key for the row to roll back.

version (optional)

Possible values are:

• first - roll back to earliest revision of record.
• last - roll back to most recent revision of record.
• # - roll back to a specific revision number.
• date - roll back 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.

Description

The rollback command reverts a row in a tracked table to a previous revision. The current user must have the row locked and have rtaudit privileges against the table to roll back the row. A row can be rolled back to its earliest revision, its most recent revision, a specific version number, or whichever revision was current at a specified date.

Error Numbers

The possible values of errno include:

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

Example

This example performs a rollback on the record whose primary key value is 95137 to version 5.

<SETVAR NAME="errno" VALUE="0"/>
<CATALOGMANAGER>
   <ARGUMENT NAME="ftcmd" VALUE="rollback"/>
   <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

history

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