S
sxbug
Unregistered / Unconfirmed
GUEST, unregistred user!
我在oracle中将大部分的工资字段都设成了number(10,2)。
在客户端操作时，我一般输入整数或小数，如：12、12.34等
但提交数据库时，客户端收到错误信息：
纪录没有找到或正被别人在修改
数据没有修改！我想：别人修改是不可能的，因为只有我一个人在用，而且也没有额外的修改进程。
我只好用sql monitor跟踪，可以看到如下结果：
正确更改员工表：
14:36:10 SQL Vendor: OCI 8 - OCIDefn
288 14:36:10 SQL Vendor: OCI 8 - OCIDefn
289 14:36:10 SQL Vendor: OCI 8 - OCIDefn
290 14:36:10 SQL Stmt: ORACLE - Fetch
291 14:36:10 SQL Vendor: OCI 8 - OCIStmtFetch
292 14:36:10 SQL Data Out: ORACLE - Column = 1, Name = 职工编号, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 103026
293 14:36:10 SQL Data Out: ORACLE - Column = 2, Name = 职工帐号, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 00087
294 14:36:10 SQL Data Out: ORACLE - Column = 3, Name = 姓名, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 戴民
295 14:36:10 SQL Data Out: ORACLE - Column = 4, Name = 部门编号, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 103
296 14:36:10 SQL Data Out: ORACLE - Column = 5, Name = 上班日期, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 9/5/1999 23:39:11:0
297 14:36:10 SQL Data Out: ORACLE - Column = 6, Name = 性别, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男
298 14:36:10 SQL Data Out: ORACLE - Column = 7, Name = 民族, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 汉族
299 14:36:10 SQL Data Out: ORACLE - Column = 8, Name = 政治面貌, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 群众
300 14:36:10 SQL Data Out: ORACLE - Column = 9, Name = 地址, Type = fldZSTRING, Precision = 40, Scale = 0, Data = rrrrrrrr
301 14:36:10 SQL Data Out: ORACLE - Column = 10, Name = 岗位, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 教师
302 14:36:10 SQL Data Out: ORACLE - Column = 11, Name = 职称, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 讲师
303 14:36:10 SQL Data Out: ORACLE - Column = 13, Name = 学历, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 大学
304 14:36:10 SQL Data Out: ORACLE - Column = 14, Name = 家庭电话, Type = fldZSTRING, Precision = 12, Scale = 0, Data = -
305 14:36:10 SQL Data Out: ORACLE - Column = 15, Name = 家庭电话1, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 2622465
306 14:36:10 SQL Data Out: ORACLE - Column = 16, Name = 家庭电话2, Type = fldZSTRING, Precision = 12, Scale = 0, Data = -
307 14:36:10 SQL Data Out: ORACLE - Column = 17, Name = 移动电话, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 13017100700
308 14:36:10 SQL Data Out: ORACLE - Column = 18, Name = 移动电话1, Type = fldZSTRING, Precision = 12, Scale = 0, Data = -
309 14:36:10 SQL Data Out: ORACLE - Column = 19, Name = 移动电话2, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 13707336301
310 14:36:10 SQL Data Out: ORACLE - Column = 20, Name = 移动电话3, Type = fldZSTRING, Precision = 12, Scale = 0, Data = -
311 14:36:10 SQL Data Out: ORACLE - Column = 21, Name = 传真, Type = fldZSTRING, Precision = 12, Scale = 0, Data = -
312 14:36:10 SQL Data Out: ORACLE - Column = 22, Name = E_MAIL, Type = fldZSTRING, Precision = 20, Scale = 0, Data = -
313 14:36:10 SQL Data Out: ORACLE - Column = 23, Name = 邮编, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 412008
314 14:36:10 SQL Data Out: ORACLE - Column = 24, Name = 生日, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 9/5/1999 23:39:11:0
315 14:36:10 SQL Data Out: ORACLE - Column = 25, Name = 出生地, Type = fldZSTRING, Precision = 40, Scale = 0, Data = -
316 14:36:10 SQL Data Out: ORACLE - Column = 26, Name = 婚否, Type = fldZSTRING, Precision = 1, Scale = 0, Data = T
317 14:36:10 SQL Data Out: ORACLE - Column = 27, Name = 个人简历, Type = fldZSTRING, Precision = 200, Scale = 0, Data = -
318 14:36:10 SQL Data Out: ORACLE - Column = 28, Name = 身份证号码, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 430203
319 14:36:10 SQL Data Out: ORACLE - Column = 29, Name = 上岗证, Type = fldZSTRING, Precision = 26, Scale = 0, Data = -
320 14:36:10 SQL Data Out: ORACLE - Column = 31, Name = 办公电话, Type = fldZSTRING, Precision = 12, Scale = 0, Data = -
321 14:36:10 SQL Prepare: ORACLE - update STAFF
set
EMPNO = :1,
USERNAME = :2,
DUTY = :3,
PHONE_WORK = :4,
HIREDATE = :5,
SEX = :6,
ETHNOS = :7,
POLITY = :8,
ADDRESS = :9,
EMPNO_INNER = :10,
SKILL = :11,
SPECILISM = :12,
EDUCATION = :13,
PHONE_HOME = :14,
PHONE_HOME1 = :15,
PHONE_HOME2 = :16,
PHONE_MOBILE = :17,
PHONE_MOBILE1 = :18,
PHONE_MOBILE2 = :19,
PHONE_MOBILE3 = :20,
FAX = :21,
E_MAIL = :22,
ZIPCODE = :23,
BIRTHDAY = :24,
BIRTHADDRESS = :25,
MARRIED = :26,
PERSONHISTORY = :27,
PERSONID = :28,
DUTYCERFI = :29,
DEPARTMENTID = :30
where
EMPNO = :31
322 14:36:10 SQL Vendor: OCI 8 - OCIHandleAlloc
323 14:36:10 SQL Vendor: OCI 8 - OCIHandleAlloc
324 14:36:10 SQL Vendor: OCI 8 - OCIStmtPrepare
325 14:36:10 SQL Vendor: OCI 8 - OCIAttrGet
326 14:36:10 SQL Vendor: OCI 8 - OCIBindByPos
327 14:36:10 SQL Vendor: OCI 8 - OCIBindByPos
328 14:36:10 SQL Vendor: OCI 8 - OCIBindByPos
329 14:36:10 SQL Vendor: OCI 8 - OCIBindByPos
330 14:36:10 SQL Vendor: OCI 8 - OCIBindByPos
331 14:36:10 SQL Vendor: OCI 8 - OCIBindByPos
无法修改工资表时：
454 14:33:55 SQL Vendor: OCI 8 - OCIAttrGet(OCI_ATTR_ROWCNT)
455 14:33:55 SQL Stmt: ORACLE - EOF
456 14:33:55 SQL Data Out: ORACLE - Column = 1, Name = 职工编号, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 104037
457 14:33:55 SQL Data Out: ORACLE - Column = 2, Name = 姓名, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 何红
458 14:33:55 SQL Data Out: ORACLE - Column = 3, Name = 职工帐号, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 00491
459 14:33:55 SQL Data Out: ORACLE - Column = 4, Name = 发放日期, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 12/4/2002 10:10:11:0
460 14:33:55 SQL Data Out: ORACLE - Column = 5, Name = 岗位, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 教师
461 14:33:55 SQL Data Out: ORACLE - Column = 6, Name = 性别, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男
462 14:33:55 SQL Data Out: ORACLE - Column = 7, Name = 部门, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 经贸系
463 14:33:55 SQL Data Out: ORACLE - Column = 8, Name = 上班日期, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 9/5/1999 23:39:11:0
464 14:33:55 SQL Data Out: ORACLE - Column = 9, Name = 职称, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 讲师
465 14:33:55 SQL Data Out: ORACLE - Column = 10, Name = 学历, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 大学
466 14:33:55 SQL Data Out: ORACLE - Column = 11, Name = 水电费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
467 14:33:55 SQL Data Out: ORACLE - Column = 12, Name = 电话费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 20.000000
468 14:33:55 SQL Data Out: ORACLE - Column = 13, Name = 补贴1, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 80.000000
469 14:33:55 SQL Data Out: ORACLE - Column = 14, Name = 补贴2, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
470 14:33:55 SQL Data Out: ORACLE - Column = 15, Name = 补贴3, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
471 14:33:55 SQL Data Out: ORACLE - Column = 16, Name = 岗位工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 684.000000
472 14:33:55 SQL Data Out: ORACLE - Column = 17, Name = 学历工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
473 14:33:55 SQL Data Out: ORACLE - Column = 18, Name = 洗理费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
474 14:33:55 SQL Data Out: ORACLE - Column = 19, Name = 煤气费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
475 14:33:55 SQL Data Out: ORACLE - Column = 20, Name = 应发工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 995.800000
476 14:33:55 SQL Data Out: ORACLE - Column = 21, Name = 请假扣款, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
477 14:33:55 SQL Data Out: ORACLE - Column = 22, Name = 保险费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
478 14:33:55 SQL Data Out: ORACLE - Column = 23, Name = 所得税, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 15.000000
479 14:33:55 SQL Data Out: ORACLE - Column = 24, Name = 公积金, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 38.000000
480 14:33:55 SQL Data Out: ORACLE - Column = 25, Name = 统筹金, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
481 14:33:55 SQL Data Out: ORACLE - Column = 26, Name = 医疗保险金, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
482 14:33:55 SQL Data Out: ORACLE - Column = 27, Name = 实发工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 1684.910000
483 14:33:55 SQL Data Out: ORACLE - Column = 28, Name = 基本工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 535.000000
484 14:33:55 SQL Data Out: ORACLE - Column = 29, Name = 津贴, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 75.000000
485 14:33:55 SQL Data Out: ORACLE - Column = 30, Name = 房租, Type = fldFLOAT, Precision = 5, Scale = 2, Data = 0.000000
486 14:33:55 SQL Data Out: ORACLE - Column = 31, Name = 污染费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
487 14:33:55 SQL Data Out: ORACLE - Column = 32, Name = 卫生费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
488 14:33:55 SQL Data Out: ORACLE - Column = 33, Name = 补差工资, Type = fldFLOAT, Precision = 8, Scale = 2, Data = 0.000000
489 14:33:55 SQL Data Out: ORACLE - Column = 34, Name = 个人简易保险, Type = fldFLOAT, Precision = 8, Scale = 2, Data = 0.000000
490 14:33:55 SQL Data Out: ORACLE - Column = 35, Name = 省地郊补, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 150.800000
491 14:33:55 SQL Data Out: ORACLE - Column = 36, Name = 交通补助, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 70.000000
492 14:33:55 SQL Data Out: ORACLE - Column = 37, Name = 合计扣款, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 64.890000
493 14:33:55 SQL Data Out: ORACLE - Column = 38, Name = 扣款1, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
494 14:33:55 SQL Data Out: ORACLE - Column = 39, Name = 扣款2, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
495 14:33:55 SQL Data Out: ORACLE - Column = 40, Name = 备注, Type = fldZSTRING, Precision = 160, Scale = 0, Data = -
496 14:33:55 SQL Data Out: ORACLE - Column = 41, Name = 改变标志, Type = fldZSTRING, Precision = 1, Scale = 0, Data = F
497 14:33:55 SQL Data Out: ORACLE - Column = 42, Name = 日工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 60.190000
498 14:33:55 SQL Data Out: ORACLE - Column = 43, Name = 部门编号, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 104
499 14:33:55 SQL Data Out: ORACLE - Column = 44, Name = 实发数1, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 930.910000
500 14:33:55 SQL Data Out: ORACLE - Column = 45, Name = 实发数2, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 754.000000
501 14:33:55 SQL Data Out: ORACLE - Column = 46, Name = 补贴4, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
502 14:33:55 SQL Data Out: ORACLE - Column = 47, Name = 生活补贴, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 155.000000
503 14:33:55 SQL Data Out: ORACLE - Column = 48, Name = 年功工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
504 14:33:55 SQL Data Out: ORACLE - Column = 49, Name = 独生子女费, Type = fldFLOAT, Precision = 5, Scale = 2, Data = 0.000000
505 14:33:55 SQL Data Out: ORACLE - Column = 1, Name = 职工编号, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 410004
506 14:33:55 SQL Data Out: ORACLE - Column = 2, Name = 姓名, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 何峰
507 14:33:55 SQL Data Out: ORACLE - Column = 3, Name = 职工帐号, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 00488
508 14:33:55 SQL Data Out: ORACLE - Column = 4, Name = 发放日期, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 12/4/2002 10:10:11:0
509 14:33:55 SQL Data Out: ORACLE - Column = 5, Name = 岗位, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 教师
510 14:33:55 SQL Data Out: ORACLE - Column = 6, Name = 性别, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男
511 14:33:55 SQL Data Out: ORACLE - Column = 7, Name = 部门, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 财务处
512 14:33:55 SQL Data Out: ORACLE - Column = 8, Name = 上班日期, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 9/5/1999 23:39:11:0
513 14:33:55 SQL Data Out: ORACLE - Column = 9, Name = 职称, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 讲师
514 14:33:55 SQL Data Out: ORACLE - Column = 10, Name = 学历, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 大学
515 14:33:55 SQL Data Out: ORACLE - Column = 11, Name = 水电费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
516 14:33:55 SQL Data Out: ORACLE - Column = 12, Name = 电话费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = -1.000000
517 14:33:55 SQL Data Out: ORACLE - Column = 13, Name = 补贴1, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 80.000000
518 14:33:55 SQL Data Out: ORACLE - Column = 14, Name = 补贴2, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
519 14:33:55 SQL Data Out: ORACLE - Column = 15, Name = 补贴3, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
520 14:33:55 SQL Data Out: ORACLE - Column = 16, Name = 岗位工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 349.000000
521 14:33:55 SQL Data Out: ORACLE - Column = 17, Name = 学历工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
522 14:33:55 SQL Data Out: ORACLE - Column = 18, Name = 洗理费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
523 14:33:55 SQL Data Out: ORACLE - Column = 19, Name = 煤气费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
524 14:33:55 SQL Data Out: ORACLE - Column = 20, Name = 应发工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
525 14:33:55 SQL Data Out: ORACLE - Column = 21, Name = 请假扣款, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
526 14:33:55 SQL Data Out: ORACLE - Column = 22, Name = 保险费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
527 14:33:55 SQL Data Out: ORACLE - Column = 23, Name = 所得税, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 10.000000
528 14:33:55 SQL Data Out: ORACLE - Column = 24, Name = 公积金, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 31.000000
529 14:33:55 SQL Data Out: ORACLE - Column = 25, Name = 统筹金, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
530 14:33:55 SQL Data Out: ORACLE - Column = 26, Name = 医疗保险金, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
531 14:33:55 SQL Data Out: ORACLE - Column = 27, Name = 实发工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
532 14:33:55 SQL Data Out: ORACLE - Column = 28, Name = 基本工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 354.000000
533 14:33:55 SQL Data Out: ORACLE - Column = 29, Name = 津贴, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 41.000000
534 14:33:55 SQL Data Out: ORACLE - Column = 30, Name = 房租, Type = fldFLOAT, Precision = 5, Scale = 2, Data = 0.000000
535 14:33:55 SQL Data Out: ORACLE - Column = 31, Name = 污染费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
536 14:33:55 SQL Data Out: ORACLE - Column = 32, Name = 卫生费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
537 14:33:55 SQL Data Out: ORACLE - Column = 33, Name = 补差工资, Type = fldFLOAT, Precision = 8, Scale = 2, Data = 0.000000
538 14:33:55 SQL Data Out: ORACLE - Column = 34, Name = 个人简易保险, Type = fldFLOAT, Precision = 8, Scale = 2, Data = 0.000000
539 14:33:55 SQL Data Out: ORACLE - Column = 35, Name = 省地郊补, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 140.800000
540 14:33:55 SQL Data Out: ORACLE - Column = 36, Name = 交通补助, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 30.000000
541 14:33:55 SQL Data Out: ORACLE - Column = 37, Name = 合计扣款, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
542 14:33:55 SQL Data Out: ORACLE - Column = 38, Name = 扣款1, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
543 14:33:55 SQL Data Out: ORACLE - Column = 39, Name = 扣款2, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
544 14:33:55 SQL Data Out: ORACLE - Column = 40, Name = 备注, Type = fldZSTRING, Precision = 160, Scale = 0, Data = -
545 14:33:55 SQL Data Out: ORACLE - Column = 41, Name = 改变标志, Type = fldZSTRING, Precision = 1, Scale = 0, Data = F
546 14:33:55 SQL Data Out: ORACLE - Column = 42, Name = 日工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
。。。。。
946 14:33:55 SQL Stmt: ORACLE - Reset
947 14:33:55 SQL Transact: ORACLE - XACT Abort
948 14:33:55 SQL Prepare: ORACLE - ROLLBACK WORK
949 14:33:55 SQL Vendor: OCI 8 - OCIHandleAlloc
950 14:33:55 SQL Vendor: OCI 8 - OCIHandleAlloc
951 14:33:55 SQL Vendor: OCI 8 - OCIStmtPrepare
952 14:33:55 SQL Vendor: OCI 8 - OCIAttrGet
953 14:33:55 SQL Execute: ORACLE - ROLLBACK WORK
954 14:33:55 SQL Vendor: OCI 8 - OCIStmtExecute
955 14:33:55 SQL Stmt: ORACLE - Close
956 14:33:55 SQL Vendor: OCI 8 - OCIHandleFree(OCI_HTYPE_DESC)
957 14:33:55 SQL Vendor: OCI 8 - OCIHandleFree(OCI_HTYPE_STMT)
958 14:33:55 SQL Stmt: ORACLE - Close
现在我唯一怀疑：传递过来的值，是不是有问题。如数据库是currency型，而传过来的是float型？
系统运行环竟：win2k+dcom+oracle9+delphi6
高手们救命了！！！！！！
在客户端操作时，我一般输入整数或小数，如：12、12.34等
但提交数据库时，客户端收到错误信息：
纪录没有找到或正被别人在修改
数据没有修改！我想：别人修改是不可能的，因为只有我一个人在用，而且也没有额外的修改进程。
我只好用sql monitor跟踪，可以看到如下结果：
正确更改员工表：
14:36:10 SQL Vendor: OCI 8 - OCIDefn
288 14:36:10 SQL Vendor: OCI 8 - OCIDefn
289 14:36:10 SQL Vendor: OCI 8 - OCIDefn
290 14:36:10 SQL Stmt: ORACLE - Fetch
291 14:36:10 SQL Vendor: OCI 8 - OCIStmtFetch
292 14:36:10 SQL Data Out: ORACLE - Column = 1, Name = 职工编号, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 103026
293 14:36:10 SQL Data Out: ORACLE - Column = 2, Name = 职工帐号, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 00087
294 14:36:10 SQL Data Out: ORACLE - Column = 3, Name = 姓名, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 戴民
295 14:36:10 SQL Data Out: ORACLE - Column = 4, Name = 部门编号, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 103
296 14:36:10 SQL Data Out: ORACLE - Column = 5, Name = 上班日期, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 9/5/1999 23:39:11:0
297 14:36:10 SQL Data Out: ORACLE - Column = 6, Name = 性别, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男
298 14:36:10 SQL Data Out: ORACLE - Column = 7, Name = 民族, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 汉族
299 14:36:10 SQL Data Out: ORACLE - Column = 8, Name = 政治面貌, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 群众
300 14:36:10 SQL Data Out: ORACLE - Column = 9, Name = 地址, Type = fldZSTRING, Precision = 40, Scale = 0, Data = rrrrrrrr
301 14:36:10 SQL Data Out: ORACLE - Column = 10, Name = 岗位, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 教师
302 14:36:10 SQL Data Out: ORACLE - Column = 11, Name = 职称, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 讲师
303 14:36:10 SQL Data Out: ORACLE - Column = 13, Name = 学历, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 大学
304 14:36:10 SQL Data Out: ORACLE - Column = 14, Name = 家庭电话, Type = fldZSTRING, Precision = 12, Scale = 0, Data = -
305 14:36:10 SQL Data Out: ORACLE - Column = 15, Name = 家庭电话1, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 2622465
306 14:36:10 SQL Data Out: ORACLE - Column = 16, Name = 家庭电话2, Type = fldZSTRING, Precision = 12, Scale = 0, Data = -
307 14:36:10 SQL Data Out: ORACLE - Column = 17, Name = 移动电话, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 13017100700
308 14:36:10 SQL Data Out: ORACLE - Column = 18, Name = 移动电话1, Type = fldZSTRING, Precision = 12, Scale = 0, Data = -
309 14:36:10 SQL Data Out: ORACLE - Column = 19, Name = 移动电话2, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 13707336301
310 14:36:10 SQL Data Out: ORACLE - Column = 20, Name = 移动电话3, Type = fldZSTRING, Precision = 12, Scale = 0, Data = -
311 14:36:10 SQL Data Out: ORACLE - Column = 21, Name = 传真, Type = fldZSTRING, Precision = 12, Scale = 0, Data = -
312 14:36:10 SQL Data Out: ORACLE - Column = 22, Name = E_MAIL, Type = fldZSTRING, Precision = 20, Scale = 0, Data = -
313 14:36:10 SQL Data Out: ORACLE - Column = 23, Name = 邮编, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 412008
314 14:36:10 SQL Data Out: ORACLE - Column = 24, Name = 生日, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 9/5/1999 23:39:11:0
315 14:36:10 SQL Data Out: ORACLE - Column = 25, Name = 出生地, Type = fldZSTRING, Precision = 40, Scale = 0, Data = -
316 14:36:10 SQL Data Out: ORACLE - Column = 26, Name = 婚否, Type = fldZSTRING, Precision = 1, Scale = 0, Data = T
317 14:36:10 SQL Data Out: ORACLE - Column = 27, Name = 个人简历, Type = fldZSTRING, Precision = 200, Scale = 0, Data = -
318 14:36:10 SQL Data Out: ORACLE - Column = 28, Name = 身份证号码, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 430203
319 14:36:10 SQL Data Out: ORACLE - Column = 29, Name = 上岗证, Type = fldZSTRING, Precision = 26, Scale = 0, Data = -
320 14:36:10 SQL Data Out: ORACLE - Column = 31, Name = 办公电话, Type = fldZSTRING, Precision = 12, Scale = 0, Data = -
321 14:36:10 SQL Prepare: ORACLE - update STAFF
set
EMPNO = :1,
USERNAME = :2,
DUTY = :3,
PHONE_WORK = :4,
HIREDATE = :5,
SEX = :6,
ETHNOS = :7,
POLITY = :8,
ADDRESS = :9,
EMPNO_INNER = :10,
SKILL = :11,
SPECILISM = :12,
EDUCATION = :13,
PHONE_HOME = :14,
PHONE_HOME1 = :15,
PHONE_HOME2 = :16,
PHONE_MOBILE = :17,
PHONE_MOBILE1 = :18,
PHONE_MOBILE2 = :19,
PHONE_MOBILE3 = :20,
FAX = :21,
E_MAIL = :22,
ZIPCODE = :23,
BIRTHDAY = :24,
BIRTHADDRESS = :25,
MARRIED = :26,
PERSONHISTORY = :27,
PERSONID = :28,
DUTYCERFI = :29,
DEPARTMENTID = :30
where
EMPNO = :31
322 14:36:10 SQL Vendor: OCI 8 - OCIHandleAlloc
323 14:36:10 SQL Vendor: OCI 8 - OCIHandleAlloc
324 14:36:10 SQL Vendor: OCI 8 - OCIStmtPrepare
325 14:36:10 SQL Vendor: OCI 8 - OCIAttrGet
326 14:36:10 SQL Vendor: OCI 8 - OCIBindByPos
327 14:36:10 SQL Vendor: OCI 8 - OCIBindByPos
328 14:36:10 SQL Vendor: OCI 8 - OCIBindByPos
329 14:36:10 SQL Vendor: OCI 8 - OCIBindByPos
330 14:36:10 SQL Vendor: OCI 8 - OCIBindByPos
331 14:36:10 SQL Vendor: OCI 8 - OCIBindByPos
无法修改工资表时：
454 14:33:55 SQL Vendor: OCI 8 - OCIAttrGet(OCI_ATTR_ROWCNT)
455 14:33:55 SQL Stmt: ORACLE - EOF
456 14:33:55 SQL Data Out: ORACLE - Column = 1, Name = 职工编号, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 104037
457 14:33:55 SQL Data Out: ORACLE - Column = 2, Name = 姓名, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 何红
458 14:33:55 SQL Data Out: ORACLE - Column = 3, Name = 职工帐号, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 00491
459 14:33:55 SQL Data Out: ORACLE - Column = 4, Name = 发放日期, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 12/4/2002 10:10:11:0
460 14:33:55 SQL Data Out: ORACLE - Column = 5, Name = 岗位, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 教师
461 14:33:55 SQL Data Out: ORACLE - Column = 6, Name = 性别, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男
462 14:33:55 SQL Data Out: ORACLE - Column = 7, Name = 部门, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 经贸系
463 14:33:55 SQL Data Out: ORACLE - Column = 8, Name = 上班日期, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 9/5/1999 23:39:11:0
464 14:33:55 SQL Data Out: ORACLE - Column = 9, Name = 职称, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 讲师
465 14:33:55 SQL Data Out: ORACLE - Column = 10, Name = 学历, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 大学
466 14:33:55 SQL Data Out: ORACLE - Column = 11, Name = 水电费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
467 14:33:55 SQL Data Out: ORACLE - Column = 12, Name = 电话费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 20.000000
468 14:33:55 SQL Data Out: ORACLE - Column = 13, Name = 补贴1, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 80.000000
469 14:33:55 SQL Data Out: ORACLE - Column = 14, Name = 补贴2, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
470 14:33:55 SQL Data Out: ORACLE - Column = 15, Name = 补贴3, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
471 14:33:55 SQL Data Out: ORACLE - Column = 16, Name = 岗位工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 684.000000
472 14:33:55 SQL Data Out: ORACLE - Column = 17, Name = 学历工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
473 14:33:55 SQL Data Out: ORACLE - Column = 18, Name = 洗理费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
474 14:33:55 SQL Data Out: ORACLE - Column = 19, Name = 煤气费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
475 14:33:55 SQL Data Out: ORACLE - Column = 20, Name = 应发工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 995.800000
476 14:33:55 SQL Data Out: ORACLE - Column = 21, Name = 请假扣款, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
477 14:33:55 SQL Data Out: ORACLE - Column = 22, Name = 保险费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
478 14:33:55 SQL Data Out: ORACLE - Column = 23, Name = 所得税, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 15.000000
479 14:33:55 SQL Data Out: ORACLE - Column = 24, Name = 公积金, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 38.000000
480 14:33:55 SQL Data Out: ORACLE - Column = 25, Name = 统筹金, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
481 14:33:55 SQL Data Out: ORACLE - Column = 26, Name = 医疗保险金, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
482 14:33:55 SQL Data Out: ORACLE - Column = 27, Name = 实发工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 1684.910000
483 14:33:55 SQL Data Out: ORACLE - Column = 28, Name = 基本工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 535.000000
484 14:33:55 SQL Data Out: ORACLE - Column = 29, Name = 津贴, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 75.000000
485 14:33:55 SQL Data Out: ORACLE - Column = 30, Name = 房租, Type = fldFLOAT, Precision = 5, Scale = 2, Data = 0.000000
486 14:33:55 SQL Data Out: ORACLE - Column = 31, Name = 污染费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
487 14:33:55 SQL Data Out: ORACLE - Column = 32, Name = 卫生费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
488 14:33:55 SQL Data Out: ORACLE - Column = 33, Name = 补差工资, Type = fldFLOAT, Precision = 8, Scale = 2, Data = 0.000000
489 14:33:55 SQL Data Out: ORACLE - Column = 34, Name = 个人简易保险, Type = fldFLOAT, Precision = 8, Scale = 2, Data = 0.000000
490 14:33:55 SQL Data Out: ORACLE - Column = 35, Name = 省地郊补, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 150.800000
491 14:33:55 SQL Data Out: ORACLE - Column = 36, Name = 交通补助, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 70.000000
492 14:33:55 SQL Data Out: ORACLE - Column = 37, Name = 合计扣款, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 64.890000
493 14:33:55 SQL Data Out: ORACLE - Column = 38, Name = 扣款1, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
494 14:33:55 SQL Data Out: ORACLE - Column = 39, Name = 扣款2, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
495 14:33:55 SQL Data Out: ORACLE - Column = 40, Name = 备注, Type = fldZSTRING, Precision = 160, Scale = 0, Data = -
496 14:33:55 SQL Data Out: ORACLE - Column = 41, Name = 改变标志, Type = fldZSTRING, Precision = 1, Scale = 0, Data = F
497 14:33:55 SQL Data Out: ORACLE - Column = 42, Name = 日工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 60.190000
498 14:33:55 SQL Data Out: ORACLE - Column = 43, Name = 部门编号, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 104
499 14:33:55 SQL Data Out: ORACLE - Column = 44, Name = 实发数1, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 930.910000
500 14:33:55 SQL Data Out: ORACLE - Column = 45, Name = 实发数2, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 754.000000
501 14:33:55 SQL Data Out: ORACLE - Column = 46, Name = 补贴4, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
502 14:33:55 SQL Data Out: ORACLE - Column = 47, Name = 生活补贴, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 155.000000
503 14:33:55 SQL Data Out: ORACLE - Column = 48, Name = 年功工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
504 14:33:55 SQL Data Out: ORACLE - Column = 49, Name = 独生子女费, Type = fldFLOAT, Precision = 5, Scale = 2, Data = 0.000000
505 14:33:55 SQL Data Out: ORACLE - Column = 1, Name = 职工编号, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 410004
506 14:33:55 SQL Data Out: ORACLE - Column = 2, Name = 姓名, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 何峰
507 14:33:55 SQL Data Out: ORACLE - Column = 3, Name = 职工帐号, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 00488
508 14:33:55 SQL Data Out: ORACLE - Column = 4, Name = 发放日期, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 12/4/2002 10:10:11:0
509 14:33:55 SQL Data Out: ORACLE - Column = 5, Name = 岗位, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 教师
510 14:33:55 SQL Data Out: ORACLE - Column = 6, Name = 性别, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男
511 14:33:55 SQL Data Out: ORACLE - Column = 7, Name = 部门, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 财务处
512 14:33:55 SQL Data Out: ORACLE - Column = 8, Name = 上班日期, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 9/5/1999 23:39:11:0
513 14:33:55 SQL Data Out: ORACLE - Column = 9, Name = 职称, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 讲师
514 14:33:55 SQL Data Out: ORACLE - Column = 10, Name = 学历, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 大学
515 14:33:55 SQL Data Out: ORACLE - Column = 11, Name = 水电费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
516 14:33:55 SQL Data Out: ORACLE - Column = 12, Name = 电话费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = -1.000000
517 14:33:55 SQL Data Out: ORACLE - Column = 13, Name = 补贴1, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 80.000000
518 14:33:55 SQL Data Out: ORACLE - Column = 14, Name = 补贴2, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
519 14:33:55 SQL Data Out: ORACLE - Column = 15, Name = 补贴3, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
520 14:33:55 SQL Data Out: ORACLE - Column = 16, Name = 岗位工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 349.000000
521 14:33:55 SQL Data Out: ORACLE - Column = 17, Name = 学历工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
522 14:33:55 SQL Data Out: ORACLE - Column = 18, Name = 洗理费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
523 14:33:55 SQL Data Out: ORACLE - Column = 19, Name = 煤气费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
524 14:33:55 SQL Data Out: ORACLE - Column = 20, Name = 应发工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
525 14:33:55 SQL Data Out: ORACLE - Column = 21, Name = 请假扣款, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
526 14:33:55 SQL Data Out: ORACLE - Column = 22, Name = 保险费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
527 14:33:55 SQL Data Out: ORACLE - Column = 23, Name = 所得税, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 10.000000
528 14:33:55 SQL Data Out: ORACLE - Column = 24, Name = 公积金, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 31.000000
529 14:33:55 SQL Data Out: ORACLE - Column = 25, Name = 统筹金, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
530 14:33:55 SQL Data Out: ORACLE - Column = 26, Name = 医疗保险金, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
531 14:33:55 SQL Data Out: ORACLE - Column = 27, Name = 实发工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
532 14:33:55 SQL Data Out: ORACLE - Column = 28, Name = 基本工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 354.000000
533 14:33:55 SQL Data Out: ORACLE - Column = 29, Name = 津贴, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 41.000000
534 14:33:55 SQL Data Out: ORACLE - Column = 30, Name = 房租, Type = fldFLOAT, Precision = 5, Scale = 2, Data = 0.000000
535 14:33:55 SQL Data Out: ORACLE - Column = 31, Name = 污染费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
536 14:33:55 SQL Data Out: ORACLE - Column = 32, Name = 卫生费, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
537 14:33:55 SQL Data Out: ORACLE - Column = 33, Name = 补差工资, Type = fldFLOAT, Precision = 8, Scale = 2, Data = 0.000000
538 14:33:55 SQL Data Out: ORACLE - Column = 34, Name = 个人简易保险, Type = fldFLOAT, Precision = 8, Scale = 2, Data = 0.000000
539 14:33:55 SQL Data Out: ORACLE - Column = 35, Name = 省地郊补, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 140.800000
540 14:33:55 SQL Data Out: ORACLE - Column = 36, Name = 交通补助, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 30.000000
541 14:33:55 SQL Data Out: ORACLE - Column = 37, Name = 合计扣款, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
542 14:33:55 SQL Data Out: ORACLE - Column = 38, Name = 扣款1, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
543 14:33:55 SQL Data Out: ORACLE - Column = 39, Name = 扣款2, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
544 14:33:55 SQL Data Out: ORACLE - Column = 40, Name = 备注, Type = fldZSTRING, Precision = 160, Scale = 0, Data = -
545 14:33:55 SQL Data Out: ORACLE - Column = 41, Name = 改变标志, Type = fldZSTRING, Precision = 1, Scale = 0, Data = F
546 14:33:55 SQL Data Out: ORACLE - Column = 42, Name = 日工资, Type = fldFLOAT, Precision = 10, Scale = 2, Data = 0.000000
。。。。。
946 14:33:55 SQL Stmt: ORACLE - Reset
947 14:33:55 SQL Transact: ORACLE - XACT Abort
948 14:33:55 SQL Prepare: ORACLE - ROLLBACK WORK
949 14:33:55 SQL Vendor: OCI 8 - OCIHandleAlloc
950 14:33:55 SQL Vendor: OCI 8 - OCIHandleAlloc
951 14:33:55 SQL Vendor: OCI 8 - OCIStmtPrepare
952 14:33:55 SQL Vendor: OCI 8 - OCIAttrGet
953 14:33:55 SQL Execute: ORACLE - ROLLBACK WORK
954 14:33:55 SQL Vendor: OCI 8 - OCIStmtExecute
955 14:33:55 SQL Stmt: ORACLE - Close
956 14:33:55 SQL Vendor: OCI 8 - OCIHandleFree(OCI_HTYPE_DESC)
957 14:33:55 SQL Vendor: OCI 8 - OCIHandleFree(OCI_HTYPE_STMT)
958 14:33:55 SQL Stmt: ORACLE - Close
现在我唯一怀疑：传递过来的值，是不是有问题。如数据库是currency型，而传过来的是float型？
系统运行环竟：win2k+dcom+oracle9+delphi6
高手们救命了！！！！！！