Data type to store more than 4000 character in oracle

hi guys,

I am new to Oracle. Have doubt on what data type can be used to store more than 4000 character. Tried with clob and blob but not working.
MANIKANDAN TConsultantAsked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
Within the context of pl/sql  you can declare varchar2 variables up to 32767 characters.

If you are using 12c your DBA can enable extended varchar2 types and then you can have SQL varchar2 values of 32K including table columns.

If you need more than that, then you should use CLOB.  As mentioned above by others, you'll need to provide some more context for us to help more as to exactly what is going wrong with your code.

Do note, the 12c extended varchar2 values are internally managed as small CLOB values

https://seanstuber.wordpress.com/2013/07/18/12c-big-strings-quasi-lobs/
0
 
ste5anSenior DeveloperCommented:
It's CLOB.

What does "not working" mean?
0
 
MANIKANDAN TConsultantAuthor Commented:
Getting error : inserted value too large for column
0
 
ste5anSenior DeveloperCommented:
Can you imagine, that no one here can know what you're doing, when you don't tell us anything about your context??

What do you do? Where are you doing this? How are you doing this? What is the complete and exact error message?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.