Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Filtering on CLOB column throws ORA-00932

Toufiq - Hexagon PPMOct 13 2020 — edited Oct 14 2020

Hi,
I came across an issue in IG column level filtering. When I try applying a filter on an IG column of datatype CLOB from the filter available from column header I get Ajax call returned server error ORA-00932: inconsistent datatypes: expected - got CLOB for .

image.pngThis was seen in APEX 20.1 and also reproducible in APEX 20.2. Is this a bug? or Did I get any setting wrong?
Please note that filtering works fine when done using toolbar level filtering.
Thanks.
-- Toufiq

This post has been answered by Carsten Czarski-Oracle on Oct 15 2020
Jump to Answer
Comments
Post Details
Added on Oct 13 2020
7 comments
2,942 views