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.

how can develope the po variance and po summary report? with tables mandatory columns and query please?

2389

---

how can i print random rows in plsql table

2501

---

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

1980

---

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

1091

---

How to move the one file from one instance to another instance? And your scripts also?

1126

---

What do you understand by concurrent programs?

1103

---

tell me the scenarios of the independent in reports

2504

---

List the various types of value set.

1082

---

How is choreography different from orchestration?

1135

---

What do you understand by soa?

1161

---

Are you familiar with internet architecture of oracle apps 11i?

1068

---

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3665

---

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

1120

---

what is global tempory table?

7213

---

Can you differentiate between mediator and osb?

1144

---