can i write commit in Before report trigger
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 is the built-in function used for finding the alert?
What are the different window events activated at runtimes?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?
List the different types of columns in oracle reports.
Is it possible to execute a dynamic sql from forms?
What is the sequence the Report triggers will fires while running a report ?
What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?
what is a package n what r the packages availbla in report
Can you attach an lov to a field at design time?
Give built-in routine related to a record groups?
What is a Query Record Group?
how do u place it in required folder