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

    debug

    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;';                     

        • 1. Re: debug
          thatJeffSmith-Oracle

          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
            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

              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

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

                I will go ahead with the method mentioned.