Oracle Create Package Body
The Oracle Create Package Body Tool allows users to create package bodies for a database. The following is example output from the Create Package Body tool.
CREATE PACKAGE BODY TESTUSER.TEST_PACKAGE
IS
--
-- Declare procedures as shown below
PROCEDURE procedure_name
(param1 IN|OUT|IN OUT data_type,
param2 IN|OUT|IN OUT data_type)
IS
--Enter procedure variables here
variable_name data_type
BEGIN
statements;
EXCEPTION
WHEN exception_name THEN
statements;
END;
--
-- Declare functions
--
END;
