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

    Debugger Question

    IQ
    IQ Oct 8, 2015 1:36 PM

      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

      • 1299 Views
      • Tags:
        • 1. Re: Debugger Question
          thatJeffSmith-Oracle
          thatJeffSmith-Oracle Oct 8, 2015 1:46 PM (in response to IQ)

          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
            IQ Oct 15, 2015 12:56 PM (in response to thatJeffSmith-Oracle)

            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
              thatJeffSmith-Oracle Oct 15, 2015 1:27 PM (in response to IQ)

              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
                IQ Oct 15, 2015 1:53 PM (in response to thatJeffSmith-Oracle)

                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
                  thatJeffSmith-Oracle Oct 15, 2015 2:21 PM (in response to IQ)

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

                  1 person found this helpful
                  • 6. Re: Debugger Question
                    IQ
                    IQ Oct 15, 2015 3:16 PM (in response to thatJeffSmith-Oracle)

                    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
                      thatJeffSmith-Oracle Oct 15, 2015 5:13 PM (in response to IQ)

                      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
                        IQ Oct 15, 2015 5:29 PM (in response to thatJeffSmith-Oracle)

                        Yes that's correct

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

                        • 9. Re: Debugger Question
                          thatJeffSmith-Oracle
                          thatJeffSmith-Oracle Oct 15, 2015 6:17 PM (in response to IQ)

                          >> 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
                            IQ Oct 15, 2015 6:48 PM (in response to thatJeffSmith-Oracle)

                            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
                              thatJeffSmith-Oracle Oct 15, 2015 6:56 PM (in response to IQ)

                              >>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
                                IQ Oct 15, 2015 7:34 PM (in response to thatJeffSmith-Oracle)


                                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
                                  rp0428 Oct 15, 2015 8:03 PM (in response to IQ)
                                  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
                                    thatJeffSmith-Oracle Oct 15, 2015 9:42 PM (in response to IQ)

                                    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