Toad World® Forums

Function Line By Line

I wrote a function and would like to Step through it line by line so I can see how the variables are set with values as it goes through the function.

Is there a way I can do that?

If you are using Oracle you can include dbms_output.put_line in your code. In our output window there is a toggle button to pole for these output lines. Here you can show the contents of vars, etc. If you are using SQL Server or Db2 you will need to go to the point products to use their debuggers.

Debbie