1 2 Previous Next 15 Replies Latest reply on Oct 16, 2015 4:04 PM by IQ

    Debugger Question

    IQ

      Hello All,

         I am using SQL Developer(Version 4.1.1.19) to debug my packages. I have added breakpoints in my code but for some reason upon running in Debug mode I cannot seem to see the toolbar at the bottom of the window Debugger log which allows me to step in or step over.

      Any suggestions on how to do this ?

       

      Thanks

      IQ

        • 1. Re: Debugger Question
          thatJeffSmith-Oracle

          what do you see when you start the debugger?

           

          do you get the 'Run' menu items to activate?

           

          have you tried resetting your sqldev desktop layout?

          • 2. Re: Debugger Question
            IQ

            Hi All,

            Sorry for the late response, I was busy with other projects. When I start the debugger I see the bottom pane where it sows the log but I cannot see buttons to step-in, step-out.

            What do you mean by restting sqldev desktop layout ?

             

            Thanks

            IQ

            1 person found this helpful
            • 3. Re: Debugger Question
              thatJeffSmith-Oracle

              window > reset windows to factory

               

               

              you should also see debug actions avail on the debug menu

              1 person found this helpful
              • 4. Re: Debugger Question
                IQ

                I tried factory rest , it does not seem to solve the issue. Also where is the debug menu, how do I go to it ?

                 

                Thanks

                IQ

                • 5. Re: Debugger Question
                  thatJeffSmith-Oracle

                  it's actually the 'Run' menu, between 'Navigate' and 'Source'

                  1 person found this helpful
                  • 6. Re: Debugger Question
                    IQ

                    Hi ,

                      I can see the Step in and Step out buttons in the run menu, however they all r disabled.

                    An important point to be considered here, this package I am debugging is a copy of an existing pacakge which I then modified slightly by adding a new function. I have double checked the grants are the same as the original package.

                    The debug seems to work in he original package but not in the newly created package, What could be the reason for this ?

                     

                    Thanks

                    IQ

                    • 7. Re: Debugger Question
                      thatJeffSmith-Oracle

                      that would have been good to know from the beginning - the debugger isn't initializing for one package but it is for another?

                      • 8. Re: Debugger Question
                        IQ

                        Yes that's correct

                        On Oct 15, 2015 1:14 PM, "community-admin" <

                        • 9. Re: Debugger Question
                          thatJeffSmith-Oracle

                          >> see the bottom pane where it shows the log

                          what's printed there?

                           

                          is your package, spec and body, compiled for debug?

                           

                          is it valid?

                           

                          can you execute your new function?

                           

                          if you drop it and re-create it, does that help?

                          1 person found this helpful
                          • 10. Re: Debugger Question
                            IQ

                            Hi,

                              I have tried droppping and recreating , it did not help, looks like the debugger is unable to stop at the breakpoint for some reason.

                            The package body and package successfully compile without any errors.

                            The contents of the Log look like this

                            --------------------------------------

                            Connecting to the database xyz_Development.

                            Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE

                            Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( xxxxxxx)

                            Debugger accepted connection from database on port xxxxx.

                            Executing PL/SQL: CALL DBMS_DEBUG_JDWP.DISCONNECT()

                            Process exited.

                            Disconnecting from the database xyz_Development.

                            Debugger disconnected from database.

                            ------------------------------------------------------------------

                            • 11. Re: Debugger Question
                              thatJeffSmith-Oracle

                              >>unable to stop at the breakpoint for some reason

                              it it compiled with DEBUG? you should see a little green dot decorator on the package body node in the tree if it is

                               

                              if it is, did you add your breakpoint on an line of code that's actually executable?

                               

                              In preferences, set this: (you should see the debugger start and stop on line 1, where you can then step line by line from there...)

                              debug-step.png

                              • 12. Re: Debugger Question
                                IQ


                                Thanks Jeff for your excellent help, it worked after I made that change in preferences. One last qustion before I close this thread, Can I step into Java code from within SQL Developer while debugging ?

                                 

                                Regards

                                IQ

                                • 13. Re: Debugger Question
                                  One last qustion before I close this thread, Can I step into Java code from within SQL Developer while debugging ?

                                  No - User JDeveloper (or NetBeans, Eclipse, etc) if you are working with Java. JDev has pretty much the same DB functionality as Sql Dev.

                                  • 14. Re: Debugger Question
                                    thatJeffSmith-Oracle

                                    you can step into stored java procedures, but not java outside the database

                                     

                                    you can start in eclipse or netbeans in your java app, and step into a stored prc that's called from your app - that's called external or just-in-time debugging. That's pretty cool.

                                    1 2 Previous Next