Debugging PL/SQL code in PL/Sql Develper

[Alex_dev]

hello Gurus,

I have a function that returns pipe lined table.
To debug one logical error I want to see step by step execution of the code.
I am quite new to pl/sql . can someone guide me how to achieve this in pl/sql.
I am using pl/sql developer version 7 from allaroundautomations.

Thanks

 

[Marco Kalter]

You will need to create a Test Script (File > New > Test Window) and write a call to this function in the Anonymous PL/SQL Block of the Test Script. Now you can start the debugger from the Test Window Toolbar and step through your code.