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 a difference between pre-select and pre-query?
While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False.
What are the triggers associated with a check box?
How do u give the list of values in bind parameter
in compatibility in report registration?
What are the different styles of actvation of ole Objects?
What is trigger associated with the timer?
What are parameters?
based on parameter value layout of report should change
i created a parameter list in reports. how to restrict that parameter list with parameters
What are the type of User Exits ?
List the system variables related in Block and Field?