Home > Contents > 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 havertadmin
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 inmovies
whose primary key value is95137
.<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:
Home > Contents > Index > ![]()
Oracle XML Tag Reference
Copyright (c) 2013, Oracle and/or its affiliates. All rights reserved.