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

ICS.SQL

Deprecated as of Oracle WebCenter Sites version 11gR1.

Syntax

<ICS.SQL SQL="sql commands"
         LISTNAME="list name"
         TABLE="name of table"
         [LIMIT="max number of results"]/>

Parameters

SQL (required)

SQL commands to execute.

LISTNAME (required)

Name of list to contain the resultset.

TABLE (required)

Name of the Sites table to query. The table must be registered in the SystemInfo table. This table verifies security and caches result sets when the cc.cacheResults property is enabled.

LIMIT (optional)

Maximum number of rows to be retrieved. If limit is omitted or if the limit value is set to less than or equal to 0, all records from the SQL command are returned.

Description

The ICS.SQL tag executes an inline SQL statement. It is the equivalent of the EXECSQL XML tag. The table specified by the TABLE must exist in the database prior to calling ICS.SQL. The resultset is cached against the table indicated by the value of the TABLE variable.

Note If the limit is less than or equal to 0, then no limit exists and the entire recordset is returned.

Error Numbers

The possible values of errno include:

Value	Description
-101	No rows found.
-102	Empty column.
-103	No such table.
-104	No table definition.

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