An issue I found is that the cast_to_raw (PL/SQL) returns hexadecimal using A-F, and the encryption algorithm is case sensitive, and thus a-f.

I used lower to ensure they are all lowercase and got the expected raw_txt.

However, I am still stuck getting the expected hashed value.