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

Материал из SQL эксперт
Перейти к: навигация, поиск

Show error on a function

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