Thread: Procedure with out parameters.
Hi,
I can not get a procedure with output parameter created. Right now, I am getting error on the line of "uid := newid;". If I remove the line, I got error saying that "Function myuser_insert(...) does not exist". Can anyone point out what's wrong here? - thanks. I want to retrieve the new UserID generated by the insert command.
CREATE FUNCTION myuser_insert(IN" mail" "varchar", IN" pass" "varchar", OUT" uid" int8) AS
$BODY$declare
newid int8 := 0;
begin
$BODY$declare
newid int8 := 0;
begin
select into newid nextval('myuser_userid_seq');
insert into myuser (userid, email, pwd) values (newid, mail, pass);
uid := newid;
end$BODY$
LANGUAGE 'plpgsql' VOLATILE;
Yahoo! FareChase - Search multiple travel sites in one click.
On 11/23/05, Charles Bai <charlesbaiusa@yahoo.com> wrote: > Hi, > > I can not get a procedure with output parameter created. Right now, I am > getting error on the line of "uid := newid;". If I remove the line, I got > error saying that "Function myuser_insert(...) does not exist". Can anyone > point out what's wrong here? - thanks. I want to retrieve the new UserID > generated by the insert command. > > CREATE FUNCTION myuser_insert(IN" mail" "varchar", IN" pass" "varchar", OUT" > uid" int8) AS > $BODY$declare > newid int8 := 0; > begin > > select into newid nextval('myuser_userid_seq'); > > insert into myuser (userid, email, pwd) values (newid, mail, pass); > > uid := newid; > > end$BODY$ > LANGUAGE 'plpgsql' VOLATILE; > what is error message... for now suspect of this: > CREATE FUNCTION myuser_insert(IN" mail" "varchar", IN" pass" "varchar", OUT" > uid" int8) AS what are the quotes for? " mail": is this a valid name? check your function.... -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)