ORA-29537: class or resource cannot be created or dropped directly ORACLE 报错 故障修复 远程处理

文档解释

ORA-29537: class or resource cannot be created or dropped directly

Cause: An attempt was made to create or drop a Java class or resource that is known to result from compilation of an existing Java source object.

Action: Act on the class or resource by acting on the source, or change the source so that it no longer defines the class or resource.

ORA-29537错误是oracle数据库中的一条错误消息，表明您试图创建或删除所指定的DBMS_JAVA类或资源失败。官方解释是，您不能直接使用databasecontrol或dbms_java包的create_xxx或drop_xxx存储过程来创建Cass和资源，因为它们是DBMS_JAVA包封装的不同层应用程序组件的一部分。

常见案例

一般处理方法及步骤

wrap iname=loadjava.sql oname=loadjava.sql.enc

loadjava -user scott/tiger -wrap -grant PUBLIC -resolve -thin -verbose loadjava.sql.enc

此外，您还可以使用loadjava和droploadjava，比如：

loadjava -user scott/tiger -grant PUBLIC -resolve -thin -verbose myclass.class

droploadjava -user scott/tiger myclass.class

本文提供的信息和步骤将有助于您更好地了解并正确处理ORA-29537错误。