All Forums Database
rtefft 11 posts Joined 03/09
15 Apr 2009
Printing/displaying to screen in Procedure

Is there any way to write to the screen in a Procedure, for troubleshooting purposes? I'm looking for the equivalent of DBMS_OUTPUT.PUT_LINE from Oracle. We'd remove it from production code, but it would be immensely useful for debugging a very large complex ETL procedure we have.Thanks in advance.

Fred 1096 posts Joined 08/04
15 Apr 2009

For external Stored Procedures and User-Defined Functions there is special "trace table" functionality available for debugging. For SQL SPs, you can add regular INSERT statements; GLOBAL TEMPORARY tables are often used.

You must sign in to leave a comment.