Can i merge the two select statments into single statement]]>jay_cooldude2013-03-15T20:37:51-00:00Re: Record Typeshttp://www.orafaq.com/forum/./mv/msg/186706/579829/#msg_579829
Regards
Michel
]]>Michel Cadot2013-03-15T21:12:18-00:00Re: Record Typeshttp://www.orafaq.com/forum/./mv/msg/186706/579831/#msg_579831
Can tell me how can you assign values of group of columns for two row type columns .

Thanks & Regards,

JAY.[EDITED by LF: removed awkward & unnecessary quote of the whole previous message]]]>jay_cooldude2013-03-15T21:40:32-00:00Re: Record Typeshttp://www.orafaq.com/forum/./mv/msg/186706/579850/#msg_579850
You have to assign each column to each field of your record.

Regards
Michel
]]>Michel Cadot2013-03-16T06:34:28-00:00Re: Record Typeshttp://www.orafaq.com/forum/./mv/msg/186706/579854/#msg_579854
suppose if you are doing like this you will be getting following error.

select e.*,d.* into v.u ,v.x from emp e,dept d where d.deptno=e.deptno and sal=800 ;
PLS-00494: coercion into multiple record targets not supported
Cause: The INTO list of a SELECT or FETCH specified more than a single record- type target and the column types required coercion into a record to match the INTO list. This is type checked as correct, but not yet supported.
Action: Create a new record type to hold all of the column types or code the SELECT with an INTO target for every source column.