Skip to Content
0
Former Member
May 27, 2008 at 09:49 AM

Solution to generate output without length limitations ?

29 Views

Hi all,

I would like to know how to generate output without any buffer limitation.

I am currently using the dbms_output package to generate output, but it seems that there is buffer limitation: by default, the maximum length is 1MO. It also appears that there is a command 'SET SERVEROUTPUT ON SIZE UNLIMITED' that disable this limitation.

The problem is that this command does not work in RS: I get an error saying that it expects a number "JCS-00128: integer value expected" although this works in sqlplus (our oracle version supports this command).

I was trying to use the jcs_out too, but I am getting errors I did not have with dbms_output.

Thanks for your help.

Regards,

Yi Jiang