# RazorSQL

## Query, Edit, Browse, and Manage Databases

- razorsql.com
- Contact

# Oracle Create Procedure

The Oracle Create Procedure Tool allows users to create stored procedures for a database. The following example is output for Oracle.

`CREATE PROCEDURE TESTUSER.TEST_PROCEDURE ( param1 IN CHAR(25), param2 IN OUT DATE, param3 OUT NUMBER ) IS -- -- Declare program variables as shown below -- variable_name data_type BEGIN statements; EXCEPTION WHEN exception_name THEN --statements; END; --Procedure`