ORA-29556: object type has changed

文档解释

ORA-29556: object type has changed

Cause: A database object name that named a Java source, class, or resource now names an object of a different type.

Action: No action required.

官方解释

(1)重新检查此对象,找出变更对象的SQL;

(2)为对象添加INVALID属性;

(3)确保对象的类型和属性的正确性;

(4)使用compile invalid把失效的对象重新编译;

(5)把失效的对象重新调整,保持一致性并解决此类问题;

(6)最后,重新运行失败的语句,看能否正常执行。

你可能感兴趣的