1、To avoid this scenario, use the RETURNS clause of the CREATE PROCEDURE statement to return data to the caller.
2、The CREATE PROCEDURE statement provides special syntax for Oracle routines in packages, a three-part name in the SOURCE clause where the middle part identifies the package.