0 votes
in PL/SQL by
Explain what Is The Difference Between Database Trigger And Stored Procedure?

1 Answer

0 votes
by

The main difference between database trigger and stored procedure is that the trigger is invoked implicitly and stored procedure is invoked explicitly.

Transaction Control statements, such as COMMIT, ROLLBACK, and SAVEPOINT, are not allowed within the body of a trigger; whereas, these statements can be included in a stored procedure.

...