Oracle Create Package
The Oracle Create Package Tool allows users to create packages for a database. The following is example output from the Create Package tool.
CREATE PACKAGE TESTUSER.TEST_PACKAGE
IS
--
-- Declare program variables as shown below
variable_name data_type
--
-- Declare procedures as shown below
PROCEDURE procedure_name
(param1 IN|OUT|IN OUT data_type,
param2 IN|OUT|IN OUT data_type);
--
-- Declare functions as shown below
--
FUNCTION function_name
(param1 IN|OUT|IN OUT data_type,
param2 IN|OUT|IN OUT data_type)
RETURN data_type;
--
END;
