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

ICS.SQLEXP

Allows building of the components of a SQL where clause without direct knowledge of the data type of a column and the database-specific rules for specifying a literal for that column.

Syntax

<ICS.SQLEXP     
      COLUMN="column name"
      OUTPUT="variable name"
      STRING="string"
      TABLE="table name"
      [TYPE="logical operator"]
      VERB="comparison operator"
      [EXPRESSION="expression"]/>

Parameters

COLUMN (required)

Name of the column in the table.

OUTPUT (required)

Name of the output variable.

STRING (required)

Value or values to compare against.

TABLE (required)

Name of the table.

TYPE (optional)

Logical operator to use between. Default is AND.

VERB (required)

Comparison operator.

EXPRESSION (optional)

Column expression to be used instead of the column name.

Error Numbers

The possible values of errno include:

Value	Description
-100	Exception error
-103	Invalid table name
-106	Bad parameter value
-406	Bad parameter value
-10004	Missing required attribute

Release Introduced

This tag was introduced in CS release 5.0.

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