Hi All,
While accessing postgresql function i am getting this below error . could you please help on it ?
ERROR: schema "dbms_utility" does not exist
LINE 1: SELECT ltrim(to_char(dbms_utility.get_hash_value(upper(p_use... ^ QUERY: SELECT ltrim(to_char(dbms_utility.get_hash_value(upper(p_username)||'/'||p_password, 1000000000, power(2,30)), rpad('X',19,'X')||'X')) CONTEXT: PL/pgSQL function pkg_password_control.digest(text,text) line 3 at RETURN PL/pgSQL function pkg_password_control.compare(text,text) line 12 at IFSQL state: 3F000
Thanks
Ashok
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Ashokkumar Mani
+91 81975 99922
W: https://dbatocloudsolution.blogspot.in/
| E: dbatocloud17@xxxxxxxxx