ORA-24381
Receiving DIAG [S1000] [Oracle][ODBC][Ora]ORA-24381: error(s) in array DML in ODBC Trace after update statement from VB 6.0 application. The same sql executes fine in SQL*Plus with no errors, however, from the vb app, ORA-24381 is thrown and the data does not get updated. Does anyone have a clue what this is and what is causing it?
IMHC97trig b90-564 ENTER SQLSetStmtOption
HSTMT 04343010
UWORD 0 <SQL_QUERY_TIMEOUT>
SQLPOINTER 0x00000000
IMHC97trig b90-564 EXIT SQLSetStmtOption with return code -1 (SQL_ERROR)
HSTMT 04343010
UWORD 0 <SQL_QUERY_TIMEOUT>
SQLPOINTER 0x00000000
DIAG [S1C00] [Oracle][ODBC]Driver not capable. (0)
IMHC97trig b90-c88 ENTER SQLExecDirect
HSTMT 04343010
UCHAR * 0x054B34DC [ 297] "update trbtcontpy a set rbt_stat_code = 'DL', user_last_updated = 'ALLENMI1', date_last_updated = TO_DATE('2005-01-12','YYYY-MM-DD') where a.grp_nmbr = '10004' and a.cont_seq_num = 009 and exists (select * from tnrbtpynum b where rbt_pay_period = '2004Q3' and a.rbt_pay_num = b.rbt_pay_num)"
SDWORD 297
IMHC97trig b90-564 ENTER SQLCancel
HSTMT 04343010
IMHC97trig b90-564 EXIT SQLCancel with return code 0 (SQL_SUCCESS)
HSTMT 04343010
IMHC97trig b90-c88 EXIT SQLExecDirect with return code 1 (SQL_SUCCESS_WITH_INFO)
HSTMT 04343010
UCHAR * 0x054B34DC [ 297] "update trbtcontpy a set rbt_stat_code = 'DL', user_last_updated = 'ALLENMI1', date_last_updated = TO_DATE('2005-01-12','YYYY-MM-DD') where a.grp_nmbr = '10004' and a.cont_seq_num = 009 and exists (select * from tnrbtpynum b where rbt_pay_period = '2004Q3' and a.rbt_pay_num = b.rbt_pay_num)"
SDWORD 297
DIAG [S1000] [Oracle][ODBC][Ora]ORA-24381: error(s) in array DML
(24381)
IMHC97trig b90-c88 ENTER SQLErrorW
HENV 043412A0
HDBC 00000000
HSTMT 04343010
WCHAR * 0x09DAFCB0 (NYI)
SDWORD * 0x09DAFF58
WCHAR * 0x09DAF8B0
SWORD 511
SWORD * 0x09DAFF3A
IMHC97trig b90-c88 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 043412A0
HDBC 00000000
HSTMT 04343010
WCHAR * 0x09DAFCB0 (NYI)
SDWORD * 0x09DAFF58 (24381)
WCHAR * 0x09DAF8B0 [ 52] "[Oracle][ODBC][Ora]ORA-243"
SWORD 511
SWORD * 0x09DAFF3A (52)
IMHC97trig b90-c88 ENTER SQLErrorW
HENV 043412A0
HDBC 00000000
HSTMT 04343010
WCHAR * 0x09DAFCB0 (NYI)
SDWORD * 0x09DAFF58
WCHAR * 0x09DAF8B0
SWORD 511
SWORD * 0x09DAFF3A
IMHC97trig b90-c88 EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 043412A0
HDBC 00000000
HSTMT 04343010
WCHAR * 0x09DAFCB0 (NYI)
SDWORD * 0x09DAFF58
WCHAR * 0x09DAF8B0
SWORD 511
SWORD * 0x09DAFF3A
IMHC97trig b90-c88 ENTER SQLRowCount
HSTMT 04343010
SQLLEN * 0x054B3474
IMHC97trig b90-c88 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 04343010
SQLLEN * 0x054B3474 (0)
IMHC97trig b90-c88 ENTER SQLMoreResults
HSTMT 04343010
IMHC97trig b90-c88 EXIT SQLMoreResults with return code 100 (SQL_NO_DATA_FOUND)
HSTMT 04343010
IMHC97trig b90-c88 ENTER SQLErrorW
HENV 043412A0
HDBC 00000000
HSTMT 04343010
WCHAR * 0x09DAFCB0 (NYI)
SDWORD * 0x09DAFF58
WCHAR * 0x09DAF8B0
SWORD 511
SWORD * 0x09DAFF3A
IMHC97trig b90-c88 EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 043412A0
HDBC 00000000
HSTMT 04343010
WCHAR * 0x09DAFCB0 (NYI)
SDWORD * 0x09DAFF58
WCHAR * 0x09DAF8B0
SWORD 511
SWORD * 0x09DAFF3A