miércoles, 25 de junio de 2008

What is stored procedure?

A stored procedure is a schema object. It is a group of SQL and PL/SQL statements. It is created in a user's schema A stored procedure can be used to implement business logic or as a security mechanism, but it is not executed automatically. executed interactively by using an Oracle tool, such as SQL*PLUS, or by calling it explicitly through a SQL statement
by calling it in other procedures or triggers. A stored procedure provides better performance because it does not require created and compiled.
Three types of parameters can be passed in a stored procedure:
  • IN
  • OUT
  • INOUT