pass parameter to oracle procedure from ASP

[maswien]

I tried many ways to pass parameter from ASP to oracle, but no luck.

for example,

Set md5 = CreateObject("carnaby.vbmd5")
set param = comm.createparameter("pid",200,1,50, TRIM(Request("hidentifier")))
set param = comm.createparameter("email",200,1, 50, TRIM(Request("hemail")))
set param = comm.createparameter("pass",200,1, 50, md5.DigestStrToHexStr(TRIM(Request("hpassword"))))
set param = comm.createparameter("ret",3,2, 4)
comm.parameters.append param

My procedure is:

create or replace procedure sp_adduser
(pid in contact.person_id%type,
email in contact.e_mail%type,
pass in contact.password%type,
ret out number )
as
cnt number;
begin
select count(*) into cnt from contact where person_id=pid;
if cnt > 0 then
ret:=1;
else
insert into contact (person_id, e_mail, password, last_changed) values(pid, email,pass, sysdate);
ret:=0;
end if;

EXCEPTION
when PROGRAM_ERROR then
ret:=1;
when others then
ret:=1;

return;
end sp_adduser;


I kept get the error:

00306: wrong number or types of arguments in call to 'SP_ADDUSER' ORA-06550: line 1, column 7: PL/SQL:


What I did wrong?


Thanks