java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by deahayes, 1 year ago
ORA-01795: maximum number of expressions in a list is 1000
via Stack Overflow by maximegir
, 2 years ago
ORA-02289: la séquence n'existe pas (non existing sequence)
via Oracle Community by carflores, 1 year ago
via Atlassian JIRA by Der Lun Ooi, 1 year ago
ORA-01795: maximum number of expressions in a list is 1000
via Hibernate JIRA by Martin Šimka, 1 year ago
ORA-00932: inconsistent datatypes: expected - got BLOB
java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:234)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:55)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:829)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1263)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:5010)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:5070)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1677)
at oracle.xdo.dataengine.XMLPGEN.processQuery(XMLPGEN.java:2106)
at oracle.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:552)
at oracle.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:460)
at oracle.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:361)
at oracle.xdo.dataengine.XMLPGEN.writeXMLDataStructure(XMLPGEN.java:294)
at oracle.xdo.dataengine.XMLPGEN.processDataSet(XMLPGEN.java:1996)
at oracle.xdo.dataengine.XMLPGEN.processMergedDataSet(XMLPGEN.java:1602)
at oracle.xdo.dataengine.DataProcessor.processData(DataProcessor.java:379)
at oracle.xdo.servlet.dataengine.DataProcessorImpl.processData(DataProcessorImpl.java:309)
at oracle.xdo.servlet.dataengine.DataProcessorImpl.render(DataProcessorImpl.java:684)
at oracle.xdo.servlet.ReportModelContextImpl.getReportXMLData(ReportModelContextImpl.java:324)
at oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:525)
at oracle.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:113)
at oracle.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:1245)
at oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:722)
at oracle.xdo.servlet.resources.ReportItemServiceImpl.runSynch(ReportItemServiceImpl.java:210)
at oracle.xdo.servlet.resources.ReportItemServiceImpl.run(ReportItemServiceImpl.java:192)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:497)
at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:466)
at oracle.xdo.servlet.XDOServlet.doGet(XDOServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:350)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
at oracle.xdo.servlet.metadata.track.MostRecentFilter.doFilter(MostRecentFilter.java:74)
at oracle.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:186)
at oracle.xdo.servlet.init.InitCheckingFilter.doFilter(InitCheckingFilter.java:63)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:141)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:649)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:124)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:232)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:224)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:32)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3653)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:326)
at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:196)
at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:196)
at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:66)
at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2422)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2279)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2257)
at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1624)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1584)
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:270)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:348)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:610)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:391)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:340)

Users with the same issue

6 times, 1 week ago
7 times, 1 month ago
Once, 4 months ago
Once, 9 months ago
3 times, 11 months ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.