How do you return values with Procedures?

From: Sean Dolan <dolans_at_stripe.Colorado.EDU>
Date: 23 Feb 99 19:06:28 GMT
Message-ID: <dolans.919796788@stripe.Colorado.EDU>

        I have a simple procedure that takes in a VARCHAR2 and outputs a number while doing an insert: (id out NUMBER, email in VARCHAR2)
IS
BEGIN

	select foo_seq.nextval into id from dual;
	insert into foo(id, email, visit_date)
         values(id, email, sysdate);

end;

 So when I call it, I use "exec testDemo('me_at_here.com');" and I get the error:

ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'TESTDEMO'
ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

What am I doing wrong?

Thanks,
Sean Dolan
sean_at_3si.com Received on Tue Feb 23 1999 - 13:06:28 CST