Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

help needed in bulk collect into a record type

user13710379Jan 18 2012 — edited Jan 18 2012
hi, i tried to do bulk collect into a record type,but am getting error as "is in appropriate as left hand side of an assignment"

here are queries

open c_rtl_pickup_incr(p_branch_code,l_m_end_date);
fetch c_rtl_pickup_incr bulk collect
into ty_tb_temp_tab ;
close c_rtl_pickup_incr ;

record type that i used
type ty_tb_temp_tab is table of eitb_rtl_clg_stg%rowtype index by pls_integer;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2012
Added on Jan 18 2012
4 comments
207 views