[SOLVED] Where can i see the output of DBMS_OUTPUT.PUT

Where can i see the output of DBMS_OUTPUT.PUT_LINE() in IBM Data Studio?

I am using IBM Data Studio as Development environment,

 CREATE OR REPLACE PROCEDURE TEST()
 is
 BEGIN
  DBMS_OUTPUT.PUT_LINE("Hi there.");
 END;

I can see in execution details like time, exception if any, other info in SQL Results window. Is IBM studio is storing OUTPUT details in some file ? If so than i would like to know location.

How can enable this feature witch can provide this.

Solution

It is not possible to see the output in Data Studio (I think this is more related to how Eclipse deals with stdout). The DBMS_OUTPUT is for console only. As explained in DBMS_OUTPUT, these messages are put in the "message buffer" which at the end of the executing is sent to the standard output.

If you want to write messages like a log, I recommend to use a logger system like log4db2 instead of using DBMS_OUTPUT built-in module.