select * from USER_OBJECTS
SELET OBJECT_NAME FROM USER_OBJECTS WHERE OBJECT_TYPE='FUNCTION' AND STATUS='INVALID' //查询function中报错的文件
ALTER FUNCTION XXXX COMPILE --- xxx 为查询出来的 object_name
编译有错误的文件
select * from USER_OBJECTS
SELET OBJECT_NAME FROM USER_OBJECTS WHERE OBJECT_TYPE='FUNCTION' AND STATUS='INVALID' //查询function中报错的文件
ALTER FUNCTION XXXX COMPILE --- xxx 为查询出来的 object_name
编译有错误的文件