找回密码
 立即注册

QQ登录

只需一步,快速开始

晓谐升 活字格认证 Wyn认证
金牌服务用户   /  发表于:2024-4-9 17:10  /   查看:1283  /  回复:3
10金币
请问一下各位大佬,我用执行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毫秒。


最佳答案

查看完整内容

您好,试一下去掉sql语句后的这个分号看看行不行呢

3 个回复

正序浏览
Lay.Li悬赏达人认证 活字格认证
超级版主   /  发表于:2024-4-9 18:14:24
4#
问题解决了就好,后边有问题欢迎您继续发帖交流
回复 使用道具 举报
晓谐升活字格认证 Wyn认证
金牌服务用户   /  发表于:2024-4-9 17:54:20
3#
Lay.Li 发表于 2024-4-9 17:30
您好,试一下去掉sql语句后的这个分号看看行不行呢

可以了,还是大佬厉害
回复 使用道具 举报
最佳答案
最佳答案
Lay.Li悬赏达人认证 活字格认证
超级版主   /  发表于:2024-4-9 17:10:43
来自 2#

您好,试一下去掉sql语句后的这个分号看看行不行呢

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复 使用道具 举报
您需要登录后才可以回帖 登录 | 立即注册
返回顶部