Page 1 of 1
Case Insensitive Lookup Throwing a Warning
Posted: Sun Apr 29, 2012 8:47 pm
by jerome_rajan
Hi All,
I am trying to do a case insensitive lookup on a varchar2(255) NOT Nullable column but am getting the following warning
Unrecognized Type specific format: {case-insensitve} on Key "COL_NM".
What could the reason be?
Posted: Sun Apr 29, 2012 8:52 pm
by ray.wurlod
Did you create the record schema manually?
If not, you seem to have uncovered a bug, which you should report to your official support provider.
Re: Case Insensitive Lookup Throwing a Warning
Posted: Sun Apr 29, 2012 8:56 pm
by SURA
varchar2(255)
VS
varchar(255)
Posted: Sun Apr 29, 2012 9:01 pm
by jerome_rajan
Thanks for the reply. I did not create the schema manually. In fact, I am sourcing it from an Oracle table.
The actual lookup is being performed on two keys - one of which is this varchar column and the other is an integer. Could this be a problem though I don't see any reason for that.
Re: Case Insensitive Lookup Throwing a Warning
Posted: Sun Apr 29, 2012 9:02 pm
by jerome_rajan
SURA wrote:varchar2(255)
VS
varchar(255)
Sorry, I meant varchar(255)