Oracle PL/SQL Tutorial/Function Procedure Packages/Show error

Show error on a function

   <source lang="sql">

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</source>