Home > Contents > 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 afilelist
orstringlist
,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 theheadline
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 theNewPortalArticle
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
Home > Contents > Index > ![]()
Oracle XML Tag Reference
Copyright (c) 2013, 2018, Oracle and/or its affiliates. All rights reserved.