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

FLUSH

Flushes a list.

Syntax

<FLUSH LIST="LIST_NAME"/>

Parameters

LIST (required)

Name of the list to flush.

Description

The FLUSH tag flushes a list. If the list contains a database resultset, FLUSH clears the resultset from the cache. If the list contains a filelist or stringlist, FLUSH frees system resources.

Error Numbers

The possible values of errno include:

Value	Description
-100	General exception.

Example

The following example selects all rows from the NewPortalArticle table, displays the headline from each row, then flushes the list. Since the list is flushed, subsequent identical queries are rerun against the database. If the list is not flushed, the cached resultset is used for subsequent identical queries against the NewPortalArticle table.

<RENAMELIST LIST = "Articles" FROM = "PortalArticles" />
<SELECTTO FROM="NewPortalArticle" WHAT="*" LIST="Articles" />
<SETVAR NAME = "errno" VALUE = "0" />
<IF COND="Variables.errno=0">
	 	 <THEN>
	 	     <LOOP LIST="Articles">
 	 	     <CSVAR NAME="Articles.headline"/> <br/>
	 	     </LOOP>
	 	 </THEN>
</IF>
<FLUSH LIST = "Articles" />

See Also

FILELIST
STRINGLIST
SELECTTO

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