Oracle PL/SQLWarning: Function created with compilation errors.

来源：互联网发布：淘宝steam充值卡黑卡编辑：程序博客网时间：2024/06/03 23:04

How to handle "Warning: Function created with compilation errors." when create Oracle function.

For example (MYFUNC.sql):

1 CREATE OR REPLACE FUNCTION MYFUNC

2 RETURN NUMBER AS

3 MYVAR NUMBER;

4 BEGIN

5 SELECT COUNT(*) INTO MYVAR FROM MYTAB;

6 RETURN MYVAR;

7 END MYFUNC;

8 /

$ sqlplus $LOGIN @MYFUNC.sql

SQL*Plus: Release 12.1.0.1.0 Production on Mon May 25 00:26:09 2015

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Warning: Function created with compilation errors.

SQL>

SQL> show errors;

Errors for FUNCTION MYFUNC:

LINE/COL ERROR

-------- -----------------------------------------------------------------

5/3 PL/SQL: SQL Statement ignored

5/35 PL/SQL: ORA-00942: table or view does not exist

SQL>

It's mean that table MYTAB does not exists.

SQL> CREATE TABLE MYTAB(A INT);

Table created.

SQL> @MYFUNC.sql

Function created.

SQL>

0 0