Answer Posted / shailesh

Yes u can write directly write a coomit; in any of the
report trigger.

e.g I have created a report and written in before report
trigger
update scott.emp set ename='SMITH_1' where ename
like 'SMITH';
commit;


It worked

Is it possible to execute a dynamic sql from forms?

1059

---

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

2366

---

List the different types of columns in oracle reports.

980

---

what are the oracle forms services components include?

1007

---

what is oracle forms?

1096

---

what are the new features introduced in oracle form services in 11g release 2?

1021

---

Explain how one can iterate through items and records in a specified block?

1096

---

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

2102

---

Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.

2212

---

What is a canvas in oracle forms?

1050

---

What do we mean by record group in oracle forms?

1052

---

Explain how can you use the same lov for 2 columns?

1114

---

if u want to delete all these detail block etc what will happen in form

1968

---

i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

2972

---

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

1995

---