A stored procedure is a collection of R:BASE commands and/or SQL statements that are stored in the database.
Stored procedures offer a powerful way for developers to add value and ease of maintenance to their R:BASE databases and applications. Moving some of the common business and data access logic out of the R:BASE program into the database centralizes functionality in one place, making it accessible to the R:BASE program as well as any third party ODBC application.
You can run a stored procedure "manually" using the CALL command, or "automatically" by using database triggers.
