Home >	Contents >	Index >

Template Tags TOC   |    Alpha TOC   |    Tag Family TOC   |    Purpose TOC   |    Annotated TOC   |    Index

ics:literal

Formats literals for ics:callsql and other tasks beyond those for which ics: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.

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/>
       
<ics: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.

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