• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 12381
  • Last Modified:

MD5 - Oracle 9i

Hi all, I need to do this:

extracting last sequence then applying to it the Oracke 9i built-in MD5 function

also I need to know what is type of the PK field I have to use ...maybe VARCHAR2(32)

tnx n regards

D-
0
amolabravo
Asked:
amolabravo
  • 3
  • 2
1 Solution
 
konektorCommented:
md5 is part of dbms_obfuscation_toolkit package

    PROCEDURE MD5(input    IN  RAW,
                  checksum OUT raw_checksum);

    FUNCTION MD5(input    IN  RAW)
        RETURN raw_checksum;

    PROCEDURE MD5(input_string    IN     VARCHAR2,
                  checksum_string    OUT varchar2_checksum);

    FUNCTION MD5(input_string    IN     VARCHAR2)
        RETURN varchar2_checksum;
0
 
amolabravoAuthor Commented:
Hi konektor, does this toolkit is shipped with Oracle 9i?

tnx
0
 
konektorCommented:
yes, sys is owner of it.
i don't know if u have to choose some special option during installation, but i have the package on all instances i have access to.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
amolabravoAuthor Commented:
hi, can u send me an example of the application to this function to a simple query? ...also I can call it directly from a query embedded in the code ?

tnx n regards
0
 
earth man2Commented:
SQL> create or replace function md5( input varchar2 ) return sys.dbms_obfuscation_toolkit.varchar2_checksum as
begin
  return sys.dbms_obfuscation_toolkit.md5( input_string => input );
 end;
/

SQL> select md5('Hello World !' ) from dual;
MD5('HELLOWORLD!')
----------------------------
╣ƒ>⌠☺┐ß┐$┐o┐c╣α♠
0
 
konektorCommented:
SQL> declare
  2    x varchar2(100) := 'abcdefghijklmnopqrstuvwxyz';
  3    y dbms_obfuscation_toolkit.varchar2_checksum;
  4  begin
  5    dbms_obfuscation_toolkit.md5(input_string => x, checksum_string => y);
  6    dbms_output.put_line(y);
  7  end;
  8  /
ÃüÓ×a’ä
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now