To debug, a common way is to output the things you care. In oracle, you can use this to output.
DBMS_OUTPUT.PUT_LINE(…)
You may need
Set SERVEROUT ON
In TOAD, you can debug the procedure step by step. Here is one article about it
http://www.quest.com/toad/pdfs/How_to_use_TOAD_PL_SQL_Debugger.pdf
No comments:
Post a Comment