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

In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?

1 Answers   Oracle,

---

name all status attributes.

1 Answers   Scan Steel,

---

Which one Module is Biggest Module in oracle apps?

3 Answers   Questam,

---

What is INBOUND and OUT BOUND? (Different types of interfaces)

17 Answers   Accenture, Asian Paints, Inbound Solutions, Tech Mahindra,

---

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

0 Answers   IBM,

---

How does accounting occured in Expense Reporting?

1 Answers   Sapient,

---

In what situation u create the BPA.

2 Answers   Accenture,

---

35—how to create ldt lct files? 36—how to tranfor on file from one instance to another instance?

2 Answers   Accenture,

---

how many layout sections are tehre in layout editor?

1 Answers  

---

what is multi org structure?

3 Answers   Covansys, TCS,

---

WHAT IS USE OF APPS API?

3 Answers  

---

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

0 Answers   BEL, Questam,

---