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

Is drop table faster than truncate?

543

What are the types of join and explain each?

571

What is acid property in a database?

578

What are the types of variable use in pl sql?

559

how to create a new view in mysql? : Sql dba

488

How is sql used in oracle?

574

Explain the purpose of %type and %rowtype data types with the example?

545

How does join work in sql?

546

how do you know the version of your mysql server? : Sql dba

501

what is an extent ? : Sql dba

576

how to fetch alternate records from a table? : Sql dba

584

What is a left join?

497

How can you create an empty table from an existing table?

588

how to create a table index in mysql? : Sql dba

588

Is sql sequential or random?

530