Yes u can write directly write a coomit; in any of the report trigger.

can i write commit in Before report trigger

Question Posted / shailesh

4 Answers
11696 Views
I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

List out the oracle forms configuration files?

1006

how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

1931

What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4551

What do you understand by lov?

984

what is oracle forms?

1065

What is a matrix report and how many minimum groups are required to prepare the same?

1062

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2068

What do you understand by oracle forms?

978

Why oracle forms required?

977

i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame

2944

Is it possible to have multiple layouts in a report?

970

Explain the different levels at which oracle form services interact.

1006

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1413

if u want to delete all these detail block etc what will happen in form

1927

What are the various configuration files that are used by oracle forms?

986