Tag Archives: procedure

ORA-600(qcsgpvc3)错误

Posted on 2012/06/09 by yangtingkun

编译包导致的错误。 数据库版本为10.2.0.4 RAC for Linux X86-64，错误信息为： Fri Nov 4 14:27:47 2011 Errors IN file /u01/admin/orcl/udump/orcl1_ora_15210.trc: ORA-00600: internal error code, arguments: [qcsgpvc3], [], [], [], [], [], [], []Fri Nov 4 14:27:47 2011 Errors in file /u01/admin/orcl/udump/orcl1_ora_15210.trc: ORA-00600: internal error code, … Continue reading →

Posted in BUG | Tagged , , , , , , , | Leave a comment

编译过程导致ORA-4068错误

Posted on 2012/05/19 by yangtingkun

一个10203上的bug，这种问题还是第一次碰到。 在10.2.0.3上，存在bug可能导致编译过程或视图失败，而失败的结果并不只是当前视图或过程不可用，而是可能影响整个数据字典，导致存储过程在执行时出现ORA-4068错误。 错误信息如下： ORA-04068: existing state OF packages has been discarded. ORA-04065: NOT executed, altered OR dropped stored PROCEDURE P_PACKAGE.P_PRO ORA-06508: PL/SQL: could NOT find program unit being called: P_PACKAGE.P_PRO ORA-06512: at line 1ORA-04068: existing state of packages has been … Continue reading →

Posted in BUG | Tagged , , , , | Leave a comment

包中添加新过程应在尾部添加

Posted on 2011/09/11 by yangtingkun

在看高级应用开发手册时，在对象依赖部分，注意到这个细节。 其他对象依赖包中的过程或函数，如果这个过程或函数在包中的位置发生了变化，那么依赖当前过程或函数的对象会被置为INVALID状态。 SQL> CREATE OR REPLACE PACKAGE P_TEST AS 2 PROCEDURE P1; 3 FUNCTION F1 RETURN NUMBER; 4 END; 5 / Package created. SQL> CREATE OR REPLACE FUNCTION F2 RETURN NUMBER AS 2 BEGIN 3 RETURN P_TEST.F1; 4 END; 5 … Continue reading →

Posted in ORACLE | Tagged , , | Leave a comment