CREATE OR REPLACE FUNCTION ora_func (
p_eins IN INTEGER DEFAULT 42,
p_zwei IN INTEGER DEFAULT 4711,
p_drei IN VARCHAR2 DEFAULT 'test'
) RETURN VARCHAR2 AS
BEGIN
RETURN 'p_eins='
|| p_eins
|| ', p_zwei='
|| p_zwei
|| ', p_drei='
|| p_drei;
END;
/SELECT ora_func(p_eins=>42, p_zwei=>4711, p_drei=>test ) from dual;
SELECT ora_func(p_eins=>null) FROM dual;