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 is secuirity's in R12 features.

1 Answers   KPIT,

---

in procedure how to return a value

4 Answers  

---

What is Pragma Autonomous transaction. It's Real time Example

4 Answers   IBM,

---

HOW U DISPLAY THE FLEXFIELD DATA IN APPS?

2 Answers  

---

please explain open interface import

2 Answers  

---

---

in procedure how to return a value

2 Answers   Wipro,

---

what are the different types of parameters avialable in reports?

2 Answers   Oracle,

---

in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?

2 Answers   Cap Gemini,

---

What is an Index , Types od index why we are use index.

2 Answers   IBM,

---

Can anybody tell me, What is the Implementation Process?

2 Answers   TCS,

---

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

2 Answers   Oracle, Schneider,

---

where we can check the status of po.

4 Answers  

---