> regy1'> output_rec := user_rec;
Here you can't assign the entire record (user_rec) into a variable. You
can assign either one of the following.
1. output_rec := user_rec.fname;
2. output_rec := user_rec.lname;
3. output_rec := user_rec.fname || user_rec.lname (This will concantenate
the two f
Hi ,
I am trying to create a stored procedure that
returns a user defined type. The following piece of code shows the way I am
trying to do it.
regy1=> create function regyuser_rec(int)
returns varchar as ' declareregy1'> v_userid alias for $1;regy1'>
output_rec varchar(400);regy1'> user_rec
