My Oracle Support Banner

Performance - Using SetSearchExpr method over SetSearchSpec, especially with regard to case-insensitive queries (Doc ID 476346.1)

Last updated on APRIL 01, 2018

Applies to:

Siebel Tools - Version 7.5.1 SIA [15026] and later
Information in this document applies to any platform.
Area(s):Siebel VB/eScript/COM
Release(s):V6 (Siebel 2000-Enterprise), V7 (Enterprise), V8 (Enterprise)
Database(s):DB2, Informix, Microsoft, Oracle, Sybase
App Server OS(s):AIX, Solaris, Windows 95, WFW 3.11, Windows NT, Windows 2000, Windows 3.1, HP-UX
Latest release tested against:V8 (Enterprise)
Keywords:SVB, eScript, performance, setsearchexpr, setsearchspec
This document was previously published as Siebel FAQ 1455.
Checked for relevance on 02-Apr-2018.


When querying a business component in code, the criteria for retrieval can be set using either the SetSearchSpec method or the SetSearchExpr method. SetSearchSpec sets the search specification for a particular field, whereas SetSearchExpr allows for the setting of an entire search expression on the business component.

The Siebel application architecture has been designed to generate efficient SQL. Under certain circumstances, a LIKE operator is created in the SQL statement. For example, if the parameter CaseInsensitive has been set to TRUE in the configuration (.cfg) file, an instruction like:

In some situations, a script might have to search for the exact string (case sensitive). How can this be achieved without changing the global CaseInsensitive parameter? 


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.