In this chapter, we'll describe SQL-invoked routines in detail, and show you the syntax to use to create, alter and destroy them.
-
Routine
A Schema may contain zero or more SQL-invoked routines. An SQL-invoked rout... -
CREATE PROCEDURE/FUNCTION/METHOD Statement
The CREATE PROCEDURE/FUNCTION/METHOD statement names a new SQL-invoked proc... -
Routine Parameters
A routine's SQL parameter declaration list is a parenthesized, comma-delimi... -
Invoking Routines
Creating a routine is complex. Invoking a routine can be easy. The secret i... -
Routine Examples
Here are four examples of SQL-invoked routines that might be used in real-l... -
RETURN Statement
The RETURN statement returns a value from an SQL-invoked function. The requ... -
External Routines
"Host calls DBMS: no story. DBMS calls host: story!" —Journalist's man-bite... -
ALTER ROUTINE/PROCEDURE/FUNCTION/METHOD Statement
The ALTER ROUTINE/PROCEDURE/FUNCTION/METHOD statement lets you change an SQ... -
DROP ROUTINE/PROCEDURE/FUNCTION/METHOD Statement
The DROP ROUTINE/PROCEDURE/FUNCTION/METHOD statement destroys an SQL-invoke... -
Dialects
One way or another, DBMSs have been calling routines for several years. The...
