Executing a function or procedure I always mix up how to executing functions versus a procedure on Oracle Function select <schema>.<function>(<params>) from dual; Procedure begin <schema>.<function>(<params>); end;