3 Replies Latest reply on Aug 22, 2013 6:50 AM by robbart

    ColdFusion 10 - With oracle ojdbc6 jar

    Deepak Paudyal

      Recently we had to add ojdbc6.jar to our CF10 lib folder since the Oracle drivers

      (version 8) shipped with CF10 did not meet STIG requirements.  We have run into

      an issue where we get "PLS-00306: wrong number or types of arguments in call

      to..." to all of our procedure calls now.  Had anyone experienced this when using

      Oracle drivers other than the ones shipped with CF10?

       

       

      Errr Detail:

       

      ErrorCode 6550
      Message ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'GENERATE_PTDSCHED' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
      SQLState 65000
      StackTrace java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'GENERATE_PTDSCHED' ORA-06550: line 1, column 7: PL/SQL: Statement ignored  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204)  at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1041)  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3 584)  at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3685)  at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4714)  at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper. java:1376)  at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)  at coldfusion.sql.Executive.executeCall(Executive.java:1053) at coldfusion.sql.Executive.executeCall(Executive.java:926) at coldfusion.sql.Executive.executeCall(Executive.java:876) at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:528) at coldfusion.tagext.sql.StoredProcTag.executeQuery(StoredProcTag.java:324) at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:272) at cfptdlsiReport2ecfc1934227327$funcPTDLSIREPORTSCHEDULEGRAPHDISPLAY._factor38(E:\websites\ coldfusn\merlin\services\statusTracking\ptdlsiReport.cfc:2871)  at cfptdlsiReport2ecfc1934227327$funcPTDLSIREPORTSCHEDULEGRAPHDISPLAY.runFunction(E:\website s\coldfusn\merlin\services\statusTracking\ptdlsiReport.cfc:2854)  at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)  at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)  at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2432) at cfstatusTracking2ecfc164289739$funcPTDLSIREPORTSCHEDULEGRAPHDISPLAY.runFunction(E:\websit es\coldfusn\merlin\services\statusTracking.cfc:1232)  at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)  at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)  at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:660) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:469) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2373) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:402) at cfframework2ecfc958667493$funcDOSERVICE.runFunction(E:\websites\coldfusn\merlin\org\corfi eld\framework.cfc:1324)  at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)  at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)  at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2659) at cfframework2ecfc958667493$funcONREQUEST.runFunction(E:\websites\coldfusn\merlin\org\corfi eld\framework.cfc:521)  at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)  at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)  at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:300) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:418) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:112) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:2 8)  at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j ava:305)  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)   at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42 )  at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j ava:243)  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)  at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928)  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414)  at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:204) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.jav a:539)  at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298)  at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)  at java.lang.Thread.run(Thread.java:662)
        • 1. Re: ColdFusion 10 - With oracle ojdbc6 jar
          Peter 456

          Try adding this to your jvm arguments

          -Doracle.jdbc.J2EE13Compliant=true

           

          • 3. Re: ColdFusion 10 - With oracle ojdbc6 jar
            robbart

            For those finding this in the future... and looking for assistance with ColdFusion, Oracle and the Oracle drivers Oracle provides...

             

            The Datadirect drivers that are included with ColdFusion Enterprise allow Oracle database use (CF Standard does not have drivers included for Oracle access, you need to provide your own 3rd party drivers), and allow for use of Reference Cursors.  Included with ColdFusion Enterprise are DataDirect drivers that are the ONLY way to get ColdFusion to allow use of Reference Cursors for result sets.

             

            The ThinClient driver provided by Oracle DOES NOT allow use of Reference Cursors.

             

            If you need to use the Oracle ThinClient drivers for ANY REASON, you can't use Reference Cursors.

             

            From Adobe:

             

            http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7f 95.html

             

            "CFML supports Oracle 8 and 9 Reference Cursor type, which passes a parameter by reference. Parameters that are passed this way can be allocated and deallocated from memory within the execution of one application. To use reference cursors in packages or stored procedures, use the cfprocresult tag. This causes the ColdFusion JDBC database driver to put Oracle reference cursors into a result set. (You cannot use this method with Oracle’s ThinClient JDBC drivers.)"

             

            The DataDirect drivers shipped with ColdFusion (up to 10) are v4.01 SP1.  The latest drivers (as of this posting) available from Progress are 5.1.1.  Not sure if they resolve the issue yet, but they should.  They cost money however.   You can find out more here: http://www.datadirect.com/products/jdbc/index.html

            1 person found this helpful