You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

.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表结构截图:
Oracle表结构截图

已尝试借助ChatGPT等工具调试,但仍未找到问题所在,恳请各位提供帮助。


内容的提问来源于stack exchange,提问作者Syed Raza Abbas SRA

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.07.03 23:12:50