DECLARE 
  p_user_id      NUMBER; 
   TYPE membernumberlist IS TABLE OF VARCHAR2(11); 
   membernumbers  MEMBERNUMBERLIST := Membernumberlist('prodsupport','ownerwebteam'); 
   TYPE passwordlist IS TABLE OF VARCHAR2(11); 
   passwords      PASSWORDLIST := Passwordlist('margate01','orlando01'); 
BEGIN 
  FOR i IN membernumbers.FIRST.. membernumbers.LAST LOOP 
    dbms_output.Put_line('looping'); 
     
    SELECT hibernate_sequence.nextval 
    INTO   p_user_id 
    FROM   dual; 
     
    INSERT INTO users 
               (user_id, 
                user_name, 
                PASSWORD, 
                email, 
                security_question, 
                security_answer, 
                disabled_flag, 
                deleted_flag, 
                lockout_flag, 
                created_time) 
    VALUES     (p_user_id, 
                Membernumbers(i), 
                Passwords(i), 
                'abc@xyx.com', 
                'Please do not use the forgot password function on this account', 
                Passwords(i), 
                0, 
                0, 
                0, 
                SYSDATE); 
     
    INSERT INTO user_role 
               (user_role_id, 
                role_id, 
                user_id) 
    VALUES     (hibernate_sequence.nextval, 
                283, 
                p_user_id); 
     
    INSERT INTO user_properties 
               (user_properties_id, 
                property_id, 
                user_id, 
                VALUE) 
    VALUES     (hibernate_sequence.nextval, 
                215, 
                p_user_id, 
                Membernumbers(i)); 
  END LOOP; 
EXCEPTION 
  WHEN OTHERS THEN 
    dbms_output.Put_line('inserting admin failed'); 
END;

ORA-06502: PL/SQL: numeric or value error: character string buffer too small