# RazorSQL

## Query, Edit, Browse, and Manage Databases

- razorsql.com
- Contact

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