Wednesday, August 29, 2012

Debug oracle store procedure or function

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