var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Appending to CLOB
What is the best way to append varchar2 data to temperory CLOB.
i keep doing this in a cursor
DBMS_LOB.WRITE(lc_doc, amount, offset, lc_header);
In the end i insert the clob into a clob column.I previously used varchar2,but due to its limitation i followed this method only to find it considerably slowed my transactions.
Is there any mistake that i have done?is there any better way for this?
Most performance issues I've seen with CLOBS are due to in-line storage.
You might consider creating a CLOB tablespace, storing your tables in their normal space with the LOBs out of line in the separate CLOB tablespace.
Amend some of the parameters (such as NOLOGGING) as required.
ALTER TABLE <tablename>
MOVE TABLESPACE <normal_ts>
LOB (<list_of_lob_columns>) STORE AS
ENABLE STORAGE IN ROW
Maybe that will help?