6 Replies Latest reply on Feb 21, 2011 11:36 AM by 840982

    Not able to run/execute the Stored Procedure from sql developer in Oracle

    840982
      Hi,

      We have installed sql developer ver 1.1.3. as part of Oracle client 11g. We are not able to run/execute the Oracle Stored procedure from the sql developer. Have given the write permission to all the folders.

      We are able to run sql queries, & also compile the stored procedure but unable to run them . When we click the run, nothing happens. Not sure what's wrong here. Can you help us here

      Thanks
        • 1. Re: Not able to run/execute the Stored Procedure from sql developer in Oracle
          Jim Smith
          1.1.3 is very old. You should consider upgrading to 2.1 or even 3.0 which is currently in early access/beta testing.


          Can you describes the steps you are taking to run a procedure?
          How are you trying to run the procedure? Selecting it from the Connection Browser and clicking run?

          If you are trying to run a procedure from a file, I don't think that works in that version?
          • 2. Re: Not able to run/execute the Stored Procedure from sql developer in Orac
            840982
            We are selecting from connection browser & clicking run
            • 3. Re: Not able to run/execute the Stored Procedure from sql developer in Orac
              -K-
              In Windows, if you run from \sqldeveloper\bin\sqldeveloper.exe, do you get any output in the opened console when trying to run? This could help diagnosing the problem.

              K.
              • 4. Re: Not able to run/execute the Stored Procedure from sql developer in Orac
                840982
                This is the message we get in the console when invoking sqldeveloper

                D:\app\master\product\11.1.0\client_1\sqldeveloper\sqldeveloper\bin>sqldeveloper+

                WARNING: Unknown directive: SetSkipJ2SDKCheck*
                Using oracle.home=D:\app\master\product\11.1.0\client_1\sqldeveloper*
                Using ide.user.dir=null*
                Addin: Translator PlSql is trying to register a input type (.plsql) which confli*
                cts with translator PlSql who already using this input type*
                Feb 21, 2011 4:26:56 PM oracle.jdbc.driver.OracleDriver registerMBeans*
                SEVERE: Error while registering Oracle JDBC Diagnosability MBean.*
                javax.management.InstanceAlreadyExistsException: com.oracle.jdbc:type=diagnosabi*
                lity,name=main11.0*
                at com.sun.jmx.mbeanserver.RepositorySupport.addMBean(RepositorySupport.*
                java:452)*
                at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.internal_addObj*
                ect(DefaultMBeanServerInterceptor.java:1410)*
                at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerObject(*
                DefaultMBeanServerInterceptor.java:936)*
                at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(D*
                efaultMBeanServerInterceptor.java:337)*
                at com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(JmxMBeanServer.j*
                ava:497)*
                at oracle.jdbc.driver.OracleDriver.registerMBeans(OracleDriver.java:305)*

                at oracle.jdbc.driver.OracleDriver$1.run(OracleDriver.java:213)*
                at java.security.AccessController.doPrivileged(Native Method)*
                at oracle.jdbc.driver.OracleDriver.<clinit>(OracleDriver.java:209)*
                at oracle.dbtools.raptor.MonitorJDBCAddin.initialize(MonitorJDBCAddin.ja*
                va:27)*
                at oracle.ideimpl.extension.AddinManagerImpl.initializeAddin(AddinManage*
                rImpl.java:433)*
                at oracle.ideimpl.extension.AddinManagerImpl.initializeAddins(AddinManag*
                erImpl.java:244)*
                at oracle.ideimpl.extension.AddinManagerImpl.initProductAndUserAddins(Ad*
                dinManagerImpl.java:157)*
                at oracle.ide.IdeCore.initProductAndUserAddins(IdeCore.java:1517)*
                at oracle.ide.IdeCore.startupImpl(IdeCore.java:1280)*
                at oracle.ide.Ide.startup(Ide.java:642)*
                at oracle.ideimpl.DefaultIdeStarter.startIde(DefaultIdeStarter.java:35)*
                at oracle.ideimpl.Main.start(Main.java:90)*
                at oracle.ideimpl.Main.main(Main.java:51)*
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)*
                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.*
                java:39)*
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces*
                sorImpl.java:25)*
                at java.lang.reflect.Method.invoke(Method.java:585)*
                at oracle.ide.boot.PCLMain.callMain(PCLMain.java:45)*
                at oracle.ide.boot.PCLMain.main(PCLMain.java:37)*
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)*
                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.*
                java:39)*
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces*
                sorImpl.java:25)*
                at java.lang.reflect.Method.invoke(Method.java:585)*
                at oracle.classloader.util.MainClass.invoke(MainClass.java:89)*
                at oracle.ide.boot.IdeLauncher.bootClassLoadersAndMain(IdeLauncher.java:*
                +218)+
                at oracle.ide.boot.IdeLauncher.launchImpl(IdeLauncher.java:90)*
                at oracle.ide.boot.IdeLauncher.launch(IdeLauncher.java:66)*
                at oracle.ide.boot.IdeLauncher.main(IdeLauncher.java:55)*
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)*
                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.*
                java:39)*
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces*
                sorImpl.java:25)*
                at java.lang.reflect.Method.invoke(Method.java:585)*
                at oracle.ide.boot.Launcher.invokeMain(Launcher.java:508)*
                at oracle.ide.boot.Launcher.launchImpl(Launcher.java:106)*
                at oracle.ide.boot.Launcher.launch(Launcher.java:60)*
                at oracle.ide.boot.Launcher.main(Launcher.java:49)*
                • 5. Re: Not able to run/execute the Stored Procedure from sql developer in Orac
                  Jim Smith
                  You can ignore that message.

                  Do you get any additional messages when you try to run a procedure?
                  • 6. Re: Not able to run/execute the Stored Procedure from sql developer in Orac
                    840982
                    This is the message we get while running the procedure

                    Exception while performing action Run File
                    java.lang.NullPointerException
                    at oracle.jdeveloper.runner.JRunProcess.<init>(JRunProcess.java:113)
                    at oracle.jdeveloper.runner.RunningProcess.<init>(RunningProcess.java:49
                    *)*
                    at oracle.jdevimpl.runner.run.JRunner.createRunningProcess(JRunner.java:
                    *654)*
                    at oracle.jdevimpl.runner.run.JRunner.startProcess(JRunner.java:616)
                    at oracle.jdevimpl.runner.run.JRunner.handleEvent(JRunner.java:174)
                    at oracle.ide.controller.IdeAction.performAction(IdeAction.java:551)
                    at oracle.ide.controller.IdeAction$2.run(IdeAction.java:804)
                    at oracle.ide.controller.IdeAction.actionPerformedImpl(IdeAction.java:82
                    *3)*
                    at oracle.ide.controller.IdeAction.actionPerformed(IdeAction.java:521)
                    at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:18
                    *49)*
                    at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.jav
                    a:2169)
                    at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel
                    *.java:420)*
                    at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258
                    *)*
                    at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonL
                    istener.java:236)
                    at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:2
                    *31)*
                    at java.awt.Component.processMouseEvent(Component.java:5501)
                    at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
                    at java.awt.Component.processEvent(Component.java:5266)
                    at java.awt.Container.processEvent(Container.java:1966)
                    at java.awt.Component.dispatchEventImpl(Component.java:3968)
                    at java.awt.Container.dispatchEventImpl(Container.java:2024)
                    at java.awt.Component.dispatchEvent(Component.java:3803)
                    at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212
                    *)*
                    at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)

                    at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
                    at java.awt.Container.dispatchEventImpl(Container.java:2010)
                    at java.awt.Window.dispatchEventImpl(Window.java:1778)
                    at java.awt.Component.dispatchEvent(Component.java:3803)
                    at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
                    at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
                    read.java:242)
                    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
                    ad.java:163)
                    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)

                    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)

                    at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
                    reloadBuffers(): 7 nodes checked in 2.80366E-4 second(s)
                    fireIdeActivated(): oracle.ide.IdeMainWindow$NodeReloader 38613ms