can i write commit in Before report trigger

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

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to execute a dynamic sql from forms?

830


what is oracle forms?

878


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

2727


Explain master-detail relationship with some examples.

792


What do you understand by lov?

814


How can we expand Parameter Form Canvas on Reports 6i?

2189


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

898


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

818


how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

1762


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

1035


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

4369


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

1957


Is it possible to have multiple layouts in a report?

829


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

1831


how do u place it in required folder

1710