4 Replies Latest reply on Jan 22, 2016 8:16 AM by 2939120

    debug

    2939120
    2939120 Jan 20, 2016 10:19 AM

      Hi, if i try to debug the following in oracle sql developer 3.0, it is not stepping in to the function declared inside string.

      Is this right way to do, if yes, please help me how to step into function inside string during debug.

       

      v_str := 'declare vid number;'

                   ||'begin                     

                   vid := calcvalue ('||a||','||p||',||ps);

                  end;';                     

      • 929 Views
      • Tags:
        • 1. Re: debug
          thatJeffSmith-Oracle
          thatJeffSmith-Oracle Jan 20, 2016 12:47 PM (in response to 2939120)

          open calcvalue() in the procedure editor, from the database nav tree

           

          hit the 'bug' button

           

          in the anon block window that pops up, manipulate the code there to do what you're doing instead

           

          hit OK

           

          you should be debugging at that point - be sure to compile calcvalue with debug info first if you want to use breakpoints and watches

           

          Also, v3.0 is quite old. I'd recommend upgrading to version 4.1.2 if you get a chance.

          1 person found this helpful
          • 2. Re: debug
            rp0428 Jan 20, 2016 4:42 PM (in response to 2939120)
            Hi, if i try to debug the following in oracle sql developer 3.0, it is not stepping in to the function declared inside string.

            Is this right way to do, if yes, please help me how to step into function inside string during debug.

             

            v_str := 'declare vid number;'

                         ||'begin                    

                         vid := calcvalue ('||a||','||p||',||ps);

                        end;';                     

            You can NOT 'step inside' a string.

             

            There IS NO FUNCTION in what you posted. There are ONLY string literals concatenated together.

            • 3. Re: debug
              thatJeffSmith-Oracle
              thatJeffSmith-Oracle Jan 20, 2016 5:10 PM (in response to rp0428)

              ha, yeah, i only saw the vid:= line, good catch

               

              if you want to debug calcvalue, write an anon block that calls it and use it in the debugger interface

              • 4. Re: debug
                2939120
                2939120 Jan 22, 2016 8:16 AM (in response to thatJeffSmith-Oracle)

                Hi Thanks for mentioning that debug will not step inside string though there is function.

                I will go ahead with the method mentioned.