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 |
Is it possible to attach same library to more than one form?
What is the difference between $$DATE$$ & $$DBDATE$$
What is the usuage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ?
What are the different default triggers created when Master Deletes Property is set to isolated?
What ERASE package procedure does ?
What do you mean by a pop-up window ?
what is oracle forms?
Explain how one can iterate through items and records in a specified block?
Two popup pages can appear on the screen at a time ?
What is synchronize?
What is the built_in routine used to count the no of rows in a group?
What do you understand by oracle forms and why are they required?