Is there a size limit for output from a stored proc?

[droolydog]

I am executing a stored procedure that creates an output file. My proc runs to completion, however the output file is limited to 32K. Is there a limit in Oracle that i must override or is it more likely a UNIX thing?

 

[carp]

I have generated files up to about 7M with no problem using DBMS_FILE. I suspect this is a limit being imposed by your system.

 

[LokiDba]

Droolydog

Are you creating your output from the stored proc by using DBMS_OUTPUT and doing SPOOL <filename> in SQLPlus. If this is the case it could be the DBMS_OUTPUT buffer size causing your problem. To resolve this before you do any calls to DBMS_OUTPUT call DBMS_OUTPUT.ENABLE( 1000000 ). This will expand the size of the buffer.

Hope this is useful

LokiDBA.