一个procedure创建时出错,ERROR信息为ORA600 [qcsgpvc3]，出错部分为：

      INSERT INTO sfism4.wip_d_smt_alarm
                  (machine_code, product_no, ver, emp_no, feeder_no,
                   key_part_no, line_name, alarm_flag
                  )
           VALUES (machine, ppn, ver, emp, loc,
                   v_kpn, line, 'Y');

查找metalink发现，是10.2.0.4的一个BUG,变量名ver与列名ver相同。

以下来源于metalink。

Bug 7172752  OERI[qcsgpvc3] recompiling a package body

Affects:

Product (Component)	Oracle Server (Rdbms)
Range of versions believed to be affected	Versions < 11.2
Versions confirmed as being affected	10.2.0.4
Platforms affected	Generic (all / most platforms affected)

Fixed:

This issue is fixed in

10.2.0.4.2 (Patch Set Update) 10.2.0.5 (Server Patch Set) 11.2.0.1 (Base Release)

Description

An ORA-600 can occur while recompiling stored PLSQL 
if a procedure / function argument name matches to a column
name referred to in that function / procedure .

eg:
 create table t( c1 varchar2(60),c2 number);
 create or replace package p is
 procedure po(c1 varchar2,c2 number);
 end p;
 /
 Prompt create a procedure so it raises ora-904 (wrong col name)
 create or replace package body p is
   procedure po(c1 varchar2,c2 number)
   is
   begin
     insert into t(c1,i_bad -- wrong column name
     ) 
     values(c1,c2);
   end po;
 end p;
 /
 create or replace package body p is
   procedure po(c1 varchar2,c2 number)
   is
   begin
     insert into t(c1,c2) values (c1,c2);
   end po;
 end p;
 /
 alter table t rename column c2 to i_problem;
 alter package p compile body;
 ^
 ORA-600

Workaround
  Change the Function/procedure's argument name so that it does not
  match to any column name being referred in the function/procedure body.