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

---

CATALOGMANAGER.flushcatalog

Flushes the internal memory cache for a table using the CATALOGMANAGER command.

Syntax

<CATALOGMANAGER>
   <ARGUMENT NAME="ftcmd" VALUE="flushcatalog" />
   <ARGUMENT NAME="tablename" VALUE="table" />
</CATALOGMANAGER>   

Parameters

ftcmd (required)

Value must be set to flushcatalog.

tablename (required)

Name of the table to flush.

Description

The flushcatalog command flushes the internal memory cache for a table. This command is useful to clear a table's cache after a table update using a non-Sites mechanism.

flushcatalog can also force cache clearing when the SQL used to select against a table has performed a join with other tables; the system may hold the cached information for either table.

Error Numbers

The possible values of errno include:

Value	Description
-105	Database error.

Example

If your application server is WebLogic or WebSphere, the following URL flushes the cache for the SystemInfo table.

http://host:port/servlet/CatalogManager?ftcmd=flushcatalog&tablename=SystemInfo

If your application server is iPlanet, the following URL flushes the cache for the SystemInfo table.

http://host:port/NASapp/cs/CatalogManager?ftcmd=flushcatalog&tablename=SystemInfo

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