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...

tell me the scenarios of the independent in reports

0 Answers   TCS, Wipro,

---

is it possible to run the interface without using oracle apps?

2 Answers   Accenture,

---

What is MO operating units. Why it need to to set this and where .

2 Answers   IBM,

---

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

1 Answers   Genpact, Wipro,

---

how many layout sections are tehre in layout editor?

1 Answers  

---

HOW CAN U KNOW THE STAUS OF PO?

1 Answers   TCS,

---

What are basic steps for AIM?

2 Answers  

---

Can anybody tell me, What is the Implementation Process?

2 Answers   TCS,

---

What do you understand by soa?

0 Answers  

---

why do we validate the records while developing interface?

3 Answers   TCS,

---

what is global tempory table?

1 Answers   BirlaSoft,

---

we have select statement in that two exceptions that returns no value. In that which exception will raise?

2 Answers  

---