easy ways of debugging the plsql code ??
ArieanJan 23 2011 — edited Jan 26 2011I have a dumb question, i am just curious to know what are the different ways you use to debug a thousands of lines of pl/sql code (procedure/function etc)...it is really scary sometimes going through different variables/code/sytnax/functionality with tight timelines...is it possible for debugging purpose to see the output of the execution like what we use in unix (set -x command)..is there any similar way in Oracle...appreciate your time it really helps me to speed up my learning though i know the basics of Oracle PL/SQL just want to know opinion from peers on how they do,Thank you.