Oracle Database Discussions

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!

Compile view and got error inconsistent data type error expected got CLOB

N_RajMar 20 2018 — edited Mar 20 2018

Hi All,

We have Oracle DB 11.2 on Aix 7.

We recently changed the column from varchar2(4000) to clob for a table due to application upgrade ( not database upgrade ) like adding new column/table ,remove unwanted column and etc.

We have few views based on that table.After changing datatype,view not working due to inconsistent data type error expected got CLOB when compile

Sorry i couldn't share any definition of table here

Any Suggestions

Thanks & Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 17 2018

Added on Mar 20 2018

#general-database-discussions

5 comments

250 views