can i write commit in Before report trigger
- 4 Answers
- 11058 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 |
in before report trigger SRW.user_exit(FND_Userinit) what will do
can you change the default value of the radio button group at run time?
What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?
What are the built-ins used for processing rows?
Can you attach an lov to a field at run-time? if yes, give the build-in name.
What do you understand by lov?
What is a list item?
What is the purpose of the product order option in the column property sheet?
What is the difference between NAME_IN and COPY ?
What are the trigger associated with image items?
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
What are the built-ins used for finding Object ID function?
Oracle General 
