ttXlaSubscribe

This procedure configures persistent XLA tracking of a table. This procedure cannot be run when the specified bookmark is in use.

Required Privilege

This procedure requires the XLA privilege.

Usage in TimesTen Scaleout and TimesTen Classic

This procedure is supported in TimesTen Classic but not supported in TimesTen Scaleout.

Related Views

This procedure has no related views.

Syntax

ttXlaSubscribe('tblName', 'bookmark') 

Parameters

ttXlaSubscribe has the parameters:

Parameter Type Description

tblName

TT_CHAR (61) NOT NULL

The name of the table to be tracked.

Using a synonym to specify a table name is not supported.

bookmark

TT_CHAR (31) NOT NULL

The name of the bookmark that the application uses to track this table.

Result Set

ttXlaSubscribe returns no results.

Examples

Command > call ttXlaSubscribe ('SALLY.ACCTS', 'mybookmark');

Note:

Alternatively, the ttXlaTableStatus function subscribes the current bookmark to updates to the specified table, or determines whether the current bookmark is already monitoring DML records associated with the table. See Specifying Which Tables to Monitor for Updates in Oracle TimesTen In-Memory Database C Developer's Guide.