PL/SQL (MOSC)

MOSC Banner

ORA-28004: invalid argument for function specified

in PL/SQL (MOSC) 4 commentsAnswered
CREATE OR REPLACE FUNCTION check_password_blacklist (
p_password IN VARCHAR2
) RETURN BOOLEAN
IS
v_blacklisted_count NUMBER;
BEGIN
SELECT COUNT(*)
INTO v_blacklisted_count
FROM TESTUSER.BLACKLIST_PASSWORDS
WHERE INSTR(LOWER(p_password), LOWER(password)) > 0;

IF v_blacklisted_count > 0 THEN
RETURN FALSE; -- Password contains a blacklisted string
ELSE
RETURN TRUE; -- Password does not contain any blacklisted string
END IF;
END check_password_blacklist;
/

Error is

SQL> alter profile test limit PASSWORD_VERIFY_FUNCTION CHECK_PASSWORD_BLACKLIST;
alter profile test limit PASSWORD_VERIFY_FUNCTION CHECK_PASSWORD_BLACKLIST
*
ERROR at line 1:
ORA-28004: invalid argument for function specified in PASSWORD_VERIFY_FUNCTION

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center