ORA-28003; password verification failed AFTER upgrade to 19c
Hi
We recently upgraded one of our databases from 12.2 to 19.8
One of the functions that uses to work just fine in 12c is now not working with the following error
In all our 12 c databases, it works fine but in 19c it errors out with this error
ORA-28003: password verification for the specified password failed
ORA-06550; line 1, column 106:
PLS-00905; object SYS.OURCOMPANY_VERIFY_FUNCTION is invalid
ORA-06550; line 1, column 98;
PL/SQL: statement ignored
Here is the DDL of the function
CREATE OR REPLACE FUNCTION SYS.ourcompany_verify_function
(username varchar2,
password varchar2,
old_password varchar2)
RETURN boolean IS
differ integer;