we cant use tcl commands in trigger,,, if we call procedure in trigger the

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

Question Posted / abhijit

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is online transaction processing (oltp)?

1068

What is sql server and ase?

1072

What is sql lookup?

974

Is vs as in pl sql?

1038

What is procedure and function in sql?

1046

Can we use joins in subquery?

1230

How do rank () and dense_rank () differ?

1109

Can we join same table in sql?

1068

what is table? : Sql dba

1109

How does stored procedure reduce network traffic?

1066

Do we need commit after truncate?

1136

What is pl sql in oracle?

1099

What are the parts of a basic sql query?

1017

How to prepare for oracle pl sql certification?

1109

What is the order of sql select?

1088