Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

can i write commit in Before report trigger

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

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

2050


what are the new features introduced in oracle form services in 11g release 2?

1075


how to send file attachment from oracle forms

2601


What do you understand by lov?

1078


What is an SQL FORMS ?

2829


In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1356


In what situation u create the BPA.

2248


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

2187


what exactly u write in when_new_form_instance

3495


What do you understand by oracle forms and why are they required?

1063


In what sequence do triggers get fired by oracle forms?

1016


What is responsibility and how u attach How to create user and how u attach with responsibility.

2089


from where do u receive the information to develop report

2047


What is an oracle report?

1118


did u received a single file or multiple files

2055