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

List out the oracle forms configuration files?

572


did u p prepared complex report

1606


How to create Drill down report?

1701


What do you understand by oracle forms?

591


What is an SQL FORMS ?

2317






Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?

1559


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

1704


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

1602


if some data is not transfered where it will get stored

1468


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

633


What is the difference between flex mode and confined mode?

534


List the different types of columns in oracle reports.

576


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

1101


Is it possible to have multiple layouts in a report?

578


how to send file attachment from oracle forms

2143