1 Reply Latest reply: Jan 28, 2013 4:29 PM by Mike, UK RSS

    CLOB_CONTENT with jsignature size limit

    Mike, UK
      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
        • 1. Re: CLOB_CONTENT with jsignature size limit
          jariola
          Hi,

          This my sample app might help to send large values to database.
          http://dbswh.webhop.net/htmldb/f?p=BLOG:READ:0::::ARTICLE:2939900346183772

          Idea is split data to array e.g. f01 and then combine it in database.

          Regards,
          Jari
          -----
          My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0
          Twitter: http://www.twitter.com/jariolai