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 |
Can you attach an alert to a field?
i don't want to give the path of .Dat file in .Ctl file dynamically i want to give how
What SYNCHRONIZE procedure does ?
sequence of firing triggers for text-item is: 1)key_next_item, 2)when_validate_item, 3)post_text_item Now i change sequence of firing triggers like when_validate_item,key_next_item... Is it possible to change sequence? How?
What is a list item?
How do you control the constraints in forms ?
When is PRE-QUERY trigger executed ?
What is a Text_io Package?
What is relation between the window and canvas views?
How do you trap the error in forms 3.0 ?
What is the built-in used to get and set lov properties during run-time?
What is a Navigable item?