code to check the password at least one upper case letter

[hrishy]

Hi

The way to test the function is

set serveroutput on

begin
if trina_verify_function('TRINA','trina_55555555555','trina') then
  dbms_output.put_line('True');
else
  dbms_output.put_line('False');
end if ;
end ;

/

begin
if trina_verify_function('TRINA','trinA_5555555555', 'trina')
 then
  dbms_output.put_line('True');
else
  dbms_output.put_line('False');
end if ;
end ;

/

and not by running

select trina_verify_function('TRINA','trinA_5555555555', 'trina')
from dual

23 if regexp_instr('password','regular_expr') > 0 THEN
is wrong it shoud read instead

if regexp_instr(password,regular_expr) > 0 THEN