Toad World® Forums

Spool with Comments


Is it possible for spooling with my comments?


dbms_output.put_line ?


I want to spool more than one select statement. Before each select statement i need to give some comment. Is it possible spool with this given comment?



Hi Saravanan,

Unfortunately, SQL Nav doesn’t support spooling with comment. a work around for your problem is using PL/SQL block to print out the comments. The spool window will capture this output hence giving you indications of the statement that you’re executing. It’s a tacky way to solve the problem but right now that’s all i can think of.

Hope this helps