1 person found this helpful
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
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.
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;'
vid := calcvalue ('||a||','||p||',||ps);
You can NOT 'step inside' a string.
There IS NO FUNCTION in what you posted. There are ONLY string literals concatenated together.
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
Hi Thanks for mentioning that debug will not step inside string though there is function.
I will go ahead with the method mentioned.