Compare Oracle password hash string with openLDAP password hash string

Hello,

From my 11.2 and 12.1 databases, I have to check if the oracle user password and the openLDAP directory password for the same user are the same, but the password value is unknown; so I will have to compare passwords hash strings.

From openLDAP directory, the ldapsearch command returns the following hash string for userpassword attribute:

e1NTSEF9b1dMZG43MGg5Sjc2dTdsQTVvWmdmcXpZa1ZuTmQyQjk= i.e. {SSHA}oWLdn70h9J76u7lA5oZgfqzYkVnNd2B9 after base64 decoding.

From Oracle database, I tested the following code (Oracle 11g Password algorithm revealed ):

14 DECLARE

15 lv_pwd_raw RAW(128);

16 lv_enc_raw RAW(2048);

17 lv_hash_found varchar2(300);