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