Home > Contents > Index >
Template Tags TOC | Alpha TOC | Tag Family TOC | Purpose TOC | Annotated TOC | Index
ics:sql
Executes an inline SQL statement.
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 resultsets when the
cc.cacheResults
property is enabled. You may specify a comma-separated list of tables to cache or synchronize against.
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 is returned.
Description
The
ics:sql
tag executes an inline SQL statement. It is the equivalent of theEXECSQL
XML tag. The table specified by thetablename
must exist in the database prior to callingics:sql
. The resultset is cached against the table indicated by the value of thetablename
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.See Also
Home > Contents > Index > ![]()
Oracle JSP Tag Reference
Copyright (c) 2013, 2015, Oracle and/or its affiliates. All rights reserved.