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 the maximum database size for sql express?

1068

how do you know if your mysql server is alive? : Sql dba

1122

What is the use of pl/sql table?

1100

Is clustered index a primary key?

985

What is the purpose of primary key?

1069

what are numeric data types? : Sql dba

1102

Explain what is a column in a table?

1153

What is a data manipulation language?

1069

Can a table contain multiple foreign key’s?

1047

What is sql and db2?

1049

Does pl sql work in mysql?

1032

explain primary keys and auto increment fields in mysql : sql dba

1011

What is a trigger in sql?

1229

How to run sql statements through the web interface?

1086

What is crud stand for?

1046