What is an Oracle stored procedure? – PB Docs 2017

Oracle defines a stored procedure (or function) as a named
PL/SQL program unit that logically groups a set of SQL and other
PL/SQL programming language statements together to perform a specific
task.

Stored procedures can take parameters and return one or more
result sets (also called cursor variables). You create stored procedures
in your schema and store them in the data dictionary for use by multiple
users.