ORA-04063 是一个 Oracle 数据库错误,具体信息为 "package body has errors"。这个错误表明某个 PL/SQL 包体(package body)中存在编译错误,导致该包体无法被正确加载或执行。 2. 可能导致ORA-04063错误的原因 包体中的代码存在语法错误:例如,SQL 语句错误、PL/SQL 逻辑错误等。 依赖的对象无效或不存在:包体可能...
ORA-04063: package body "DBSNMP.BSLN" has errors 问题描述: 警告日志出现报错: Sun Jun2800:00:012020Errorsinfile/u01/app/oracle/diag/rdbms/xxxxx/xxxxx2/trace/xxxxx2_j000_8274.trc: ORA-12012: erroronautoexecuteofjob "SYS"."BSLN_MAINTAIN_STATS_JOB" ORA-04063: package body "DBSNMP.BSLN" has ...
ORA-04063: ORA-04063: package body "xx.yy" has errors ORA-06508: PL/SQL: could not find program unit being called: "xx.yy" 处理过程: 1.在PL/SQL Developer中,重新编译“xx”包,发现没有问题; 2.执行“yy“存储过程中的SQL语句,发现没有问题; 3.编辑“xx”包,发现包中的“zz”存储过程因用...
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....
Oracle Database Cloud Schema Service - Version N/A and later: ORA-04063: package body SYS.DBMS_REGISTRY_SYS has errors
The ABAP dump shows the following errors as the cause of the exception: ORA-04063: package body "SYS.DBMS_STATS_INTERNAL" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS_INTERNAL" ORA-06512: at "SYS.DBMS_STATS", line 2045 ...
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...
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 SQL> startup upgrade
问题现象：EXP-00008: 遇到 ORACLE 错误 4063 ORA-04063: package body “SYS.DBMS_CUBE_EXP” 有...
ORA-04063: package body "SYS.DBMS_REGISTRY_SYS" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REGISTRY_SYS" ORA-06512: at line 1 最终问题定位在DBMS_REGISTRY_SYS包失效,重新跑一下prvtcr.plb脚本即可解决: ...