I am using dbms_scheduler to schedule jobs (Stored Procedure). I would like to see the dbms_output of the stored procedure like the dbms_output of the test window. How can I see this? If you can add an extra tab to the existing layout which already has Arguments, Privileges, Email Notifications, Run Details, Log and Program Output/dbms_output(for Stored Procedure and pl/sql block) that would be great. Is this possible? Is there a work around to see the output? The log window does not help what is actually happening. It is like shooting in the dark.
Any help Marco is appreciated.
Any help Marco is appreciated.