| From: | dbatoCloud Solution <dbatocloud17(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | postgresql dbms_utility error ! |
| Date: | 2021-12-13 06:26:40 |
| Message-ID: | CAEz7P_uiRrEA6UWeHRkTo2nHAb=vtWmhWXiV538QDtDmGxb3Hg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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 IF
SQL state: 3F000
Thanks
Ashok
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Ashokkumar Mani
+91 81975 99922
W: https://dbatocloudsolution.blogspot.in/
<http://dbatocloudsolution.blogspot.in/> | E: dbatocloud17(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daulat | 2021-12-13 08:05:30 | Limits user connection in pgbouncer |
| Previous Message | dbatoCloud Solution | 2021-12-13 04:14:28 | Re: package conversion error from oracle to postgresql database !!!!!!!!! |