I usually see that when returning a cursor that has no records, my workaround was to initialize an empty cursor in the called procedure, ie:
open P_RETURN_CURSOR for select ' ' as RESPONSE from dual; -chris On Monday, February 18, 2013 4:43:00 AM UTC-8, Manuel Reimer wrote: > > Hello, > > I want to replace Coldfusion with OpenBD. My first try to use OpenBD to > run an existing application results in database problems. See the > following exception message: > > java.lang.NullPointerException > at oracle.jdbc.driver.T4C8Oall.getNumRows(T4C8Oall.java:876) > at > oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:975) > > > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190) > > > at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370) > > > at > oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3476) > > > at > oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4400) > > > at com.naryx.tagfusion.cfm.sql.cfSTOREDPROC.render(Unknown Source) > at com.naryx.tagfusion.cfm.tag.cfTag.coreRender(Unknown Source) > at com.naryx.tagfusion.cfm.tag.cfTag.render(Unknown Source) > at com.naryx.tagfusion.cfm.file.cfFile.render(Unknown Source) > at com.naryx.tagfusion.cfm.engine.cfSession.onRequest(Unknown > Source) > at com.naryx.tagfusion.cfm.engine.cfEngine.service(Unknown Source) > at com.naryx.tagfusion.cfm.cfServlet.service(Unknown Source) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) > > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) > > > at > com.newatlanta.filters.SearchEngineFriendlyURLFilter.doFilter(Unknown > Source) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) > > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) > > > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) > > > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) > > > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) > > > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) > > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) > > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) > > > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) > > at > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004) > > > at > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) > > > at > org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312) > > > at > java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) > > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) > > > at java.lang.Thread.run(Thread.java:662) > > > Can someone please help me with this problem? > > Mit freundlichen Grￜￜen / Best regards > > Manuel Reimer > -- -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en --- You received this message because you are subscribed to the Google Groups "Open BlueDragon" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
