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

explain what is mysql? : Sql dba

1065

Is sql procedural language?

953

What are the types of subqueries?

1048

What is sql analyzer?

996

What are the three pl sql block types?

987

Is natural join and inner join same?

902

What is compound trigger?

1015

What is left join in sql?

1040

What is sql keyword?

980

define data blocks ? : Sql dba

968

What are different types of tables in sql?

978

what is data control language? : Sql dba

1004

What are tuples in sql?

1115

how to use 'mysql' to run sql statements? : Sql dba

1037

Is sql a backend?

1002