UC4 SQL jobs not showing the dbms output values under "Reports" tab

[Anon Anon]

Hi,

I have created a UC4 SQL job and using dbms_output.put_line to print values for debugging purpose.  However the dbms output values are not showing under "Reports" tab after the job execution complete.  However I am able to see the script under "Agent log" tab.  I am facing this issue intermittently, not all the time.  Kindly help me to resolve this issue.

Thanks,
Paddy.

[Anon Anon]

Hi,

I have created a UC4 SQL job and using dbms_output.put_line to print values for debugging purpose.  However the dbms output values are not showing under "Reports" tab after the job execution complete.  However I am able to see the script under "Agent log" tab.  I am facing this issue intermittently, not all the time.  Kindly help me to resolve this issue.

Thanks,
Paddy.

[Pete Wirfs]

I don't know if this would help in your case, but we usually start ours with this instruction;

dbms_output.enable(NULL);

This assures the capture of dbms_output has been enabled with no size limits.  I think if you run into your size limit, it can cause the entire process to fail and get rolled back.

[Anon Anon]

Hi Pete,

Thanks for your reply.  But this is also not working.  is there anything we need to do from UC4 application to increase the size limit?.

Thanks,
Paddy.

[Pete Wirfs]

The maximum allowed is 1,000,000

dbms_output.enable(1000000);

But using "NULL" is better than setting a size limit.  It turns off the size limit.

I have no clue why you are intermittently not getting your dbms_output under the report tab.  It makes no sense.  Maybe it would help to post all of your code so I could look for other problems with it?