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 java sql connection?

1062

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

965

What is the max nvarchar size?

982

Mention what are different methods to trace the pl/sql code?

1213

What is a temporal data type?

1054

what does the t-sql command ident_incr does? : Transact sql

1080

What types of commands can be executed in sql*plus?

1109

What is sql comments?

1077

What are %type and %rowtype for?

1054

What is clustered and nonclustered index in sql?

944

Why truncate is used in sql?

1008

How do you update f as m and m as f from the below table testtable?

1860

What are stored procedures used for?

1003

Can a select statement fire a trigger?

1167

Explain clause in sql?

1034