Stored procedure calls

Oracle supports stored procedures and stored functions as a group of PL/SQL statements that you can call by name.

To create a stored procedure in an Oracle database, use the CREATE PROCEDURE statement. See reference documentation for more details.