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 |
how do u place it in required folder
did u received a single file or multiple files
What are different types of modules available in oracle form?
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
What is the "LOV of Validation" Property of an item? What is the use of it?
What is the remove on exit property?
What is an user exit used for?
How to call Report from other Report ?
based on parameter value layout of report should change
What are the default extension of the files created by library module?
Can a root window be made modal?
I want to learn the Oracle configurator(OracleApps)can any one tell best institutes in Hyderbad