*** 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 ---------------------
*** 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 ---------------------
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();
}
incomm.Parameters["GXSJ"].Value = "20080401";
incomm.ExecuteNonQuery(); 《===这行代码报错