Skip to Main Content

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!

ORA-22835 - Error while selecting VARCHAR2(4000) field

3354507Nov 29 2016 — edited Nov 29 2016

Hi,

I am using Oracle SQL Developer 1.5.5.

I am querying a description column (TERM_DESCRIPTION) from Informatica Business Glossary View MRX_BG_TERM and i came across ORA-22835. Here is the screenshot

pastedImage_0.png

This column has datatype as VARCHAR2(4000). But it appears to be oracle is considering this as CLOB and suggested the action items.

  • Still I went ahead and tried actions it listed (using Substr, dbms_lob.substr ) but none of them worked
  • Tried looking for maximum length, it has thrown the same error ORA-22835
  • I also tried casting field (TERM_DESCRIPTION) as LONG CHAR(5000), this time it has thrown a different error ORA-00600

Can anyone please help me with the way to read the description column.

Thanks,

Shravan

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 27 2016
Added on Nov 29 2016
3 comments
482 views