ExecuteQuery incorrect behaviour and throwing error SBL-DAT-00500

(Doc ID 544384.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 7.5.2.100 [15252] and later
z*OBSOLETE: Microsoft Windows 2000
Database: Oracle 8.1.7
Application Server OS: Microsoft Windows 2000 Advanced Server SP 2
Database Server OS: Compaq Tru64 UNIX

This document was previously published as Siebel SR 38-1067384691.

Checked for Relevance on 23-Oct-2013
Checked for Relevance on 03-Jan-2017

Symptoms

Incorrect behaviour with ExecuteQuery function in eScript.

Description of the problem:

There are 253 records associated to the SearchExpr I build for the BusComp (), but
when I execute a query using eScript, Siebel is not returning all the records that are available for the SearchExpr I had set.

It is returning only 123 records, but more strange is that if I capture the SQL generated by Siebel, using the Trace function and then I execute this SQL directly in Oracle, all the 253 records are returned.

ViewMode was set to AllView in the script and Maximum Cursor Size and PreFetch Size properties of de BusComp are not informed.

Cause

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 hundreds of Community platforms