Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

apex.ajax.clob - retrieving data from a clob field

650665Oct 29 2008 — edited Feb 9 2010
I 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?
This post has been answered by Ramon van der Weiden on Oct 30 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 9 2010
Added on Oct 29 2008
24 comments
19,407 views