Query With Like in Where Clause Returns No Rows After Upgrade to 22.214.171.124
(Doc ID 550123.1)
Last updated on MARCH 17, 2008
Applies to:Oracle Financial Services Applications (OFSA) 4.5.39
Oracle Financial Data Manager - Version: 4.5.39
This problem can occur on any platform.
After upgrading the OFSA database from Oracle 126.96.36.199 to 188.8.131.52, a SQL query that uses "like" in its where clause against a column with a datatype of CHAR returns no rows in SQL Talk. The same query returned rows in Oracle 184.108.40.206.
select to_char(CURRENT_EOM,'mm/dd/yyyy') from naa_processdate where APPLICATION = 'ALLOCATION';
-- Returns rows
select to_char(CURRENT_EOM,'mm/dd/yyyy') from naa_processdate where APPLICATION LIKE 'ALLOCATION';
-- No rows returned in Oracle 220.127.116.11
The APPLICATION column has the following definition:
APPLICATION NOT NULL CHAR(15)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document