Check the error : Compile Error « PL SQL « Oracle PL / SQL

1. Oracle PL / SQL
2. PL SQL
3. Compile Error

Check the error

  
SQL>
SQL>
SQL> -- function with no return type
SQL>
SQL>
SQL>  create or replace
  2    function no_return_type as
  3    begin
  4      return null;
  5    end no_return_type;
  6    /

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>


           
         
    
  

Related examples in the same category