字符串拼接

最多能拼接多少字符串

在哪里拼接

做关联的时候，报这个错[img]b16f7cd9-a139-4212-b2b9-a939cca65fa5[/img]

[i=s] 本帖最后由 zf001213 于 2025-7-28 11:06 编辑 [/i]

能截图上传吗？我这里只能看到图片代码

报这个错

错误代码:110099999
数据集: '未命名-40'   执行用户: 'zhengfan'
原因: java.lang.Exception: 数据集: '未命名-40'   执行用户: 'zhengfan'
原因: ORA-22813: 操作数值超出系统的限制
g5.util.RTWrappedException: java.lang.Exception: 数据集: '未命名-40'   执行用户: 'zhengfan'
原因: ORA-22813: 操作数值超出系统的限制
        at g5.grid.impl.AbstractColumn.exists(AbstractColumn.java:476)
        at g5.grid.DefWrapQGrid.exists(DefWrapQGrid.java:66)
        at g5.grid.DefWrapGrid.exists(DefWrapGrid.java:100)
        at g5.grid.DefWrapGrid.exists(DefWrapGrid.java:100)
        at g5.grid.DefWrapGrid.exists(DefWrapGrid.java:100)
        at g5.grid.JoinGrid.isBigLeft(JoinGrid.java:154)
        at g5.grid.join.SJGrid.createGrid(SJGrid.java:46)
        at g5.grid.JoinGrid.create(JoinGrid.java:182)
        at g5.qry.comp.AbsJoinHandler.join0(AbsJoinHandler.java:364)
        at g5.qry.comp.AbsJoinHandler.join(AbsJoinHandler.java:147)
        at g5.gqry.comp.executor.JoinExecutor.getBaseGrid(JoinExecutor.java:136)
        at g5.gqry.comp.RTCompQuery.getBaseGridQuery(RTCompQuery.java:895)
        at g5.gqry.comp.RTCompQuery.getGrid0(RTCompQuery.java:847)
        at g5.gqry.comp.RTCompQuery.executeGrid(RTCompQuery.java:1006)
        at g5.gqry.comp.RTCompQuery.getGrid(RTCompQuery.java:976)
        at g5.gqry.comp.CompGQuery.getPreGrid1(CompGQuery.java:345)
        at g5.gqry.GQuery.getPreGrid0(GQuery.java:1777)
        at g5.gqry.GQuery.getPreGrid(GQuery.java:1995)
        at g5.gqry.GQuery.getPreMaxRowGrid(GQuery.java:1884)
        at g5.gqry.GQuery.getGrid0(GQuery.java:1538)
        at g5.gqry.GQuery.getGrid(GQuery.java:1479)
        at g5.sv.qry.req.PreviewQryReq.process0(PreviewQryReq.java:247)
        at g5.sv.Req.process(Req.java:58)
        at g5.sv.qry.impl.QueryServiceImpl.process(QueryServiceImpl.java:292)
        at g5.sv.qry.QueryProc.procReq(QueryProc.java:163)
        at g5.sv.qry.QueryProc.service(QueryProc.java:64)
        at g5.sv.ServletHelper.service(ServletHelper.java:133)
        at g5.sv.PortalServlet.service(PortalServlet.java:1715)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:396)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
        at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
        at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
        at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.lang.Exception: 数据集: '未命名-40'   执行用户: 'zhengfan'
原因: ORA-22813: 操作数值超出系统的限制
        at g5.thread.ThreadUtil.getExceptionWarningEx(ThreadUtil.java:177)
        at g5.qry.queryPool.QueryRunnable.run(QueryRunnable.java:92)
        at g5.thread.ThreadPoolWithChecker$GThread.run0(ThreadPoolWithChecker.java:284)
        at g5.thread.AbsThreadPool$PThread.run(AbsThreadPool.java:562)

你SQL怎么写的？

组合数据集，两表ID关联

你是用永洪的表关联的话，字符串拼接我不太清楚，把关联代码复制出来放到SQL数据集用CONCAT写个字符串连接呢？

这个报错的具体原因是什么，您能看出来吗

两个问题，这个只做了id关联报错，想知道原因

数据库报错，这个错误通常发生在尝试处理的数据值超出了Oracle系统定义的限制范围时，你数据有多大？

两个都只有几千行

数据有没有长的字符串，超过了字段类型的最大长度限制