It is my first to write and debug an Oracle PL/SQL stored procedure
though I was quite experienced in its MS counterpart. It took me some
time to understand how to configure Toad to do this for no one in the
office has tried it.
Here is what I learned from Toad manual,
1. Copy source to Proc Editor window
2. Save it.
3. Compile it.
4. Set breakpoints and/or watches.
5. Go
We can also load stored procedure from Oracle Objects, there is a
toolbar button says "Load source from existing objects" on the second
row (by default) could be used.
And if the stored procedure is located in SYS database which is
unfortunatly my case, we have to enable "Step through SYS/SYSTEM
procs" under the View/Options/Debugging menu item.
No comments:
Post a Comment