knagaev
2012-12-19 14:56:07
What are you using when operate with CLOB?
In all events you can do it with PL/SQL
DECLARE
str varchar2(32767);
BEGIN
str := 'Very-very-...-very-very-very-very-very-very long string value';
update t1 set col1 = str;
END;
/
热门帖子
热门github
6
Thank you, but CI is not supporting these procedure stuffs stackoverflow.com/questions/13946641/…
I guess you can wrap this code in a procedure and Codeigniter can execute it. Sorry but I don't have Codeigniter for checking. Look here link
Did it, but could I define that size of varchar2, check this link, stackoverflow.com/questions/13947222/…
Will this info (http://www.oracle.com/technetwork/articles/fuecks-lobs-095315.html) be useful for you?
I don't know what I have changed somewhere, but this is working fine now. Thanks. But still I am not clear why the same thing did not work from straight query. Is it always we have to do like this for storing string having 4000 and more characters ?