Answer / ramesh babu v

Autonomous transaction can be devided into two parts as
parent&child,both(parent&child) are run simultaniously and
individually run.
EX:
create table R1(B1 number);
Table created.
create table R2(B2 number);
Table created.
/

1 create or replace procedure p1
2 as
3 pragma autonomous_transaction;
4 begin
5 insert into R1 values(101);
6 commit;
7* end;
/
Procedure created.
/
select * from R1;

B1
---
101
/

> create or replace procedure p2
2 as
3 begin
4 insert into R2 values(102);
5 p1;
6 rollback;
7 end;
8 /
Procedure created.

SQL> select * from R2;

no rows selected.

Answer / ramesh

if we want to make one transaction as independent among other or parent transaction,we will use the concept call autanamous transaction,

we will use pragma autanamus_transaction keyword in order to make one transaction as independent,so this transaction will run idependently...

what do you mean by value sets

8 Answers   Convergys,

---

what is the differences between internal requisition and internal sales order?

0 Answers   Accenture,

---

WHAT IS USE OF APPS API?

3 Answers  

---

is UOM maintained at master level or organization level or both?

3 Answers   Scan Steel,

---

Name the different Cursor Attributes.

2 Answers   Satyam,

---

Which is the best website to learn Oracle Apps?

2 Answers  

---

What do you understand by soa and what are the benefits of using this architecture?

0 Answers  

---

How to create multi-layout reports ? If we have 5 layouts , then how to get into the 4th one ?

3 Answers   IBM,

---

what is the diff between custom.pll and form personalization? Tell me one example?

4 Answers   Oracle,

---

what is pay run id ?

0 Answers  

---

What is OM Cycle and What do u mean by Alternate Item

3 Answers   IBM,

---

What is multi org?

6 Answers   Accenture, CTS,

---