oracle存储过程无效字符_Oracle中无效存储过程的重新编译方法

在SQL_PLUS中:

spool ExecCompProc.sql select &＃39;alter procedure

&＃39;||object_name||&＃39; compile;&＃39; From all_objects

where status &＃61; &＃39;INVALID&＃39; and object_type &＃61; &＃39;PROCEDURE&＃39;;

spool off &＃64;ExecCompProc.Sql;

整理成一个存储过程&＃xff1a;

Create Or Replace Procedure Zl_Compile_Invalid_Procedure

AsStrsql Varchar2(200);BeginFor x In (Select Object_Name

From All_Objects Where Status &＃61; &＃39;INVALID&＃39;

And Object_Type &＃61; &＃39;PROCEDURE&＃39;) LoopStrsql :&＃61; &＃39;Alter

Procedure &＃39; || x.Object_Name || &＃39; Compile&＃39;;Begin Execute

Immediate Strsql; Exception--When Others Then Null;

When OTHERS Then dbms_output.put_line(Sqlerrm);

End;End Loop;End;

最后执行&＃xff1a;

exec Zl_Compile_Invalid_Procedure;

如果要看到无法重编译的过程的出错信息&＃xff0c;需要执行前设置set serverout on。

标签&＃xff1a;

本站文章除注明转载外&＃xff0c;均为本站原创或翻译。欢迎任何形式的转载&＃xff0c;但请务必注明出处、不得修改原文相关链接&＃xff0c;尊重他人劳动成果

0

好文不易&＃xff0c;鼓励一下吧&＃xff01;