Brief description  about Online courses   join in Online courses
View Rigin  V 's Profile

generate debugging output from PL/SQL

How can we generate debugging output from PL/SQL?
Asked by Rigin V | Jan 25, 2011 |  Reply now
Replies (2)
View Pradeep Krishnarao 's Profile
You can use dbms output and spool commands.
You can try this online at
Aug 30, 2013
View Arun Kumar Das 's Profile
By Useing the DBMS_OUTPUT package. The DBMS_OUTPUT package can be used to show intermediate results from loops and the status of variables as the procedure is executed, however output only occurs after processing is finished, which might not be useful if processing takes a long time. The package UTL_FILE can be used to write to a file, but one must have write access to the output directory. A third possibility is to create a log table and have the procedure write to the table. This will give you debugging information in real time.
Jan 25, 2011