# RazorSQL

## Query, Edit, Browse, and Manage Databases

- razorsql.com
- Contact

# Oracle Create Function

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

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