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!

Convert Long to Char or Varchar issue

2879152Aug 2 2019 — edited Aug 2 2019

Im trying to convert Long data type to Char but getting this error

ORA-00932: inconsistent datatypes: expected CHAR got LONG

select TO_CHAR(SUBSTR(to_char(terms),0,3999)) FROM

term_table

Im trying this query in BI Publisher report and getting this error ORA-00932: inconsistent datatypes: expected CHAR got LONG

Please help me in converting Long data type column to Vrchar or char. or help me in any other solution

Added on Aug 2 2019

7 comments

32,975 views