set serveroutput on;
create or replace procedure createUser (username in string, pass in string,
auth_image in number, sec_question in string, sec_answer in string) is
user_name users.user_id%type;
pass_word users.password%type;
image users.image%type;
ques users.question%type;
ans users.question%type;
begin
insert into users (user_name, pass_word,image, ques,ans) values (username,
pass, auth_image,sec_question, sec_answer);
commit;
end;