SQL & PL/SQL

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!

Case When sql with clob in criteria

700314Sep 1 2011 — edited Sep 1 2011

I have the following select statement with a "case when" that has a clob field in the criteria.
I get a ORA-00932 Inconsistent datatypes: expected - got CLOB error.

CASE WHEN FROM_FIELD = 'REOPEN'
THEN
(SELECT MIN(MODIFIED_DATE)
FROM RECORDS
WHERE MODIFIED_VALUE = 'CLOSE')
ELSE CLOSED_DATE
END
[/CODE]

There is a lot more to the SQL above, but it is basically what I am looking for.
Looking for help with how to run this with the CLOB field (Modified_Value) in the criteria.

This post has been answered by 884055 on Sep 1 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 29 2011

Added on Sep 1 2011

9 comments

1,046 views