Show error on a function : Show error « Function Procedure Packages « Oracle PL/SQL Tutorial






SQL>
SQL> ALTER SESSION SET PLSQL_WARNINGS = 'ENABLE:ALL'
  2  /

Session altered.

SQL> CREATE OR REPLACE FUNCTION myProc
  2     RETURN PLS_INTEGER
  3  AS
  4     l_count PLS_INTEGER;
  5  BEGIN
  6     SELECT COUNT(*) INTO l_count
  7       FROM employee
  8      WHERE salary = '10000';
  9     RETURN l_count;
 10  END myProc;
 11  /

Warning: Function created with compilation errors.

SQL>
SQL> SHOW ERRORS FUNCTION myProc
Errors for FUNCTION myProc:

LINE/COL ERROR
-------- -----------------------------------------------------------------
6/4      PL/SQL: SQL Statement ignored
7/11     PL/SQL: ORA-00942: table or view does not exist








27.24.Show error
27.24.1.Show error on a function