By using PRAGMA autonomus_transaction we can use commit inside the trigger

Can i use Commit inside the Trigger? Suppose i use commit
what will be happy (it's complied /executed/work)

Question Posted / kannan

Answer Posted / kannan

By using PRAGMA autonomus_transaction we can use commit
inside the trigger.

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why do we go for stored procedures?

994

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1114

Write a sql select query that only returns each name only once from a table?

959

How many unique keys can a table have?

956

Which data dictionary views have the information on the triggers that are available in the database?

1180

Why use stored procedures?

1019

What is data control language (dcl)?

1043

What is trigger point?

949

What is using in sql?

1016

what is sql server agent? : Sql dba

1028

What is full join?

896

Can we use loop in sql?

922

how to shutdown mysql server? : Sql dba

1028

Can we create table inside stored procedure?

904

What is use of trigger?

873