Re: [PL/SQL] Oracle Stored Procedure的問題
當你在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
推
11/11 13:38, , 1F
11/11 13:38, 1F
討論串 (同標題文章)