|
안녕하세요..
TQuery의 Edit/Post메소드로데이터를 변경하는 처리가
어떤때는 에러가 나고 어떤 때는 정상적으로 처리 되는
경우가 발생했습니다.
SQL모니터로 확인한 로그입니다.
같은 처리인데 아래와 같이 정상일때가 있고 에러일때 가 있습니다..
무엇이 문제일까요??? 정말 모르겠습니다..
정상일 때는 9845 17:34:31 SQL Data In: ORACLE - Rows affected = 1
에러일때는 184422 19:49:36 SQL Data In: ORACLE - Rows affected = 0
>>1. 정상일때는
9830 17:34:31 SQL Prepare: ORACLE - UPDATE "TEST_HEAD" SET "INTIME"=:1 WHERE "TEST_ID"=:2 AND "TT_NAME"=:3 AND "PRN_NAME"=:4 AND "SCOMMENT"=:5 AND "INDATE"=:6 AND "INTIME"=:7 AND "BLK_CNT"=:8 AND "LOCK_FLAG"=:9 AND "USER_ID"=:10 AND "TEST_LIB_ID" IS NULL AND "ACCS_DATE" IS NULL AND "ACCS_TIME" IS NULL AND "LIB_FLAG"=:11 AND "TUNING_FLAG"=:12 AND "ROWID"=:13
9831 17:34:31 SQL Data In: ORACLE - Param = 1, Name = INTIME, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:34:25
9832 17:34:31 SQL Data In: ORACLE - Param = 2, Name = TEST_ID, Type = fldFLOAT, Precision = 4, Scale = 0, Data = 11.000000
9833 17:34:31 SQL Data In: ORACLE - Param = 3, Name = TT_NAME, Type = fldZSTRING, Precision = 16, Scale = 0, Data = ABS-2004 m0 12
9834 17:34:31 SQL Data In: ORACLE - Param = 4, Name = PRN_NAME, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 079461-2007
9835 17:34:31 SQL Data In: ORACLE - Param = 5, Name = SCOMMENT, Type = fldZSTRING, Precision = 16, Scale = 0, Data = -CM-000525
9836 17:34:31 SQL Data In: ORACLE - Param = 6, Name = INDATE, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2013/10/15
9837 17:34:31 SQL Data In: ORACLE - Param = 7, Name = INTIME, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:32:31
9838 17:34:31 SQL Data In: ORACLE - Param = 8, Name = BLK_CNT, Type = fldFLOAT, Precision = 4, Scale = 0, Data = 0.000000
9839 17:34:31 SQL Data In: ORACLE - Param = 9, Name = LOCK_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 1.000000
9840 17:34:31 SQL Data In: ORACLE - Param = 10, Name = USER_ID, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NLB-0042
9841 17:34:31 SQL Data In: ORACLE - Param = 11, Name = LIB_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 1.000000
9842 17:34:31 SQL Data In: ORACLE - Param = 12, Name = TUNING_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 0.000000
9843 17:34:31 SQL Data In: ORACLE - Param = 13, Name = ROWID, Type = fldZSTRING, Precision = 18, Scale = 0, Data = AAAHefAAPAAABfaAAK
9844 17:34:31 SQL Execute: ORACLE - UPDATE "TEST_HEAD" SET "INTIME"=:1 WHERE "TEST_ID"=:2 AND "TT_NAME"=:3 AND "PRN_NAME"=:4 AND "SCOMMENT"=:5 AND "INDATE"=:6 AND "INTIME"=:7 AND "BLK_CNT"=:8 AND "LOCK_FLAG"=:9 AND "USER_ID"=:10 AND "TEST_LIB_ID" IS NULL AND "ACCS_DATE" IS NULL AND "ACCS_TIME" IS NULL AND "LIB_FLAG"=:11 AND "TUNING_FLAG"=:12 AND "ROWID"=:13
9845 17:34:31 SQL Data In: ORACLE - Rows affected = 1
9846 17:34:31 SQL Stmt: ORACLE - Close
>>>2.에러 일때는
184407 19:49:36 SQL Prepare: ORACLE - UPDATE "TEST_HEAD" SET "INTIME"=:1 WHERE "TEST_ID"=:2 AND "TT_NAME"=:3 AND "PRN_NAME"=:4 AND "SCOMMENT"=:5 AND "INDATE"=:6 AND "INTIME"=:7 AND "BLK_CNT"=:8 AND "LOCK_FLAG"=:9 AND "USER_ID"=:10 AND "TEST_LIB_ID" IS NULL AND "ACCS_DATE" IS NULL AND "ACCS_TIME" IS NULL AND "LIB_FLAG"=:11 AND "TUNING_FLAG"=:12 AND "ROWID"=:13
184408 19:49:36 SQL Data In: ORACLE - Param = 1, Name = INTIME, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19:49:36
184409 19:49:36 SQL Data In: ORACLE - Param = 2, Name = TEST_ID, Type = fldFLOAT, Precision = 4, Scale = 0, Data = 11.000000
184410 19:49:36 SQL Data In: ORACLE - Param = 3, Name = TT_NAME, Type = fldZSTRING, Precision = 16, Scale = 0, Data = ABS-2004 m0 12
184411 19:49:36 SQL Data In: ORACLE - Param = 4, Name = PRN_NAME, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 079461-2007
184412 19:49:36 SQL Data In: ORACLE - Param = 5, Name = SCOMMENT, Type = fldZSTRING, Precision = 16, Scale = 0, Data = -CM-000525
184413 19:49:36 SQL Data In: ORACLE - Param = 6, Name = INDATE, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2013/10/15
184414 19:49:36 SQL Data In: ORACLE - Param = 7, Name = INTIME, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19:49:30
184415 19:49:36 SQL Data In: ORACLE - Param = 8, Name = BLK_CNT, Type = fldFLOAT, Precision = 4, Scale = 0, Data = 0.000000
184416 19:49:36 SQL Data In: ORACLE - Param = 9, Name = LOCK_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 1.000000
184417 19:49:36 SQL Data In: ORACLE - Param = 10, Name = USER_ID, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NLB-0042
184418 19:49:36 SQL Data In: ORACLE - Param = 11, Name = LIB_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 1.000000
184419 19:49:36 SQL Data In: ORACLE - Param = 12, Name = TUNING_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 0.000000
184420 19:49:36 SQL Data In: ORACLE - Param = 13, Name = ROWID, Type = fldZSTRING, Precision = 18, Scale = 0, Data = AAAHefAAPAAABfaAAK
184421 19:49:36 SQL Execute: ORACLE - UPDATE "TEST_HEAD" SET "INTIME"=:1 WHERE "TEST_ID"=:2 AND "TT_NAME"=:3 AND "PRN_NAME"=:4 AND "SCOMMENT"=:5 AND "INDATE"=:6 AND "INTIME"=:7 AND "BLK_CNT"=:8 AND "LOCK_FLAG"=:9 AND "USER_ID"=:10 AND "TEST_LIB_ID" IS NULL AND "ACCS_DATE" IS NULL AND "ACCS_TIME" IS NULL AND "LIB_FLAG"=:11 AND "TUNING_FLAG"=:12 AND "ROWID"=:13
184422 19:49:36 SQL Data In: ORACLE - Rows affected = 0
184423 19:49:36 SQL Stmt: ORACLE - Close
|