ANBOB™

Bug 7172752 OERI[qcsgpvc3] recompiling a package body

anbob@ORCL>create table testp(pid number,pname varchar2(20));

Table created.

anbob@ORCL>create or replace package pkg is
  2  procedure pins(pid number,pname varchar2);
  3  end;
  4  /

Package created.

anbob@ORCL>create or replace package body pkg is
  2  procedure pins(pid number,pname varchar2)
  3  is
  4  begin
  5  insert into testp(pid,pname) values(pid,pname);
  6  end;
  7  end;
  8  /

Package body created.

anbob@ORCL>alter table testp rename column pname to p_name;

Table altered.

anbob@ORCL>alter package pkg compile body;

Warning: Package Body altered with compilation errors.

anbob@ORCL>show err
Errors for PACKAGE BODY PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
5/1      PL/SQL: SQL Statement ignored
5/13     PL/SQL: ORA-00600: internal error code, arguments: [qcsgpvc3],
         [], [], [], [], [], [], []

anbob@ORCL>create or replace package body pkg is
  2  procedure pins(pid number,pname varchar2)
  3  is
  4  begin
  5  insert into testp(pid,p_name) values(pid,pname);
  6  end;
  7  end;
  8  /

Package body created.

anbob@ORCL>select * from testp;

no rows selected

anbob@ORCL>exec pkg.pins(1,'anbob');

PL/SQL procedure successfully completed.

anbob@ORCL>select * from testp;

       PID P_NAME
---------- --------------------
         1 anbob
anbob@ORCL>select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

[oracle@aix bdump]$ tail alert_orcl.log 
ORA-00600: internal error code, arguments: [qcsgpvc3], [], [], [], [], [], [], []
Mon Apr  9 13:35:56 2012
Errors in file /oracle/admin/orcl/udump/orcl_ora_7388.trc:
ORA-00600: internal error code, arguments: [qcsgpvc3], [], [], [], [], [], [], []
Mon Apr  9 13:36:24 2012

[oracle@aix bdump]$ vi /oracle/admin/orcl/udump/orcl_ora_7388.trc

/oracle/admin/orcl/udump/orcl_ora_7388.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/product/10.2.0
System name:    Linux
Node name:      aix
Release:        2.6.18-238.el5
Version:        #1 SMP Thu Jan 13 15:51:15 EST 2011
Machine:        x86_64
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 18
Unix process pid: 7388, image: oracle@aix (TNS V1-V3)

*** ACTION NAME:() 2012-04-09 13:34:45.372
*** MODULE NAME:(SQL*Plus) 2012-04-09 13:34:45.372
*** SERVICE NAME:(SYS$USERS) 2012-04-09 13:34:45.372
*** SESSION ID:(176.247) 2012-04-09 13:34:45.372
*** 2012-04-09 13:34:45.372
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [qcsgpvc3], [], [], [], [], [], [], []
No current SQL statement being executed.
----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31          call     ksedst1()            000000000 ? 000000001 ?
                                                   7FFF04F59140 ? 7FFF04F591A0 ?
                                                   7FFF04F590E0 ? 000000000 ?
ksedmp()+610         call     ksedst()             000000000 ? 000000001 ?
                                                   7FFF04F59140 ? 7FFF04F591A0 ?
。。。

note:
Bug 7172752 OERI[qcsgpvc3] recompiling a package body,
fixed version:
10.2.0.4.2 (Patch Set Update)
10.2.0.5 (Server Patch Set)
11.2.0.1 (Base Release)
可以选择打补丁或升级，如果无停机时间，临时解决办法就是找出编译错误的package body,检查FUNCTION 或PROCEDURE的参数名是否与列名相同。

打赏

微信扫一扫，打赏作者吧～