Answer Posted / 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

I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

2917

---

difference between global n context sensitive segments?

2629

---

In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

1849

---

i am writing a query select EmpNo from Emp how can i call in after parameter form

2047

---

if some data is not transfered where it will get stored

1883

---

What is a user exit program in oracle reports?

964

---

a text item is there what r the different types of triggers associated with it

1938

---

List the different types of columns in oracle reports.

936

---

all steps of bitmap report?

2299

---

what are bind variables?

1017

---

hiding item in report how like that properly,thats manually but at runtime i want to do

3146

---

Explain the different levels at which oracle form services interact.

1001

---

how report can be generated if we have the database designed in oracle 10g?

1831

---

in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory

2857

---

What do you understand by oracle forms?

974

---