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 are all the system Parameters available in ORACLE Reports
what is place holder column
What is the use of place holder column?
What are the triggers available in the reports?
.fmb will be in which folder
What package procedure used for invoke sql plus from sql forms ?
What is the difference between system.current_field and system.cursor_field ?
How i get the client machine Ip address through developer 2000 forms, if you are running three tier architech.
What are the different display styles of list items?
What is lexical parameter ?
Identify package function from the following ?
what is latest version in reports