APEX

Hi,
I'm using the following code to record a signature (using jsignature), store it in the CLOB_CONTENT collection and write the result to the database (Using Carl's technique here http://carlback.blogspot.co.uk/2008/04/new-stuff-4-over-head-with-clob.html).

This all works fine up to a certain size limit, which I presume is the 32k mod pl/sql limit, at which point I get a 'bad request' browser error. Is there a way to work around this limit?

Thanks,

Mike

<script type="text/javascript">
   $(document).ready(function() {
   $("#signature5").jSignature()
})

function clob_set(){  
    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){  
                $s('P270_SIGNATURE_DROP',p.responseText);  
                $x_Hide('AjaxLoading');  
            }else{return false;}  
        }  
    );  
  
    if(!$v_IsEmpty('P270_SIGNATURE'))
    {
    clob_ob._set($v('P270_SIGNATURE'))
    };  
}

function setpageItem(sig)
{
   $x(P270_SIGNATURE).value = sig;
   clob_set();
   doSubmit('SUBMIT');
}


</script>

</p>
<div id="signature5"></div>
<p>
<button type="button" onclick="setpageItem($('#signature5').jSignature('getData'))" data-role="button" data-theme="b">Sign off inspection</button>
</p>
</div>

Edited by: Mike, UK on Jan 28, 2013 10:28 PM