Interested to Buy Any Domain ? << Click Here >> for more details...
can i write commit in Before report trigger
- 4 Answers
- 11686 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 |
Can a repeating frame be careated without a data group as a base?
What is responsibility and how u attach How to create user and how u attach with responsibility.
hiding item in report how like that properly,thats manually but at runtime i want to do
When does an on-lock trigger fire ?
What is forms_DDL?
What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?
How to call a report from Forms?
In what situation u create the BPA.
what are bind variables?
difference between place holder and formula column
3 Answers Cognizant, IBM, Microsoft,
if u have one group can u create another from that
what are the new features introduced in oracle form services in 11g release 2?
Oracle General 
