问题描述
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的参数名是否与列名相同。
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。