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

 

SETVERSIONS

Sets the number of revisions stored for each row in a tracked table.

Syntax

Parameters

TABLE (required)
Table to modify maximum number of versions

NUMVERSIONS (optional)
Maximum number of versions to store for each row. When the maximum is reached, the oldest version is removed. A value of 0 (zero) indicates an unbounded number of versions stored. If MAX_VERSIONS is smaller than the current number of versions on the table, those versions remain and can be removed manually.

Description

The SETVERSIONS tag sets the number of revisions stored for each row in a tracked table. The current user must have rtadmin privileges on the table.

Error Numbers

The possible values of errno include:

Value
Description
-1000
Command failure. Check the errdetail variable for the specific error.

Example

This example assumes all SETVERSION parameters are exposed on an HTML form. It first checks whether the parameters exist, clears any values from errno, and then sets the maximum number of revisions stored on the table.

  Home > Contents > Index >

Oracle XML Tag Reference
Copyright (c) 2013, 2016, Oracle and/or its affiliates. All rights reserved.