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

TRACKTABLE

Enables revision tracking operations on a table.

Syntax

<TRACKTABLE 
      TABLE="table name"
      [NUMVERSIONS="max versions"]
      STORAGE="storage folder"/>

Parameters

TABLE (required)

Table to track.

NUMVERSIONS (optional)

Maximum number of versions to store for each row. When the maximum is reached, the oldest version is removed.

STORAGE (required)

Location to store revisions associated with a row in the table. This is the root folder. A folder is created under the given root folder whose name is the same as the table being tracked.

Description

The TRACKTABLE tag enables revision tracking operations on a table. The maximum number of revisions per row can be set as well as the storage location for the revisions.

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 TRACKTABLE parameters are exposed on an HTML form. It first checks whether the parameters exist, clears any values from errno, then tracks the given table.

<!-- Make sure required parameters exist -->
<IF COND="IsVariable.tablename=false">
   <THEN>
      <SETVAR
 NAME="tablename" VALUE=""/>
   </THEN>
</IF>
<IF COND="IsVariable.numversions=false">
   <THEN>
      <SETVAR
 NAME="numversions" VALUE=""/>
   </THEN>
</IF>
<IF COND="IsVariable.storage=false">
   <THEN>
      <SETVAR
 NAME="storage" VALUE=""/>
   </THEN>
</IF>
<!-- clear out errno -->
<SETVAR
 NAME="errno" VALUE="0"/>
<!-- do the track -->
<TRACKTABLE TABLE="Variables.tablename"
   NUMVERSIONS="Variables.numversions"
   STORAGE="Variables.storage"/>
<!-- See if track succeeded -->
<IF COND="Variables.errno=0">
   <THEN>
      <!-- if succeeded, brag about it -->
      TrackTable succeeded for 
         <CSVAR
 NAME="Variables.tablename"/><BR/>
   </THEN>
   <ELSE>
      <!-- otherwise, call an error reporting element -->
      TrackTable failed.<BR/>
   </ELSE>
</IF> 

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