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" />
- Name of table.
- Name of column in the table.
- String that needs to be formatted into a literal for the specified column.
- Variable name where the literal is placed.
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.datetimedata types, Sites uses the
cc.bigtext,it uses the
The possible values of
Value Description -100 General exception error. -103 Invalid table name. -106 Invalid column name. -10004 Missing required parameter.
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.
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.