m.kalahan

• Sep 17th, 2005

 

stored procedure is a pl/sql programming block stored in the database for repeated execution Whereas,Trigger is a pl/sql programming block that is executed implicitly by a data manipulation statement.

Dhayanand darshanala

• Nov 3rd, 2005

 

We need to call the stored procedure explictily where as triggers fires when ever an event occurs.

kehri_anurag

 Profile Answers by kehri_anurag Questions by kehri_anurag

• Jan 16th, 2006

 

Information related to Stored procedure you can see in USER_SOURCE,USER_OBJECTS(current user) tables.

Information related to triggers stored in USER_SOURCE,USER_TRIGGERS (current user) Tables.

Stored procedure can't  be inactive but trigger can be Inactive.

chennoju

 Profile Answers by chennoju 

• Aug 3rd, 2006

 

Stored procedure and Trigger both will be in the database in precompiled formate which ready execute, the main difference between these two is

to execute the stored procedure programe need to type execute statement where as to execute trigger programer no need type execute statement,trigger will fire automatically when an event(like insert,delete) on the table 

jpundalik

 Profile Answers by jpundalik 

• Dec 30th, 2009

 

Below are the few difference between Stored Procedure and Triggers

Both are stored objects and stored in data base dictionaries

Stored Procedure
- Can pass parameters
- Manual execution required

Triggers:
- No parameters can be passed
- Automatical executed when the event occurs