当你在oralce使用drop table 时, 其他相对应有使用到该table的procedure, function, package都会直接失效 (就算你马上在重建一个相同table也一样, oracle在内部物件使用的SEQID对应, 重建table当然就跟原本的不同) 所以你下面两个insert的procedure当然无法正确执行, 如果其他版友建议的使用truncate table才不会出现这种问题... ps:其实你上面执行的结果都有oracle的error code, 问题其实蛮清楚的 ORA-06508: PL/SQL: could not find program unit being called Cause: An attempt was made to call a stored program that could not be found. The program may have been dropped or incompatibly modified, or have compiled with errors. Action: Check that all referenced programs, including their package bodies, exist and are compatible. --

※ 发信站: 批踢踢实业坊(ptt.cc) ◆ From: 202.3.165.131