# RazorSQL

## Query, Edit, Browse, and Manage Databases

- razorsql.com
- Contact

# 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;`