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

hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

2159

---

What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4610

---

What do you understand by oracle forms and why are they required?

1002

---

Explain master-detail relationship with some examples.

1001

---

Name the different triggers associated with oracle forms having a master-detail relationship.

992

---

What do we mean by record group in oracle forms?

1062

---

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

2115

---

how do u compile a form i.e .fmb file in Unix or in dos

4565

---

what are the oracle forms services components include?

1019

---

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2124

---

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1441

---

what is the difference between call_form, new_form and open_form?

1295

---

Can we invoke one form from another in a multi-forms application?

1121

---

suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables

2014

---

What is an oracle report?

1048

---