Hi,
I am trying to create the following procedure in POSTGRESQl
Could someone help me with this.
create function regyuser_rec(int) returns varchar as ' declare
v_userid alias for $1;
output_rec varchar(400);
user_rec record;
begin
select fname,lname,addrs into user_rec from user
where userid = v_userid;
output_rec := user_rec;
commit;
return output_rec;
end;
' language 'plpgsql';
When I run this procedure, I got an error:
attribute user_rec notfound.
Thanks,
Radhika
I am trying to create the following procedure in POSTGRESQl
Could someone help me with this.
create function regyuser_rec(int) returns varchar as ' declare
v_userid alias for $1;
output_rec varchar(400);
user_rec record;
begin
select fname,lname,addrs into user_rec from user
where userid = v_userid;
output_rec := user_rec;
commit;
return output_rec;
end;
' language 'plpgsql';
When I run this procedure, I got an error:
attribute user_rec notfound.
Thanks,
Radhika