Hello...

On Tue, 05 Apr 2005 02:28:23 -0400, tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane)
wrote:
>
>How does Oracle's PL/SQL handle this?

On ORACLE a FUNCTION MUST return a value.  If the FUNCTION doesn't
return a value Oracle give a 'hint' on FUNCTION compilation and error
on SELECT function invocation:  ORA-06503.

When we don't want to return any result on ORACLE we must use
PROCEDURE statement instead of FUNCTION.

Example:

========
SQL> CREATE OR REPLACE FUNCTION F_test RETURN NUMBER IS
  2      BEGIN
  3        NULL;
  4      END F_TEST;
  5  /

Function created.

SQL> SELECT F_TEST FROM DUAL;
SELECT TUZSA.F_TEST FROM DUAL
       *
ERROR at line 1:
ORA-06503: PL/SQL: Function returned without value
ORA-06512: at "F_TEST", line 3


SQL> 
========

Greetings.

In response to

• Should we still require RETURN in plpgsql? at 2005-04-05 06:28:23 from Tom Lane

pgsql-hackers by date

Next:	From: Russell Smith	Date: 2005-04-05 08:06:09
	Subject: Re: [HACKERS] plPHP in core?
Previous:	From: Tom Lane	Date: 2005-04-05 07:43:39
	Subject: Re: Should we still require RETURN in plpgsql?