Some questions

[kiss07]

Hi

Any body refer the following questions..

1) Autonomous Transaction(example program is better).
2) WHAT IS Mutating table and what is mutating trigger?How can i
eliminate mutating trigger error?
3) what is Bulk Collect ,Bulk insert and Forall?

Please send link or direct answers.I prepare interview in pl/sql.

Regards,
Arun..

[debasisdas]

AUTONOMOUS_TRANSACTION is a pragma (like any header file in c/c++ or u can say it as the prepreocessor directive or as imports in Java or .net) its instruction to include the pragma before compiling the block of code

The AUTONOMOUS_TRANSACTION pragma instructs the plsql compiler to mark a routine as autonomous (independent). An A-T is an independent transaction started by another transaction,the main transaction.It lets the user suspend the main transaction and all sql operations,commit OR rollback those operations,then resume the main transaction.

[debasisdas]

Sample example of PRAGMA AUTONOMOUS_TRANSACTION;

CREATE OR REPLACE PROCEDURE DEPTINS
(
DNO DEPT.DEPTNO%TYPE,
DN DEPT.DNAME%TYPE,
LC DEPT.LOC%TYPE
)
IS
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
INSERT INTO DEPT VALUES(DNO,DN,LC);
DBMS_OUTPUT.PUT_LINE('ONE ROW INSERTED......!');
COMMIT;
EXCEPTION
WHEN DUP_VAL_ON_INDEX THEN
RAISE_APPLICATION_ERROR(-20001,'DUPLICATE VALUE......!');
END;
 

Hope the sample helps u out to solve your peoblem...

Happy programming