title: Differences between Oracle and tomcat md5 hash?
body: <p>when using oracle forms to generate md5 hash, i get result that is different from the result given by tomcat.</p>
  
  <p>when using tomcat digest, i get:</p>
  
  <pre><code>C:\apache-tomcat-6.0.26\bin&gt;digest -a md5 mypass
  mypass:a029d0df84eb5549c641e04a9ef389e5
  </code></pre>
  
  <p>while using oracle forms, i get:</p>
  
  <blockquote>
    <p>a029d0dfbfeb5549c641e04abff3bfe5</p>
  </blockquote>
  
  <p>this is the code:</p>
  
  <pre><code>Declare
      v_checksum varchar2( 32 );
      v_hex_value varchar2( 32 );
  begin
      v_checksum := SYS.DBMS_OBFUSCATION_TOOLKIT.MD5( input_string =&gt; 'mypass' );
  
  
      SELECT  LOWER( RAWTOHEX( v_checksum ) ) 
      INTO    v_hex_value
      FROM    dual;
  
      :res := v_hex_value;
  end; 
  </code></pre>
  
  <p>why aren't they giving the same result ? is there something wrong with my code ?</p>