WHENEVER SQLERROR EXIT 1 DECLARE FUNCTION foo(bar IN VARCHAR2, baz IN VARCHAR2) RETURN VARCHAR2 IS BEGIN return bar || baz; END foo; BEGIN select foo('egg', 'chips') from dual; END; /