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

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2569

---

How to create a purchase order without a requisition?

1124

---

What is the concept of soa governance?

1217

---

What are the Standard Reports and Forms in HRMS?

2227

---

please send me forms, xml pulisher questions,answers

2066

---

Can you explain the difference between architecture followed in 10g & 11g?

1018

---

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

2603

---

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2210

---

How many schemas we have? how many you have used?

2002

---

What are the different components you should consider while defining a responsibility in oracle apps?

1034

---

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2576

---

What is count(*) from po_vendors(any table)?

1034

---

What are do's and dont's of Interface?

2368

---

Do you know where we can check the status of po?

1189

---

What does appl_top directory contain?

1078

---