Answer / rajesh

No u can write commit before report trigger

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

Answer / pushpendra saini

yes u can do commit in Before report trigger

Answer / lreddy

NO, IN Before Report Trigger we can use SRW.DO_SQL to
perform any DDL Operations.
For DDL Operations are internal commit.
so no need to use Commit statement in Before Reprot Trigger.

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.

0 Answers  

---

suppose there are two textfields t1,t2 in form and we have some value in textfield t1.now the question is that how can we copy the value of the t1 to textfield t2?

2 Answers   Oasis,

---

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...

0 Answers   IBM,

---

What is the advantage of the library?

2 Answers  

---

What are built-ins associated with timers?

2 Answers  

---

Error_Code is a package proecdure ?

1 Answers  

---

How is link tool operation different between reports 2 & 2.5?

1 Answers  

---

How many types of trigger can be used in a table at a time ?

7 Answers  

---

What are the built-ins that are used to Attach an LOV programmatically to an item?

1 Answers  

---

I HAVE A REPORT LAYOUT LIKE THIS RUNDATE -FIELD DEPTNO-FIELD ------------------------------------------------------------ ------------------- EMPNO-----ENAME------SAL-----COMM----MGR----- ------------------------------------------------------------ ------------------ ------- ------------ -------- -------- -------- MY REQUIREMENT IS I WANT DEPTNO 10 VALUES IN ONE PAGE,DEPTNO 20 VALUES IN ONE PAGE,AND 30 IN ONE PAGE. I WANT LIKE THIS ....

4 Answers  

---

How you define procure to pay?

1 Answers   PWC, Zensar,

---

In what situation u create the BPA.

0 Answers   Zensar,

---