i can't insert column value greater than 4000 characters at one instance e

i can't insert column value greater than 4000 characters at
one instance even i am using CLOB datatype . how to insert
efficiently more than 4000 characters ? And please let me
know how to impose inline and out-of line constraints on
oracle column???

Thanks in Advance...
Prakash

Question Posted / prakashdasari

2 Answers
9139 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i can't insert column value greater than 4000 characters at one instance even i am using CLOB ..

Answer / prakashdasari

we can solve this problem in two ways as of my knowledge.

1)Write that total information (>4000) in a file and upload this file to CLOB data type.

2)Another way is we need to split the string to <=4000 characters substrings and each one need to be append by using to_clob() function available in oracle.

for ex. to_clob('4000characters sub string') | to_clob('4000characters sub string') | to_clob('4000characters sub string') |....... so on.

i used second one for my requirement because i dont want to disturb my well developed product code.Just i added as a extra function.

Than Q...

Is This Answer Correct ?

5 Yes

0 No

i can't insert column value greater than 4000 characters at one instance even i am using CLOB ..

Answer / sushant

I also did same guyzzz !!!

Is This Answer Correct ?

3 Yes

0 No

Post New Answer