Updating a clob

DATA_TABLE " " "(ID, NAME, DESC, CLOB_FIELD) " "VALUES (?

The code above works just fine so long as v_query Answer: You may want to use a CLOB datatype for this.

A requirement that comes up a lot is the need to store strings longer than 4000 characters in the database, and this presents a problem.

Up to and including Oracle 11g R2 the longest varchar2 that can be stored in the database is 4000 characters.

I have heard that will change to 32K characters in Oracle 12c, but that hasn't been released yet, and when it is, it will be some time before it is widely adopted.

For this post, I am not concerned about storing strings that are many mega or gigabytes long - I am more interested in strings that are generally a few thousand characters up to about 32kb in size.

Search for updating a clob:

updating a clob-64updating a clob-55updating a clob-13

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “updating a clob”

  1. Research shows that just two years ago, mentioning your non-meating-eating ways on dating sites curbed the likelihood that’d you find a significant other—but now, it’s actually a super-attractive quality.

  2. Distract me with tips and help me to beat a record of 42 orgasms ヽ ‘ ∇‘ ノ If you don t see menu type /tipmenu - Multi-Goal : Every goal is orgasm ●ヮ● #gamer #new #teen #lovense #domi #toy #tight #pussy #b Shh...