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?

Answers were Sorted based on User's Feedback



can we use commit in trigger? If yes how?..

Answer / prasad reddy

Yes ,You can Commit inside the trigger.

But for this you have to make this trigger transaction to be
a Independent transaction from its parent transaction, You
can do this by using Pragma. Pragma AUTONOMOUS_TRANSACTION
allow you to build the Indepadent(child) Transaction,started
by another

Cheers
-Prasad

Is This Answer Correct ?    21 Yes 1 No

can we use commit in trigger? If yes how?..

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

More Oracle Apps Technical Interview Questions

What repots or concurrent program run to transfer data from Inventory to GL.

5 Answers   IBM, iGate,


do i need to declare bind parameter before using in the query?

2 Answers   Satyam,


Can we run a package with out specification?If yes how?

4 Answers  


Do you know what are user profiles in apps. Any examples you can give?

0 Answers  


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

0 Answers   BEL, Questam,


WHAT IS THE FORWARDREFERENCE IN PL/SQL?

4 Answers   IBM,


in one report using two layout models.if yes how to do

2 Answers  


How many typres of Purchase order and what are those.

2 Answers   Accenture,


in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?

2 Answers   Oracle, Schneider,


when we run payment batch what are the 3 concurrent programs?

1 Answers   Genpact, Wipro,


What is P2P cycle.

27 Answers   Accenture, Deloitte, EE Limited, EXL, IBM, Tech Mahindra,


HOW U DISPLAY THE FLEXFIELD DATA IN APPS?

2 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)