Artículos acerca del lenguaje de programación de bases de datos Oracle SQL y PLSQL.
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: