Home > Contents > 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 havertaudit
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 version5
.<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
Home > Contents > Index > ![]()
Oracle XML Tag Reference
Copyright (c) 2013, Oracle and/or its affiliates. All rights reserved.