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

Explain the various types of oracle report?

1086

---

What is an SQL FORMS ?

2799

---

can you convert or reverse engineer a fmx back to a fmb file?

1168

---

What is an implicit anchor and how is it a different form explicit anchor in a report builder?

1168

---

What do you understand by lov?

1041

---

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

2028

---

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

3251

---

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2331

---

What are the various configuration files that are used by oracle forms?

1036

---

what is tripstop report?

1844

---

What is responsibility and how u attach How to create user and how u attach with responsibility.

2046

---

why the Ctl file u put only in bin folder why not in other folder

2053

---

I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

1216

---

What is the difference between BPA AND Contract What are documents and test cases u followed

2388

---

What is an oracle report? List its various types.

979

---