Oracle 存储过程 procedure 失效 分析

 

 

数据迁移完毕，对比数据库对象有效性的时候，发现有个存储过程是失效的，重新编译仍然失效

 

存储过程如下：

 

CREATEORREPLACEPROCEDUREPERM.P_YG_SWJG_DMas

 

BEGIN

 

  FORLS_KJYWRXXIN (SELECTt.swjg_dm || '00'SWJG_DM,

                            t.mcSWJG_MC,

                            t.mc_jSWJG_JC,

                            t.jgjcjg_bz,

                            t.swjg_dm || '00'SWJG_DM_bj,

                            t.sjswjg_dm || '00'swjg_dm_sj,

                            t.swbm_bjswbm_dm_bj,

                            ''ywhj_dm,

                            ''jc,

                            ''jg,

                            t.yb