What is the autonomous transaction?give me example?
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 10 Yes | 1 No |
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...
Is This Answer Correct ? | 3 Yes | 0 No |
Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?
What is Formula Column?
link between po and ap modules
what is the standard program for blanket po to process data from interface table to bace table
what is the use of placeholer column?
We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?
LOCKS?
What is template?
what r the objects u have to do in u experiance
what are the match approvals in PO?
Difference between triggers and procedures?
In interface how u find errors and how to solve. How to fix it?