create table login_details
(
  EMP_ID      VARCHAR2(10),
  USER_NAME   VARCHAR2(50),
  ID_PASSWORD NUMBER
);

create or replace procedure P_PASSWORD_ENCRYPT(par_id       in VARCHAR2,
                                               par_username in varchar2,
                                               par_password in number) is
  l_hash raw(2000);
begin
  l_hash := dbms_crypto.hash(utl_i18n.string_to_raw(par_password,
                                                    'AL32UTF8'),
                             dbms_crypto.hash_sh1);
  insert into login_details
    (EMP_ID, USER_NAME, ID_PASSWORD)
  values
    (par_id, par_username, l_hash);

end P_PASSWORD_ENCRYPT;

BEGIN
  P_PASS_ENCRYPT('IT_001','SCOTT',123456);
  END;