Question: what is the difference between procedure and package in oracle?
Answer: Stored Program Units (Procedures, Functions, and Packages) A stored procedure, function, or package is a PL/SQL program unit that: Has a name. ... The only difference between procedures and functions is that functions always return a single value to the caller, while procedures do not return a value to the caller.