ORA-04063 是一个 Oracle 数据库错误,具体信息为 "package body has errors"。这个错误表明某个 PL/SQL 包体(package body)中存在编译错误,导致该包体无法被正确加载或执行。 2. 可能导致ORA-04063错误的原因 包体中的代码存在语法错误:例如,SQL 语句错误、PL/SQL 逻辑错误等。 依赖的对象无效或不存在:包体可能...
ORA-39127: unexpected errorfromcalltoexport_string :=SYS.DBMS_CUBE_EXP.INSTANCE_EXTENDED_INFO_EXP('AW$EXPRESS','SYS',1,2,0,'SYS',1,'11.02.00.04.00',newblock) ORA-04063: package body "SYS.DBMS_CUBE_EXP" ha s errors ORA-06508: PL/SQL: couldnotfind program unit beingcalled: "SYS.D...
Oracle Database Cloud Schema Service - Version N/A and later: ORA-04063: package body SYS.DBMS_REGISTRY_SYS has errors
Package body altered. Elapsed:00:00:00.4811:23:54sys@xxxxx1(xxxxx1)>selectowner,object_name,object_type,statusfromdba_objectswhereowner='DBSNMP'andobject_name='BSLN_INTERNAL'; OWNEROBJECT_NAMEOBJECT_TYPE STATUS--- --- --- ---DBSNMP BSLN_INTERNAL PACKAGE VALID DBSNMP BSLN_INTERNAL PACKAGE BO...
The status of the package body DBMS_STATS_INTERNAL is INVALID: SQL> select object_name, object_type, status from dba_objects where owner = 'SYS' AND status <> 'VALID'; OBJECT_NAME OBJECT_TYPE STATUS --- DBMS_STATS_INTERNAL PACKAGE BODY INVALID Read more... Environment SAP Systems based...
ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errorsORA-06512: at line 11ORA-06512: at "SYS.DBMS_AQADM", line 415ORA-06508: PL/SQL: could not find program unit being called:"SYS.DBMS_AQADM_SYS"ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 893ORA-04063: package body "SYS....
EXP-00008: 遇到 ORACLE 错误 4063 ORA-04063: package body “SYS.DBMS_CUBE_EXP” 有错误 ORA-...
using dbca get errors below installing APEX * ERROR at line 1: ORA-04063: package body "APEX_030200.WWV_FLOW" has errors ORA-06508: PL/SQL: could not find program unit being called: "APEX_030200.WWV_FLOW" ORA-06512: at line 2...
ORA-06512: at line 10 ERROR at line 1: ORA-00604: error occurred at recursive SQL level 2 ORA-04063: package body "SYS.DBMS_METADATA" has errors ORA-06512: at line 10 解决办法: SQL> shutdown immediate SQL> spool /tmp/spool.txt ...
问题类似我之前不久的一片博文里边描述的问题,ORA-04063: package body "DBSNMP.BSLN_INTERNAL" has errors。 虽然不再搜索到同样的官方处理方式,不过其实根因是一样的。 问题原因: 1.BSLN包体对象处于无效状态。 selectowner,object_name,object_type,statusfromdba_objectswhereowner='DBSNMP'andobject_name='BSLN...