Advantages and Disadvantages of a Stored Procedure

dilippanda

New Member

Join Date: Jun 2007

Posts: 26
#1

Advantages and Disadvantages of a Stored Procedure

Jun 18 '07, 11:42 AM

Hi,

What are the advantage and disadvantages of a stored procedure in PL/SQL?

Please guide me.

Thanks,
Dilip
Tags: disadvantages oracle
debasisdas

Recognized Expert Expert

Join Date: Dec 2006

Posts: 8119
#2

Jun 18 '07, 11:50 AM

the main advantage is that it is precompiled.

so it does not involve steps like

parsing ---------> optimization and all.

so it executes faster in comparision to any normal
SQL statment.
Comment

Comment