I have a package with various functions and procs. How do I, using pl / sql developer, to debug? I would like to know how I go about the error and see what is being done.
Using the pl / sql Tests tool I know I can debug. What happens is that the function is inside a package and would like to know how I do it, debugging, seeing the value of the variables and etc.
You can use the command:
ALTER PACKAGE PKG_NOME COMPILE DEBUG;
This will make it possible to debug your package .
Then in SQLWindow right click on your package, and select: " Edig Spec & Body ", then put the break points where you want to test then run your test in a Test Window , as an example:
declare
result boolean;
begin
result := PKG_NOME.F_NOME('PRIMEIROPARAMETRO','SEGUNDOPARAMETRO');
:result := sys.diutil.bool_to_int(result);
end;
In addition to this option in the Edig Spec & Body , go to the second tab and find its function right click and select Test , which will have the same effect .