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 we use commit in trigger? If yes how?

Answer Posted / srinivasa reddy k

Generally we cannot use commit in triggers.

But it is possible to use commit in triggers by
mentioning "pragma autonomous_transaction;" in the
declarative section of the trigger.

Is This Answer Correct ?    18 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

1116


What is instead of trigger in where we will use?

1170


How to create a purchase order without a requisition?

1191


In support project one ticket alloted which steps follows manualy tell me ?

2658


List the types of flexfield?

1039


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

3029


What is sca and how is it useful?

1121


In hierarchical structure of a database? we have write query from where we should start?

2242


List the various types of value set.

1077


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

2123


What is the concept of soa governance?

1249


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2209


How many schemas we have? how many you have used?

2061


Tell me how to find the custom directory in front end?

1107


where to define interorganization transaction charges and what are the different options?

2416