ExecuteQuery incorrect behaviour and throwing error SBL-DAT-00500
Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 18.104.22.168  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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms