Sorry, I appreciate the help I had a long day of meetings...
toAgent.executeUpdate("insert into EG_VENDOR (VENDOR_NUMBER, CREATION_DATE, INTERFACE_DATE,INTERFACE_STATUS, VENDOR_NAME, VENDOR_TYPE_LOOKUP_CODE, VENDOR_END_DATE_ACTIVE, VENDOR_SITE_ID,VENDOR_SITE_CODE, VENDOR_SITE_END_DATE_ACTIVE, ADDRESS_LINE1, ADDRESS_LINE2, ADDRESS_LINE3, CITY,STATE, ZIP, AREA_CODE, PHONE, FAX_AREA_CODE, FAX_PHONE, VENDOR_CONTACTS, LAST_UPDATED_BY) values ( '"+rs.getString(2) +"', "+TO_DATE('"+ rs.getTimestamp(3) +"', 'DD-MON-YYYY HH24 :MI :SS') +", "+TO_DATE('"+ rs.getTimestamp(4) +"', 'DD-MON-YYYY HH24 :MI :SS') +", '"+ rs.getString(5) +"','"+ rs.getString(6) +"', '"+ rs.getString(7) +"', "+TO_DATE('"+ rs.getTimestamp(8) +"', 'DD-MON-YYYY HH24 :MI :SS') +", "+ rs.getInt(9) +", '"+rs.getString(10) + "', "+TO_DATE('"+ rs.getTimestamp(11) +"', 'DD-MON-YYYY HH24 :MI :SS') +", '"+ rs.getString(12) + "', '"+ rs.getString(13) +"', '"+ rs.getString(14) + "', '"+ rs.getString(15) + "', '"+ rs.getString(16) + "', '"+rs.getString(17) + "', '"+ rs.getString(18) + "', '"+ rs.getString(19) + "', '"+ rs.getString(20) + "','"+ rs.getString(21) + "', '"+ rs.getString(22) + "', '"+ rs.getString(23) + "')");
[ removed the code tag surrounding the big long unbroken line of code -ds ]
[ March 14, 2003: Message edited by: Dirk Schreckmann ]