if l_count > 0 then
    select PASSWORD into l_stored_password
    from X_USERS_DATA where USER_NAME=p_username;

create or replace function "USER_AUTH1" (p_username in VARCHAR2, p_password in VARCHAR2)
return BOOLEAN
is
  l_password varchar2(4000);
  l_stored_password varchar2(4000);
  l_expires_on date;
  l_count number;
begin
 select count(*) into l_count from X_USERS_DATA where UPPER(USER_NAME)=p_username;
if l_count > 0 then
    select PASSWORD into l_stored_password
    from X_USERS_DATA where USER_NAME=p_username;
  
    --  l_password := custom_hash(p_username, p_password);
return true;
   
     -- if l_password = l_stored_password then
       --return true;
      --else
       --return false;
      --end if;
  else
  return false;
end if;
end;​

ORA-01403: no data found
	Error	ERR-10460 Unable to run authentication credential check function.

user	B644B192324907444BC2AF4DDE66B41F