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

 

CALLSQL

Retrieves and executes an SQL query stored in the SystemSQL table.

Syntax

Parameters

QRYNAME (required)
Name of query to retrieve and execute.

LIST (required)
Name of list to contain resultset.

LIMIT (optional)
Maximum number of rows in the resultset. Note that there is no limit if the parameters are missing or set to a negative number.

Description

The CALLSQL tag retrieves and executes an SQL query stored in the SystemSQL table. The resultset of the query is cached against the table name specified for the query in the SystemSQL table. The table name must exist in the database prior to calling CALLSQL.

Note

The deftable column in the SystemSQL table can specify a comma-separated list of table names.

Error Numbers

The possible values of errno include:

Value
Description
-15
No file found.
-101
No rows found.
-102
Empty column.
-103
No such table.
-104
No table definition.
-106
Bad parameter.

Example

This example executes a query called gettables and stores the resultset in newrs. The tblname and defdir for each row in newrs are displayed.

See Also

EXECSQL
RENAMELIST
SELECTTO
ICS.LITERAL

  Home > Contents > Index >

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