dbms_obfuscation_toolkit.md5 -- problem upgrade from 10.2.0.3 to 10.2.0.4
Column dsu_password is defined:
DSU_PASSWORD VARCHAR2(60 BYTE) NOT NULL,
DSU_PASSWORD VARCHAR2(60 BYTE) NOT NULL,
The following procedure returns 'Good Match' in 10.2.0.3 but returns 'Bad Match' in 10.2.0.4. Remember the table value was created in 10.2.0.3:
create or replace function dip_password(pin_username in varchar2, pin_password in varchar2) RETURN varchar2 as
CURSOR check_cur IS SELECT * FROM dipuser.dip_system_users
WHERE UPPER(dsu_logname) = UPPER(pin_username)