6 Replies Latest reply: Feb 16, 2010 1:05 PM by 754173 RSS

    ORA-06553: PLS-306: wrong number or types of arguments in call to 'EDN_DEQU

    738246
      Hi,

      I have installed Oracle fusion 11g on windows vista SP1 system. I have followed all the steps provided in the Oracle fusion installation guide.

      After installation when i tried to start the SOA server i'm continously getting the below warning message in the log file.

      [2009-11-27T03:18:23.203+05:30] [soa_server1] [WARNING] [SOA-31013] [oracle.integration.platform.blocks.event.saq] [tid: oracle.integration.platform.blocks.executor.WorkManagerExecutor$1@291d84] [userId: <anonymous>] [ecid: 0000IKmTpBfB5Ewr0CyWMF1B3jQf00000B,0] [APP: soa-infra] Error handling message (rolling back).[[
      java.sql.SQLException: ORA-06553: PLS-306: wrong number or types of arguments in call to 'EDN_DEQUEUE_OAOO_DELIVERY'

           at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
           at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
           at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
           at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)
           at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1223)
           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3386)
           at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3487)
           at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3858)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
           at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:98)
           at oracle.integration.platform.blocks.event.saq.SAQBusinessEventBus.readOAOODelivery(SAQBusinessEventBus.java:1222)
           at oracle.integration.platform.blocks.event.saq.SAQBusinessEventBus.handleSingleOAOODelivery(SAQBusinessEventBus.java:690)
           at oracle.integration.platform.blocks.event.saq.SAQBusinessEventBus.handleQueueEvents(SAQBusinessEventBus.java:614)
           at oracle.integration.platform.blocks.event.saq.SAQBusinessEventBus.access$000(SAQBusinessEventBus.java:76)
           at oracle.integration.platform.blocks.event.saq.SAQBusinessEventBus$1.run(SAQBusinessEventBus.java:279)
           at oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:77)
           at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:171)
           at java.lang.Thread.run(Thread.java:619)

      I have restarted everything and tried again which resulted in the same scenario.

      Anyone,Please help me to troubleshoot this and walk me through this issue.Thanks in advance!.
        • 2. Re: ORA-06553: PLS-306: wrong number or types of arguments in call to 'EDN_DEQU
          738246
          Hi,

          Thanx 4 ur reply.

          Previously i have checked the link provided by you which ended stating that this issue got resolved after upgrading to new version.

          -- I have recently downloaded the latest version available on the oracle site and that's the reason why i thought that the thread provided would not be much helpful.

          Is this an issue that is related to version?

          Is there in any other fix for this issue without changing the existing environment?

          Thanks,
          K@rtheek.
          • 3. Re: ORA-06553: PLS-306: wrong number or types of arguments in call to 'EDN_DEQU
            738246
            Bringing it to the top.

            Could any one of you have an update or resolution for this.I'm unable to work with this Fusion environement as the log file size is getting increased with 9mb for every 2 min when the SOA server is up.

            Please assist as how i might get rid of this error. Any help would be greatly appreciated!
            • 4. Re: ORA-06553: PLS-306: wrong number or types of arguments in call to 'EDN_DEQU
              sb92075
              Please assist as how i might get rid of this eriror.
              submit a Service Request via http://metalink.oracle.com
              • 5. Re: ORA-06553: PLS-306: wrong number or types of arguments in call to 'EDN_DEQU
                717725
                Hi to all,

                I have the same problem after a fresch installation of the SOA SUite on a Windows XP.
                After both the admin server and the SOA Server for the domain started correctly then the huge amount of errors

                <ORA-06553: PLS-306: ....>


                is preventing any work on the dual core PC.


                Who can help ?
                best regards


                ############## traces SOA_server console ###############

                <Dec 16, 2009 10:09:10 AM CET> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to ADMIN>
                <Dec 16, 2009 10:09:10 AM CET> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RESUMING>
                <Dec 16, 2009 10:09:10 AM CET> <Warning> <Server> <BEA-002611> <Hostname "venus", maps to multiple IP addresses: 192.168
                .0.52, 192.168.0.41>
                <Dec 16, 2009 10:09:10 AM CET> <Notice> <Server> <BEA-002613> <Channel "Default[1]" is now listening on 192.168.0.41:800
                1 for protocols iiop, t3, ldap, snmp, http.>
                <Dec 16, 2009 10:09:10 AM CET> <Notice> <Server> <BEA-002613> <Channel "Default" is now listening on 192.168.0.52:8001 f
                or protocols iiop, t3, ldap, snmp, http.>
                <Dec 16, 2009 10:09:10 AM CET> <Notice> <Server> <BEA-002613> <Channel "Default[2]" is now listening on 127.0.0.1:8001 f
                or protocols iiop, t3, ldap, snmp, http.>
                <Dec 16, 2009 10:09:10 AM CET> <Notice> <WebLogicServer> <BEA-000330> <Started WebLogic Managed Server "soa_server1" for
                domain "domain1" running in Production Mode>
                INFO: WLSFabricKernelInitializer$1.handleNotification ......received server running notification. proceeding with compo
                site deployments
                INFO: WLSFabricKernelInitializer$2.run --------->deploying composite model: default/HelloWorldComposite!1.0*53efe7eb-0cc
                6-4fd4-a4c7-72429e842d89
                <Dec 16, 2009 10:09:13 AM CET> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RUNNING>
                <Dec 16, 2009 10:09:13 AM CET> <Notice> <WebLogicServer> <BEA-000360> <Server started in RUNNING mode>
                INFO: SSLSocketFactoryManagerImpl.getKeystoreLocation SOA Keystore location: C:/Oracle/MIDDLE~1/HOME_1~1/USER_P~1/domain
                s/domain1/config/fmwconfig/default-keystore.jks
                INFO: SSLSocketFactoryManagerImpl.getKeystorePassword Obtained null or empty keystore password
                INFO: SSLSocketFactoryManagerImpl.getKeyPassword Obtained null or empty key password
                INFO: SSLSocketFactoryManagerImpl.getSSLSocketFactory SOA-20160
                INFO: DeploymentEventPublisher.invoke Publishing deploy event for default/HelloWorldComposite!1.0*53efe7eb-0cc6-4fd4-a4c
                7-72429e842d89
                INFO: WLSFabricKernelInitializer$2.run -------> Done deploying composites. took 1 seconds.
                Dec 16, 2009 10:09:16 AM oracle.integration.platform.blocks.event.saq.SAQBusinessEventBusMessages errorHandlingMessage
                WARNING: Error handling message (rolling back).
                java.sql.SQLException: ORA-06553: PLS-306: wrong number or types of arguments in call to 'EDN_DEQUEUE_OAOO_DELIVERY'

                at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
                at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
                at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
                at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
                at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)
                at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)
                at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1223)
                at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3386)
                at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3487)
                at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3858)
                at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
                at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:98)
                at oracle.integration.platform.blocks.event.saq.SAQBusinessEventBus.readOAOODelivery(SAQBusinessEventBus.java:12
                22)
                at oracle.integration.platform.blocks.event.saq.SAQBusinessEventBus.handleSingleOAOODelivery(SAQBusinessEventBus
                .java:690)
                at oracle.integration.platform.blocks.event.saq.SAQBusinessEventBus.handleQueueEvents(SAQBusinessEventBus.java:6
                14)
                at oracle.integration.platform.blocks.event.saq.SAQBusinessEventBus.access$000(SAQBusinessEventBus.java:76)
                at oracle.integration.platform.blocks.event.saq.SAQBusinessEventBus$1.run(SAQBusinessEventBus.java:279)
                at oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:77)
                at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:171)
                at java.lang.Thread.run(Thread.java:619)

                ################ traces WebLogic admin server ######################

                starting weblogic with Java version:
                java version "1.6.0_11"
                Java(TM) SE Runtime Environment (build 1.6.0_11-b03)
                Java HotSpot(TM) Client VM (build 11.0-b16, mixed mode)
                Starting WLS with line:
                C:\Oracle\MIDDLE~1\HOME_1~1\JDK160~1\bin\java -client -Xms512m -Xmx512m -XX:PermSize=128m -XX:MaxPermSize=256m -Dweblo
                gic.Name=AdminServer -Djava.security.policy=C:\Oracle\MIDDLE~1\HOME_1~1\WLSERV~1.3\server\lib\weblogic.policy -Xverify:
                none -da -Dplatform.home=C:\Oracle\MIDDLE~1\HOME_1~1\WLSERV~1.3 -Dwls.home=C:\Oracle\MIDDLE~1\HOME_1~1\WLSERV~1.3\serve
                r -Dweblogic.home=C:\Oracle\MIDDLE~1\HOME_1~1\WLSERV~1.3\server -Ddomain.home=C:\Oracle\MIDDLE~1\HOME_1~1\USER_P~1\doma
                ins\domain1 -Doracle.home=C:\Oracle\Middleware\home_11gR1\Oracle_SOA1 -Djrf.version=11.1.1 -Dorg.apache.commons.logging.
                Log=org.apache.commons.logging.impl.Jdk14Logger -Djrockit.optfile=C:\Oracle\Middleware\home_11gR1\Oracle_SOA1\modules\or
                acle.jrf_11.1.1\jrocket_optfile.txt -Doracle.security.jps.config=C:\Oracle\MIDDLE~1\HOME_1~1\USER_P~1\domains\domain1\co
                nfig\fmwconfig\jps-config.xml -Djava.protocol.handler.pkgs=oracle.mds.net.protocol -Dweblogic.alternateTypesDirectory=C
                :\Oracle\Middleware\home_11gR1\Oracle_SOA1\modules\oracle.ossoiap_11.1.1,C:\Oracle\Middleware\home_11gR1\Oracle_SOA1\mod
                ules\oracle.oamprovider_11.1.1 -Dsso.filter.enable=true -Doracle.security.jps.policy.migration.validate.principal=false
                -Dsoa.archives.dir=C:\Oracle\Middleware\home_11gR1\Oracle_SOA1\soa -Dsoa.instance.home=C:\Oracle\MIDDLE~1\HOME_1~1\USE
                R_P~1\domains\domain1 -Dtangosol.coherence.clusteraddress=227.7.7.7 -Dtangosol.coherence.log=jdk -Djavax.xml.soap.Messag
                eFactory=oracle.j2ee.ws.saaj.soap.MessageFactoryImpl -Dcom.sun.management.jmxremote -Djava.protocol.handler.pkgs="oracle
                .mds.net.protocol|oracle.fabric.common.classloaderurl.handler|oracle.fabric.common.uddiurl.handler" -Dweblogic.transacti
                on.blocking.commit=true -Dweblogic.transaction.blocking.rollback=true -Dem.oracle.home=C:\Oracle\Middleware\home_11gR1\O
                racle_SOA1 -Djava.awt.headless=true -Dweblogic.management.discover=true -Dwlw.iterativeDev= -Dwlw.testConsole= -Dwlw.lo
                gErrorsToConsole= -Dweblogic.ext.dirs=C:\Oracle\MIDDLE~1\HOME_1~1\patch_wls1031\profiles\default\sysext_manifest_classpa
                th;C:\Oracle\MIDDLE~1\HOME_1~1\patch_oepe1031\profiles\default\sysext_manifest_classpath weblogic.Server
                <Dec 16, 2009 10:02:02 AM CET> <Info> <WebLogicServer> <BEA-000377> <Starting WebLogic Server with Java HotSpot(TM) Clie
                nt VM Version 11.0-b16 from Sun Microsystems Inc.>
                <Dec 16, 2009 10:02:03 AM CET> <Info> <Management> <BEA-141107> <Version: WebLogic Server 10.3.1.0 Thu Jun 11 00:26:56
                EDT 2009 1227385 >
                <Dec 16, 2009 10:02:07 AM CET> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to STARTING>
                <Dec 16, 2009 10:02:07 AM CET> <Info> <WorkManager> <BEA-002900> <Initializing self-tuning thread pool>
                <Dec 16, 2009 10:02:08 AM CET> <Notice> <Log Management> <BEA-170019> <The server log file C:\Oracle\Middleware\home_11g
                R1\user_projects\domains\domain1\servers\AdminServer\logs\AdminServer.log is opened. All server side log events will be
                written to this file.>
                <Dec 16, 2009 10:02:17 AM CET> <Notice> <Security> <BEA-090082> <Security initializing using security realm myrealm.>
                <Dec 16, 2009 10:02:34 AM CET> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to STANDBY>
                <Dec 16, 2009 10:02:34 AM CET> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to STARTING>
                <Dec 16, 2009 10:02:47 AM CET> <Warning> <J2EE> <BEA-160195> <The application version lifecycle event listener oracle.se
                curity.jps.wls.listeners.JpsAppVersionLifecycleListener is ignored because the application em is not versioned.>
                Dec 16, 2009 10:03:12 AM org.apache.beehive.netui.util.logging.Logger error
                SEVERE: ServletContainerAdapter manager not initialized correctly.
                Dec 16, 2009 10:03:30 AM org.apache.myfaces.trinidadinternal.config.GlobalConfiguratorImpl init
                WARNING: Configurator services already initialized.
                ADF Library non-OC4J post-deployment (millis): 78
                <Dec 16, 2009 10:03:42 AM CET> <Notice> <Log Management> <BEA-170027> <The Server has established connection with the Do
                main level Diagnostic Service successfully.>
                <Dec 16, 2009 10:03:43 AM CET> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to ADMIN>
                <Dec 16, 2009 10:03:43 AM CET> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RESUMING>
                <Dec 16, 2009 10:03:43 AM CET> <Warning> <Server> <BEA-002611> <Hostname "venus", maps to multiple IP addresses: 192.168
                .0.52, 192.168.0.41>
                <Dec 16, 2009 10:03:43 AM CET> <Notice> <Server> <BEA-002613> <Channel "Default[2]" is now listening on 127.0.0.1:7001 f
                or protocols iiop, t3, ldap, snmp, http.>
                <Dec 16, 2009 10:03:43 AM CET> <Notice> <Server> <BEA-002613> <Channel "Default[1]" is now listening on 192.168.0.41:700
                1 for protocols iiop, t3, ldap, snmp, http.>
                <Dec 16, 2009 10:03:43 AM CET> <Notice> <Server> <BEA-002613> <Channel "Default" is now listening on 192.168.0.52:7001 f
                or protocols iiop, t3, ldap, snmp, http.>
                <Dec 16, 2009 10:03:43 AM CET> <Notice> <WebLogicServer> <BEA-000329> <Started WebLogic Admin Server "AdminServer" for d
                omain "domain1" running in Production Mode>
                <Dec 16, 2009 10:03:43 AM CET> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RUNNING>
                <Dec 16, 2009 10:03:43 AM CET> <Notice> <WebLogicServer> <BEA-000360> <Server started in RUNNING mode>
                ###############################################################################################
                • 6. Re: ORA-06553: PLS-306: wrong number or types of arguments in call to 'EDN_DEQU
                  754173
                  Dear,

                  did you manage to find a solution to this problem?

                  I am having the exact same issue, already tried on mutiple platforms, multiple OS
                  (Vista, XP, Server 2003/2008....) alwas the same error message appears which bogs down my pc by
                  claiming 100% of the CPU resources...

                  "ORA-06553: PLS-306: wrong number or types of arguments in call to 'EDN_DEQUEUE_OAOO_DELIVERY'

                  Any useful info would be appreciated.


                  ####<Feb 16, 2010 4:50:20 PM CET> <Warning> <oracle.integration.platform.blocks.event.saq> <hartsoa> <soa_server1> <weblogic.work.j2ee.J2EEWorkManager$WorkWithListener@1383eb7> <<anonymous>> <BEA1-23C446884729B56A0C4D> <> <1266335420781> <SOA-31013> <Error handling message (rolling back).
                  java.sql.SQLException: ORA-06553: PLS-306: wrong number or types of arguments in call to 'EDN_DEQUEUE_OAOO_DELIVERY'

                       at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
                       at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
                       at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
                       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
                       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
                       at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1035)
                       at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)
                       at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)
                       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1223)
                       at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3386)
                       at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3487)
                       at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3858)
                       at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
                       at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:98)
                       at oracle.integration.platform.blocks.event.saq.SAQBusinessEventBus.readOAOODelivery(SAQBusinessEventBus.java:1222)
                       at oracle.integration.platform.blocks.event.saq.SAQBusinessEventBus.handleSingleOAOODelivery(SAQBusinessEventBus.java:690)
                       at oracle.integration.platform.blocks.event.saq.SAQBusinessEventBus.handleQueueEvents(SAQBusinessEventBus.java:614)
                       at oracle.integration.platform.blocks.event.saq.SAQBusinessEventBus.access$000(SAQBusinessEventBus.java:76)
                       at oracle.integration.platform.blocks.event.saq.SAQBusinessEventBus$1.run(SAQBusinessEventBus.java:279)
                       at oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:77)
                       at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:183)
                       at weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:30)