please... please... look at the code!
You are going to give hrishy a heart attack.
here is what you coded...
... does it makes sense to you?Code:23 if regexp_instr(password,regular_expr) > 0 THEN 24 -- raise_application_error(-20006, 'Password must contain at least one upper case letter.'); 25 return true; 26 end if; 27 -- if everything is fine return false. 28 RETURN (false);