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
