The interactions in this eCourse require Javascript to be enabled.
Using Procedures and Functions
previous|next
Stored procedures and functions are named blocks of code that enable you to group and organize a series of SQL and PL/SQL statements. Both the source code and executable code are stored in the database. By storing it in the database, the code is in a centralized and accessible location. Because the executable code is stored in the database, invoking the stored code is efficient. Stored procedures and functions promote reusability and maintainability. When validated, they can be used in any number of applications. If the requirements change, only the code needs to be updated.