sql - update column with large xml using dbms_lob -


i have update column xml of 252000 char. have tried how insert/update larger size of data in oracle tables? still got error 'string literal long'.

i want write code dbms_lob package this:

declare   c1 clob;   c2 varchar2(32000); begin   c1 := 'abc';   c2 := 'text, contains 32 000 characters';   dbms_lob.append(c1, c2);   c2 := 'some more text, contains 32 000 characters';   dbms_lob.append(c1, c2);   c2 := 'some more text, contains 32 000 characters';   dbms_lob.append(c1, c2);   c2 := 'some more text, contains 32 000 characters';   dbms_lob.append(c1, c2);   c2 := 'some more text, contains 32 000 characters';   dbms_lob.append(c1, c2);   c2 := 'some more text, contains 32 000 characters';   dbms_lob.append(c1, c2);   c2 := 'some more text, contains 32 000 characters';   dbms_lob.append(c1, c2);   c2 := 'last text, contains 27 372 characters';   dbms_lob.append(c1, c2);   update table set d1= c1 d2id=12; end; 

are there other way write query, can put whole xml in one?


Comments

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -