.Net项目向Oracle插入数据时遇ORA-00917缺失逗号错误求助
.Net项目向Oracle插入数据时遇ORA-00917: missing comma错误排查求助
在.Net项目中执行向Oracle表插入数据的SQL语句时,触发ORA-00917: missing comma错误,拼接的INSERT语句如下:
var commandTextgpt = $"INSERT INTO tl_order " + $"(ORDER_ID, ORDER_DATE, ORDER_GROSS_AMOUNT, ORDER_NUMBER, ORDER_DESCRIPTION, ORDER_TYPE_LKP_ID, REQUIRED_BY_DATE, CUSTOMER_MASTER_ID, " + $"DISCOUNT_AMOUNT, ORDER_NET_AMOUNT, TAX_AMOUNT, USER_ID, EMAIL_ADDRESS, PAYMENT_TERMS, LOCATION_ID, CUSTOMER_SIGNATURE_IMAGE_URL, ACTIVE_FLAG, " + $"PAYMENT_METHOD, MOBILE_ORDER_ID, TMX_STATUS, DST_STATUS, CUSTOMER_MASTER_CODE, LOCATION_CODE, ITRANSACTION_NUM) " + $"VALUES (" + $"{orderDatafromDynastyTables.Rows[0]["ORDER_ID"]}, " + $"{orderDatafromDynastyTables.Rows[0]["ORDER_DATE"]}, " + $"{orderDatafromDynastyTables.Rows[0]["ORDER_GROSS_AMOUNT"]}, " + $"{orderDatafromDynastyTables.Rows[0]["ORDER_NUMBER"]}, " + $"{orderDatafromDynastyTables.Rows[0]["ORDER_DESCRIPTION"]}, " + $"NULL, " + $"{orderDatafromDynastyTables.Rows[0]["REQUIRED_BY_DATE"]}, " + $"{orderDatafromDynastyTables.Rows[0]["CUSTOMER_MASTER_ID"]}, " + $"{orderDatafromDynastyTables.Rows[0]["DISCOUNT_AMOUNT"]}, " + $"{orderDatafromDynastyTables.Rows[0]["ORDER_NET_AMOUNT"]}, " + $"{orderDatafromDynastyTables.Rows[0]["TAX_AMOUNT"]}, " + $"{orderDatafromDynastyTables.Rows[0]["USER_ID"]}, " + $"{orderDatafromDynastyTables.Rows[0]["EMAIL_ADDRESS"]}, " + $"NULL, " + $"NULL, " + $"NULL, " + $"{orderDatafromDynastyTables.Rows[0]["ACTIVE_FLAG"]}, " + $"{orderDatafromDynastyTables.Rows[0]["PAYMENT_METHOD"]}, " + $"NULL, " + $"{orderDatafromDynastyTables.Rows[0]["TMX_STATUS"]}, " + $"{orderDatafromDynastyTables.Rows[0]["DST_STATUS"]}, " + $"NULL, " + $"NULL, " + $"NULL)";
其中orderDatafromDynastyTables是从MSSQL数据库获取数据的DataTable对象,定义如下:
var orderDatafromDynastyTables = FetchSQLQueryForDyastyData(sqlQuery, orderId, ordDate, ordShipDate, customerCode);
该DataTable中的数据如下:
ORDER_ID: 65121 ORDER_DATE: 2013-12-14 09:18:52.000 ORDER_GROSS_AMOUNT: 1023.6200 ORDER_NUMBER: ORD011805065121 ORDER_DESCRIPTION: NESTLE ORDER_TYPE_LKP_ID: NULL REQUIRED_BY_DATE: 2013-12-14 09:18:52.000 CUSTOMER_MASTER_ID: 100008 DISCOUNT_AMOUNT: 0.0000 ORDER_NET_AMOUNT: 1023.6200 TAX_AMOUNT: 0.0000 USER_ID: 103.53.46.250 EMAIL_ADDRESS: NULL PAYMENT_TERMS: NULL LOCATION_ID: NULL CUSTOMER_SIGNATURE_IMAGE_URL: NULL ACTIVE_FLAG: 1 PAYMENT_METHOD: Payments.CashOnDelivery MOBILE_ORDER_ID: NULL TMX_STATUS: READY DST_STATUS: READY CUSTOMER_MASTER_CODE: NULL LOCATION_CODE: NULL ITRANSACTION_NUM: NULL
Oracle表结构截图:
已尝试借助ChatGPT等工具调试,但仍未找到问题所在,恳请各位提供帮助。
内容的提问来源于stack exchange,提问作者Syed Raza Abbas SRA
相关产品推荐
相关产品推荐

