LOV - List of Value Queries with 30 Characters Generate Errors: ORA-24345, SBL-DAT-00500 and SBL-DBC-00105
Last updated on JUNE 05, 2017
Applies to:Siebel CRM - Version 8.0  and later
Information in this document applies to any platform.
Product Release: V8 (Enterprise)
Version: 8.0 
Database: Oracle 10.2.0.2
Application Server OS: Microsoft Windows 2003 Server SP2
Database Server OS: Microsoft Windows 2003 Server SP2
This document was previously published as Siebel SR 38-3357468797.
***Checked for relevance on 19-March-2012***
***Checked for relevance on 9-July-2014***
While querying list of values (LOV's) for COUNTRY typed LOVS, not all records were getting retrieved.
In the spool file, it showed that the following query retrieved 52 records.:
SELECT statement with ID: C2CA278
SELECT /*+ ALL_ROWS */
((T1.ACTIVE_FLG = :1 OR T1.ACTIVE_FLG IS NULL) AND
(T1.CODE != 'CLASS' OR T1.CODE IS NULL) AND
(T1.TYPE = :2 AND T1.BU_ID IS NULL))
Bind variable 1: Y
Bind variable 2: COUNTRY
The same SQL statement when executed directly against the database (using Toad or other SQL tool) retrieved 240 records.
Also, scrolling through the View 'List of Values View' by filtering for TYPE = COUNTRY the following error message appears:
SBL-DAT-00500 - 'There were more rows than could be returned. Please refine your query to bring back fewer rows' Please continue or ask your systems administrator to check your application configuration if the problems persists. (SBL-DBC-00105)
ORA-24345: A Truncation or null fetch error occurred.
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