Answer / sudipta santra

Yes we can use bulk collect but in a too much trickery way,
if we can't access our nose straight then we have to bend
our hand to touch, that's what. Giving you as example step
by step,carefully try to get it, otherwise call me,
explain(+91-8951011605)

1. u will create type : (DB Level)
create or replace type blk_type_ex as object (
v varchar2(10),i number);
2. create or replace type blk_typ_frm as table of blk_type_ex;
3. In forms level in the trigger of
When-New-Instance/When-New-Block-Instance/When-New-Item-Instance
otherwise whatever the trigger is applicable for the
application specific , u create GTT as below:
create global temporary table GTT_vn (
v varchar2(10),
i number
) on commit preserve rows;
4. put the insertion code either in Post-Query or in
On-Commit trigger where the transaction was
occurred(insertion of rows) and which the datas are required
to be bulk collect.
5. Create DB/Form level function:
create or replace function f_blk_form return blk_typ_frm as
ret blk_typ_frm;
begin
execute immediate 'select blk_type_ex(v,i) from GTT_vn'||
'bulk collect into ret';

return ret;
end;
6.In particular trigger where U need to set the bulk collect
, there U need to set the code below:
declare
x blk_typ_frm;
begin
x := f_blk_form;
go_block(block_x);
first_record;
for r in (select * from table(cast(x as blk_typ_frm)))
loop
/*the below code */
:block_x.item1:=r.v;
:block_x.item2:=r.i;
next_record;
end loop;

end;
8. Compile +Run then Njoy. If u have any issue, then call me

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

0 Answers  

---

What is the maximum no of chars the parameter can store?

1 Answers  

---

Where is the external query executed at the client or the server?

2 Answers   Wipro,

---

What ERASE package procedure does ?

1 Answers  

---

What are the different default triggers created when Master Deletes Property is set to isolated?

1 Answers  

---

What is the sequence the Report triggers will fires while running a report ?

1 Answers   FCS, GE,

---

what are Navigational Triggers?

1 Answers  

---

How do you trap the error in forms 3.0 ?

1 Answers  

---

What is the usage of the Flex mode in Layout Editor ?

2 Answers   Convergys,

---

What is the built_in routine used to count the no of rows in a group?

1 Answers  

---

To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

2 Answers  

---

running a report from Form or other Report , The Parameter Form Page will be Display first . I don?t want to display the screen . What I have to do ?

1 Answers   Convergys,

---