Why commit/rollback or any DDL command not allowed in trigger or function?

Published: 14/02/2020
Why commit/rollback or any DDL command not allowed in trigger or function?
Source: ASKTOM.ORACLE.COM

Hi Tom, Theoretically I know that commit/rollback/DDL or anything that causes transaction to end are not allowed in a trigger and function if calling function in SQL statement. To use any of those in trigger/function we can use PRAGMA AUTONOMOUS T...

Read more
Related news
Comment
FACEBOOK