CODEWITHSUNDEEP
sqloracle-database
user2636874
user2636874

Reputation: 899

What datatype can I use to store a string of 15000+ characters?

I have a string of more than 15000 characters.

I'm using long datatype to store the above string, but getting "string literal too long" exception.

Which datatype I should use to store that string in Oracle?

Upvotes: 0

Views: 407

Answers (1)

Littlefoot
Littlefoot

Reputation: 142710

That would be a CLOB.

Furthermore, quoting what Alex Poole said in his comment:

But you will have the same issue trying to assign a value to it. You need to build it up in chunks

Upvotes: 4

Related Questions