function with no return type : Function Definition « Stored Procedure Function « Oracle PL / SQL

function with no return type

    
SQL>
SQL>  create or replace function no_return_type as
  2    begin
  3      return null;
  4    end no_return_type;
  5    /

Warning: Function created with compilation errors.

SQL>
SQL>  show errors
Errors for FUNCTION NO_RETURN_TYPE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1/25     PLS-00103: Encountered the symbol "AS" when expecting one of the
         following:
         ( return compress compiled wrapped

SQL>
SQL>

Related examples in the same category

1.	Define and call a function
2.	Define and use function in select clause
3.	A stored function.
4.	Use user-defined function in if statement
5.	Recursive function
6.	Recursive function Factorial
7.	A local function
8.	Recursive function 2
9.	demonstrates the behavior of the DETERMINISTIC keyword.
10.	Function to convert celsius to fahrenheit
11.	Function to convert fahrenheit to celsius
12.	A function is executed like any other SQL built-in function:
13.	Count Employee from a function and return value back
14.	How stored functions can be called from SQL
15.	Raise exception from inner function