IF i write before / after insert / update trigger and i do rollback what will

IF i write before / after insert / update trigger and i do
rollback what will happen?

Question Posted / sonali

Answers were Sorted based on User's Feedback

IF i write before / after insert / update trigger and i do rollback what will happen?..

Answer / debasis mohanty

A trigger May Not issue A TCL statement like COMMIT,ROLLBACK,SAVEPOINT.
So U Cant Write A TCL Command Inside A trigger.

Is This Answer Correct ?

10 Yes

3 No

IF i write before / after insert / update trigger and i do rollback what will happen?..

Answer / ankit sinha

But if put a autonomous transaction with a rollback i think
we can do it ..

Is This Answer Correct ?

7 Yes

1 No

IF i write before / after insert / update trigger and i do rollback what will happen?..

Answer / revathi

yes

Is This Answer Correct ?

3 Yes

1 No

IF i write before / after insert / update trigger and i do rollback what will happen?..

Answer / vivek

The data whatever inserted/updated will be rollback once issue rollback

Is This Answer Correct ?

0 Yes

0 No

IF i write before / after insert / update trigger and i do rollback what will happen?..

Answer / abhijit

we cant use tcl commands in trigger,,,
if we call procedure in trigger then we can use pragma autonomous transaction for tcl

Is This Answer Correct ?

0 Yes

1 No