call procedure error

Carlos Carvalho

Summary

call procedure error

Content

Hello,

I am using bip (12.2.1.3.0  (build:20170720.0424) ), and i am in the step after , so i am trying to put an anonymous pl/sql block in a data set:

but i am getting error:

and in logs i have:

[171011_01100010][DATA PROCESSOR ID:682305724][SCH JOB INFO:]XMLPGEN:processNSQuery.procedure[171011_01100010][DATA PROCESSOR ID:682305724][SCH JOB INFO:]JDBC Driver:Oracle JDBC driver:weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection:12.2.0.1.0[171011_01100010][DATA PROCESSOR ID:682305724][SCH JOB INFO:]DBName:Oracle ,DBVersion:Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production[171011_01100010][DATA PROCESSOR ID:682305724][SCH JOB INFO:]IfElseQuery:parseQuery..[171011_01100010][DATA PROCESSOR ID:682305724][SCH JOB INFO:]NSQueryStatement:execute..[171011_01100010][DATA PROCESSOR ID:682305724][SCH JOB INFO:]Procedure:execute..[171011_01100010][DATA PROCESSOR ID:682305724][SCH JOB INFO:]Bind Variables ...[171011_01100010][DATA PROCESSOR ID:682305724][SCH JOB INFO:]    1: XDO_CURSOR:null[171011_01100010][DATA PROCESSOR ID:682305724][SCH JOB INFO:]Execute Procedure:beginnull;end;/[171011_01100010][DATA PROCESSOR ID:682305724][SCH JOB INFO:]oracle.xdo.dataengine.datasource.plugin.DataAccessException: java.sql.SQLException: Invalid column indexat oracle.xdo.dataengine.datasource.plugin.sql.Procedure.execute(Procedure.java:69)at oracle.xdo.dataengine.datasource.NSQueryStatement.execute(NSQueryStatement.java:81)at oracle.xdo.dataengine.XMLPGEN.processNSQuery(XMLPGEN.java:2776)at oracle.xdo.dataengine.XMLPGEN.processMergedDataSet(XMLPGEN.java:1858)at oracle.xdo.dataengine.DataProcessor.processData(DataProcessor.java:385)at oracle.xdo.servlet.dataengine.DataProcessorImpl.processData(DataProcessorImpl.java:310)at oracle.xdo.servlet.dataengine.DataProcessorImpl.render(DataProcessorImpl.java:687)at oracle.xdo.servlet.ReportModelContextImpl.getReportXMLData(ReportModelContextImpl.java:355)at oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:520)at oracle.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:108)at oracle.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:1430)at oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:906)at oracle.xdo.servlet.resources.ReportItemServiceImpl.runSynch(ReportItemServiceImpl.java:217)at oracle.xdo.servlet.resources.ReportItemServiceImpl.run(ReportItemServiceImpl.java:199)at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:554)at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:522)at oracle.xdo.servlet.XDOServlet.doGet(XDOServlet.java:298)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:286)at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:350)at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)at oracle.xdo.servlet.metadata.track.MostRecentFilter.doFilter(MostRecentFilter.java:74)at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)at oracle.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:237)at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)at oracle.bi.security.filter.BISecurityFilter.handleAnonymousSubject(BISecurityFilter.java:189)at oracle.bi.security.filter.BISecurityFilter.doFilter(BISecurityFilter.java:160)at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)at oracle.xdo.servlet.init.InitCheckingFilter.doFilter(InitCheckingFilter.java:63)at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)at oracle.security.jps.ee.http.JpsAbsFilter$3.run(JpsAbsFilter.java:172)at java.security.AccessController.doPrivileged(Native Method)at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:650)at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:110)at oracle.security.jps.ee.http.JpsAbsFilter.doFilterInternal(JpsAbsFilter.java:273)at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:147)at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94)at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:248)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:3701)at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3667)at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:326)at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2443)at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2291)at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2269)at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1703)at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1663)at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:272)at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:644)at weblogic.work.ExecuteThread.execute(ExecuteThread.java:415)at weblogic.work.ExecuteThread.run(ExecuteThread.java:355)Caused by: java.sql.SQLException: Invalid column indexat oracle.jdbc.driver.OracleCallableStatement.registerOutParameterInternal(OracleCallableStatement.java:135)at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:325)at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:517)at oracle.jdbc.driver.OracleCallableStatementWrapper.registerOutParameter(OracleCallableStatementWrapper.java:1232)at weblogic.jdbc.wrapper.CallableStatement_oracle_jdbc_driver_OracleCallableStatementWrapper.registerOutParameter(Unknown Source)at oracle.xdo.dataengine.datasource.plugin.sql.Procedure.execute(Procedure.java:60)... 65 more

and the error is about the procedure.

If i remove that data set, the other data set containing the select sql retrieves the data well.

According to the documentation ( https://docs.oracle.com/middleware/1221/bip/BIPDM/create_data_sets.htm#BIPDM482  ) i should be able to do it, right?

how can i fix this please?

Thanks

Carlos