apex.ajax.clob - retrieving data from a clob field
650665Oct 29 2008 — edited Feb 9 2010I have an application that uses a table that stores xml data, and the field in the table that stores the data is a clob. I used Carl Backstrom's example to build what I have so far, (God's blessings on his family). Here is the script I use to store the data from an HTML Editor into the database:
function clob_set(request){
var oEditor = FCKeditorAPI.GetInstance('P59_CONTENT');
var clob_ob = new apex.ajax.clob(
function(){
var rs = p.readyState
if(rs == 1||rs == 2||rs == 3){
$x_Show('AjaxLoading');
}else if(rs == 4){
$x_Hide('AjaxLoading');
$s('P59_CONT', p.responseText);
doSubmit(request)
}else{return false;}
}
);
$x('P59_CONT').value = oEditor.GetHTML();
oEditor.SetHTML('');
if(!$v_IsEmpty('P59_CONT')){clob_ob._set($v('P59_CONT'))};
}
The submit calls a process that inserts the data from the clob001 field in the CLOB_CONTENT collection into my table.
How do I get the data out of the table again to present in the HTML Editor? Each option I use gets me into trouble with the 32k length limitation that is extant in Apex. What would be the best way to address this?