Is it possible to use Transactional control statements in Database ?

Is it possible to use Transactional control statements in
Database ?

Question Posted / guest

2 Answers
4054 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Is it possible to use Transactional control statements in Database ?..

Answer / ddrema

It's posible and mandatory if you use AUTONOMOUS
TRANSACTION in the TRIGGER.
like this:
CREATE OR REPLACE TRIGGER audit_sal
BEFORE UPDATE OF salary ON employees FOR EACH ROW
DECLARE
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
INSERT INTO emp_audit VALUES( :old.employee_id, SYSDATE,
:new.salary, :old.salary );
COMMIT;
END;
/

Is This Answer Correct ?

2 Yes

0 No

Is it possible to use Transactional control statements in Database ?..

Answer / guest

no, it is not possible to use Transactional control
statements in Database Triggers

Is This Answer Correct ?

0 Yes

1 No

Post New Answer

More Database Management Interview Questions

What is the difference between hashed file stage and sequential file stage in relates to datastage server?