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

ICS.LITERAL

Formats literals for CALLSQL and other tasks beyond those for which SQLEXP is designed.

Syntax

<ICS.LITERAL
      TABLE="table name"
      COLUMN="column name"
      STRING="string"
      OUTPUT="variable name" />

Parameters

TABLE (required)

Name of table.

COLUMN (required)

Name of column in the table.

STRING (required)

String that needs to be formatted into a literal for the specified column.

OUTPUT (required)

Variable name where the literal is placed.

Description

Specifying the table name and column name, Sites determines which type of literal to create. Sites has database-specified properties to help it format both string (cc.stringpicture) and timestamp literals (cc.datepicture). For cc.datetime data types, Sites uses the cc.datepicture property. For cc.char, cc.varchar, and cc.bigtext, it uses the cc.stringpicture property.

Error Numbers

The possible values of errno include:

Value	Description
-100	General exception error.
-103	Invalid table name.
-106	Invalid column name.
-10004	Missing required parameter.

Example

The following query, named myquery, exists in the SystemSQL table.

SELECT * FROM Name WHERE firstname = Variables.firstliteral

The query is called in an element as follows:

<ICS.LITERAL 
	 TABLE="Name"
	 COLUMN="firstname"
	 STRING="Bubba"
	 OUTPUT="firstliteral"/>
    
<ics.clearerrno/>
       
<CALLSQL QRYNAME="myquery" LIST="mylist"/>

In this example, Bubba is the string to be converted to a literal. The string is formatted according to the properties set for the database.

Release Introduced

This tag was introduced in CS release 5.0.

See Also

CALLSQL

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