Question: what is the difference between function procedure and package in pl/sql?
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.