3 Replies Latest reply: Jun 15, 2008 10:49 PM by dmcghan RSS

    wwv_flow_item.md5

    SaadNayef
      Hi:
      Shouldn't wwv_flow_item.md5 return the hash value (for the famous md5 algoritm) for the input ?!
      for example, if I wrote this query:
      select wwv_flow_item.md5('SAAD') from dual;
      It will return:
      A2B0F0E5E3A47369F176FEC5F9BED56A
      ,but I tried md5 from a lot of websites and all of them return the same value which is:
      49cd19a74b6c39d4eb3316e9587c63c4

      WHY?

      Saad
        • 1. Re: wwv_flow_item.md5
          60437
          Our method separates each possible input value (up to fifty) from the next with a '|' delimiter character, so in your example the input string to the underlying md5 function becomes:

          'SAAD|||||||||||||||||||||||||||||||||||||||||||||||||'

          Scott
          • 2. Re: wwv_flow_item.md5
            Arie Geller
            Hello,

            If you want to learn a bit more about how APEX is using this mechanism (and possibly save yourself a lot of manual coding), go to APEX SQL Workshop => Object Browser => Create Package => Package with methods on database table(s). Choose a table to work with, and the system will create for you a package with all the DMLs you need for this table, including procedures that are using the MD5 algorithm.

            Regards,
            Arie.
            • 3. Re: wwv_flow_item.md5
              dmcghan
              Saad,

              You could check out tapiGen too, see the links below.

              Regards,
              Dan

              http://danielmcghan.us/
              http://sourceforge.net/projects/tapigen/