Advantage of a stored procedure over a database trigger.

Stored procedures can accept parameters and can return values. Triggers can neither accept parameters nor return values. A Trigger is dependent on a table and the application has no control to not fire a trigger when not needed. On the other hand, a stored procedure can be called as needed.

Posted in: 500 Oracle interview questions and answers