请问一下各位大佬,我用执行SQL命令测试插入数据,一直显示ORA-00911: 无效字符\noffset 298是什么原因呢?
同样的SQL在客户端测试过,是可以插入数据的
17:05 执行'测试-业务数据查询(开始)'命令, 请求方式:测试, 用户:Administrator
设置变量命令 : 开始时间 用时:29毫秒。
创建变量 开始时间 = 2024-03-26 00:00:00
设置变量命令 : 结束时间 用时:0毫秒。
创建变量 结束时间 = 2024-03-26 23:59:59
发送HTTP请求命令 用时:6695毫秒。
POST内容:beginTime=2024-03-26+00%3A00%3A00&endTime=2024-03-26+23%3A59%3A59
StatusCode: 200, ReasonPhrase: 'OK', Version: 1.1, Content: System.Net.Http.HttpConnectionResponseContent, Headers: { Date: Tue, 09 Apr 2024 09:05:39 GMT Set-Cookie: pjd=zzzd_192.168.1.28; Secure Connection: Keep-alive Via: 1.1 ID-5301755310536770 uproxy-7 Content-Length: 608332 Content-Type: application/json;charset=UTF-8 }
创建变量 re = [{"USERIDTU_AES":"Js/gZFaU3Xp5grwT9+cITKMTYuZG3Bdv1MYi0jngvxs=","EQUIPMENTID":"SZSI10900","BUSINESSCODE":"GRQ016","FUN_CODE":"OutpatientMasonic","BUS_SERIALNUMBER":"2024032600063771706901","END_DATE":"2024-03-26 00:09:03","START_DATE":"2024-03-26 00:09:03","CN":1,"RN":1,"RECORDID":"2024032600090395109401"},{"USERIDTU_AES":"K8BlJxMKi4PBS8TPERrDbcWzWbseK1YhuYRSKjCTPpg=","EQUIPMENTID":"SZSI10107","BUSINESSCODE":"MTLogin","FUN_CODE":"CX_GeRenQingD","BUS_SERIALNUMBER":"2024032600395733701601","END_DATE":"2024-03-26 00:42:23","START_DATE":"2024-03-26 00:42:23","CN":1,"RN":1,"RECORDID":"2024032600422307308201"},{"USERIDTU_AES":"DjuSylKR4DZxUf4ciW6q07kCqKlR0vZW28+2ic2c8vw=","EQUIPMENTID":"SZSI10640","BUSINESSCODE":"MTLogin","FUN_CODE":"JiaTingBangD","BUS_SERIALNUMBER":"2024032602044523008801","END_DATE":"2024-03-26 02:07:11","START_DATE":"2024-03-26 02:07:11","CN":1,"RN":1,"RECORDID":"2024032602071111109601"},{"USERIDTU_AES":"XnoQ1z/uXd6PKQdr/EaVMkUFXo8uD6bcXAR6hzVfpJE=","EQUIPMENTID...
JSON反序列化 用时:9毫秒。
创建变量 DDD = [{"USERIDTU_AES":"Js/gZFaU3Xp5grwT9+cITKMTYuZG3Bdv1MYi0jngvxs=","EQUIPMENTID":"SZSI10900","BUSINESSCODE":"GRQ016","FUN_CODE":"OutpatientMasonic","BUS_SERIALNUMBER":"2024032600063771706901","END_DATE":"2024-03-26 00:09:03","START_DATE":"2024-03-26 00:09:03","CN":1,"RN":1,"RECORDID":"2024032600090395109401"},{"USERIDTU_AES":"K8BlJxMKi4PBS8TPERrDbcWzWbseK1YhuYRSKjCTPpg=","EQUIPMENTID":"SZSI10107","BUSINESSCODE":"MTLogin","FUN_CODE":"CX_GeRenQingD","BUS_SERIALNUMBER":"2024032600395733701601","END_DATE":"2024-03-26 00:42:23","START_DATE":"2024-03-26 00:42:23","CN":1,"RN":1,"RECORDID":"2024032600422307308201"},{"USERIDTU_AES":"DjuSylKR4DZxUf4ciW6q07kCqKlR0vZW28+2ic2c8vw=","EQUIPMENTID":"SZSI10640","BUSINESSCODE":"MTLogin","FUN_CODE":"JiaTingBangD","BUS_SERIALNUMBER":"2024032602044523008801","END_DATE":"2024-03-26 02:07:11","START_DATE":"2024-03-26 02:07:11","CN":1,"RN":1,"RECORDID":"2024032602071111109601"},{"USERIDTU_AES":"XnoQ1z/uXd6PKQdr/EaVMkUFXo8uD6bcXAR6hzVfpJE=","EQUIPMENTI...
事务命令 用时:4毫秒。
循环命令 用时:2毫秒。
创建变量 Item = {"USERIDTU_AES":"Js/gZFaU3Xp5grwT9+cITKMTYuZG3Bdv1MYi0jngvxs=","EQUIPMENTID":"SZSI10900","BUSINESSCODE":"GRQ016","FUN_CODE":"OutpatientMasonic","BUS_SERIALNUMBER":"2024032600063771706901","END_DATE":"2024-03-26 00:09:03","START_DATE":"2024-03-26 00:09:03","CN":1,"RN":1,"RECORDID":"2024032600090395109401"}
执行SQL命令 用时:2毫秒。
SQL语句: INSERT INTO ZZY_TURECORD_FAILURE
(USERIDTU_AES,
EQUIPMENTID,
BUSINESSCODE,
FUN_CODE,
BUS_SERIALNUMBER,
START_DATE,
END_DATE,
CN,
RN,
ID)
VALUES
(:USERIDTU_AES,
:EQUIPMENTID,
:BUSINESSCODE,
:FUN_CODE,
:BUS_SERIALNUMBER,
:START_DATE,
:END_DATE,
:CN,
:RN,
:ID);
发生错误,回滚事务
错误码: 500
信息: ORA-00911: 无效字符\noffset 298
'测试-业务数据查询(开始)'命令执行结束, 用时:6756毫秒。
|