It is not possible. As triggers are defined for each table, if you use CO

Is it possible to use Transaction control Statements such a
ROLLBACK or COMMIT in Database Trigger ? Why ?

Question Posted / tulsi

Answer Posted / tulsi

It is not possible. As triggers are defined for each table,
if you use COMMIT of ROLLBACK in a trigger, it affects
logical transaction processing.

Is This Answer Correct ?

4 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is pl sql commands?

1045

What are the operators used in select statements?

1058

What is sql trigger example?

1054

What is primary key and unique key?

1117

What is a temporal table?

929

What does trigger mean in slang?

1048

What is difference between inner join and cross join?

968

What is a parameter query?

1080

which types of join is used in sql widely? : Sql dba

982

how do you login to mysql using unix shell? : Sql dba

1079

What is procedure function?

1053

How do you explain an index?

1282

What is the use of sql trace?

951

what is msql? : Sql dba

988

Is postgresql a nosql database?

1157