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 |
plz explain when we are using pre-query,post-query,pre-insert and post-insert?plz explain with one example
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
How to create placeholder columns?
in reports 1og.if we enter a query in list of values then parameter form displays a dropdown.in that if any ething is selected then that will display in the report.supp if i am not selected any value then it should display all the values.how it is possible?can any one help me........
What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?
what is a package n what r the packages availbla in report
I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object
What is the difference when confine mode is on and when it is off?
What is the difference between a POST-FIELD trigger and a POST-CHANGE trigger ?
Suppose I want to fire block level sequence before form level, then is it possible?
running a report from Form or other Report , The Parameter Form Page will be Display first . I don?t want to display the screen . What I have to do ?
can i send the control file path as a parameter