*** SESSION ID:(34.5208) 2008-04-11 15:40:23.000
*** 2008-04-11 15:40:23.000
ksedmp: internal or fatal error
ORA-00600: 内部错误代码,参数: [16622], [], [], [], [], [], [], []
Current SQL statement for this session:
insert into  ry_rxzp (RYBH,RXZP,TXLY,TXSM,WRITETIME,RXFW,ZYBH,GXSJ) values (:RYBH,:RXZP,:TXLY,:TXSM,:WRITETIME,:RXFW,:ZYBH,:GXSJ)
----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------
_ksedmp+147          CALLrel  _ksedst+0            
_ksfdmp.108+e        CALLrel  _ksedmp+0            3
_kgeriv+89           CALLreg  00000000             75AF4C8 3
_kgeasi+bd           CALLrel  _kgeriv+0            75AF4C8 820B850 40EE 0
                                                   868B664
_kglslod+53          CALLrel  _kgeasi+0            75AF4C8 820B850 40EE 2 0
_kqlslod+26          CALLrel  _kglslod+0           75AF4C8 20733DC8 8
_kqlsublod+50        CALLrel  _kqlslod+0           20733DC8 8
_kqllod+c32          CALLreg  00000000             204A6280 868BD78 8
_kglobld+2d5         CALLreg  00000000             75AF4C8 204A6280 868BD78
_kglobpn+4a6         CALLrel  _kglobld+0           75AF4C8 20733DC8 868BD78
                                                   2313DCBC 0
..1.17_2.filter.2+c  CALLrel  _kglobpn+0           75AF4C8 2313DCBC 868BD78 1
e                                                  
_kglpin+373          CALLrel  _kglpim+0            75AF4C8 868BD78 2313DCBC
_kkdllpo+2f7         CALLrel  _kglpin+0            
_koklishdl+9a        CALLrel  _kkdllpo+0           42C0 868C048 868C044 2
                                                   868C02C 2 2 868C024 2 341
_kokliclo+1a7        CALLrel  _koklishdl+0         
_koklcre+25a         CALLrel  _kokliclo+0          868C304 D04C 0
_kokleva+449         CALLrel  _koklcre+0           
_evaopn2+17e         CALLreg  00000000             821FA20
_insolev.73+a4       CALLrel  _evaopn2+0           204A55A4
__VInfreq__insrow+3  CALLrel  _insolev.73+0        204A9770 821FA28 1
94                                                 
_insrow+61           CALLrel  _insbrp.73+0         
_insdrv.73+24d       CALLrel  _insrow+0            821FA28 868D75C 0
..1.6_1.filter.73+1  CALLrel  _insdrv.73+0         821FA28
11                                                 
..1.5_1.filter.29+1  CALLrel  _insexe+0            204A9770 868D9A0
1f                                                 
_opiall0+849         CALLrel  _opiexe+0            4 3 868DD7C
_kpoal8+5c6          CALLrel  _opiall0+0           5E 22 868DEF0 0 868DF90
                                                   5C89EB8 81 24 0 868DF7C 0 0 0
                                                   3DDEBF8
_opiodr+4cd          CALLreg  00000000             5E 14 868E738
_ttcpip+a86          CALLreg  00000000             5E 14 868E738 0
_opitsk+2f4          CALLrel  _ttcpip+0            
_opiino+5fc          CALLrel  _opitsk+0            0 0 75B5618 5EBF054 EC 0
_opiodr+4cd          CALLreg  00000000             3C 4 868FBD8
_opidrv+233          CALLrel  _opiodr+0            3C 4 868FBD8 0
_sou2o+19            CALLrel  _opidrv+0            
_opimai+10a          CALLrel  _sou2o+0             
_OracleThreadStart@  CALLrel  _opimai+0            
4+35c                                              
7C826088             CALLreg  00000000             
 
--------------------- Binary Stack Dump ---------------------

解决方案 »

  1.   

    数据表结构如下
    RYBH VARCHAR2(20) Y
    RXZP BLOB Y
    TXLY CHAR(2) Y
    TXSM VARCHAR2(80) Y
    WRITETIME DATE Y
    RXFW CHAR(2) Y
    ZYBH VARCHAR2(20) N
    GXSJ VARCHAR2(14) Y
    YXDKBJ CHAR(2) Y 0
    插入代码如下
     rycomm.CommandText = "select * from (select RYBH,RXZP,TXLY,TXSM,WRITETIME,RXFW,ZYBH,GXSJ,rownum as a from giapuser.ry_rxzp) where a>=" + beginnum + " and a<" + endnum;
                    wreader = rycomm.ExecuteReader();
                    while (wreader.Read())
                    {                    incomm.CommandText = "insert into  ry_rxzp (RYBH,RXZP,TXLY,TXSM,WRITETIME,RXFW,ZYBH,GXSJ) values (:RYBH,:RXZP,:TXLY,:TXSM,:WRITETIME,:RXFW,:ZYBH,:GXSJ)";
                        incomm.CommandType = CommandType.Text;
                        incomm.Parameters.Add("RYBH", OracleType.VarChar, 21);
                        incomm.Parameters.Add("RXZP", OracleType.Blob);
                        incomm.Parameters.Add("TXLY", OracleType.Char, 2);
                        incomm.Parameters.Add("TXSM", OracleType.VarChar, 80);
                        incomm.Parameters.Add("WRITETIME", OracleType.DateTime);
                        incomm.Parameters.Add("RXFW", OracleType.Char, 2);
                        incomm.Parameters.Add("ZYBH", OracleType.VarChar, 20);
                        incomm.Parameters.Add("GXSJ", OracleType.VarChar, 14);
                        if (!wreader.IsDBNull(0))
                            incomm.Parameters["RYBH"].Value = wreader.GetString(0);
                        else
                            incomm.Parameters["RYBH"].Value = "1";                    if (!wreader.IsDBNull(1))
                            incomm.Parameters["RXZP"].Value = wreader.GetOracleLob(1);
                        else
                            incomm.Parameters["RXZP"].Value = null;                    if (!wreader.IsDBNull(2))
                            incomm.Parameters["TXLY"].Value = wreader.GetString(2);
                        else
                            incomm.Parameters["TXLY"].Value = "1";                    if (!wreader.IsDBNull(3))
                            incomm.Parameters["TXSM"].Value = wreader.GetString(3);
                        else
                            incomm.Parameters["TXSM"].Value = "1";                    if (!wreader.IsDBNull(4))
                            incomm.Parameters["WRITETIME"].Value = wreader.GetOracleDateTime(4);
                        else
                            incomm.Parameters["WRITETIME"].Value = null;
                        if (!wreader.IsDBNull(5))
                            incomm.Parameters["RXFW"].Value = wreader.GetString(5);
                        else
                            incomm.Parameters["RXFW"].Value = "1";
                        if (!wreader.IsDBNull(6))
                            incomm.Parameters["ZYBH"].Value = wreader.GetString(6);
                        else
                            incomm.Parameters["ZYBH"].Value = "1";
                        if (!wreader.IsDBNull(7))
                            incomm.Parameters["GXSJ"].Value = wreader.GetString(7);
                        else
                            incomm.Parameters["GXSJ"].Value = "20080401";
                        incomm.ExecuteNonQuery();                    incomm.Parameters.Clear();
                        incomm.CommandText = "update transcore set beginnum=beginnum+1,endnum=endnum+1,updatedate=sysdate";
                        incomm.ExecuteNonQuery();
                      }
      

  2.   

    错误发生在
     incomm.Parameters["GXSJ"].Value = "20080401"; 
     incomm.ExecuteNonQuery(); 《===这行代码报错