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 dialect in sql?

942

What are different types of sql?

1181

Can we create a trigger on view?

891

What is sql clause?

1047

Does pl/sql support create command?

1102

What is the advantage of index in sql?

969

What is difference between primary and secondary key?

1023

How many types of cursors supported in pl/sql?

1186

Can we use insert statement in function?

998

How do you declare a variable in pl sql?

1019

What is pl/sql table? Why it is used?

1033

What is a primary key called that is made up of more than one field?

1344

What is a table?

1008

What are triggers and its types?

1055

Write a sql query to convert all character to uppercase after hypen.

1436