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 the EXECSQL XML tag. The table specified by the tablename must exist in the database prior to calling ics:sql. The resultset is cached against the table indicated by the value of the tablename 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

ics:callsql

ics:selectto

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