Interested to Buy Any Domain ? << Click Here >> for more details...
can i write commit in Before report trigger
- 4 Answers
- 11710 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / pushpendra saini
yes u can do commit in Before report trigger
| Is This Answer Correct ? | 1 Yes | 2 No |
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.
| Is This Answer Correct ? | 0 Yes | 1 No |
What are the Built-ins to display the user-named editor?
List the different types of columns in oracle reports.
Is the After report trigger fired if the report execution fails?
Which is the cheapest and quality Oracle Education provider in Bangladesh?
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?
How i get the client m/c IP address.
Explain types of Block in forms4.0?
What is a library in Forms 4.0?
What is a Layout Editor?
What do you understand by lov?
How you define procure to pay?
Oracle General 
