0 Replies Latest reply on Jul 11, 2018 6:52 AM by Veena

    SPOOL file in SQL*PLUS concurrent program produces empty files after spooling first large file

    Veena

      Hi All,

       

      I have written a concurrent program with sql*plus executable and spooling files in it. This concurrent program is being called multiple times from another concurrent program (plsql procedure) for file creation. I am not facing any issues if data size is less. But when our client ran for wider date ranges and data is huge, only first call of the spool concurrent creates file with huge data. Next calls for Spool concurrent creates empty files. Please provide any ideas how to resolve this, Is there any database level setting needed for this. I dont see any errors in the concurrent program logs.

       

      The first file size created is around 700 MB. And later files are 0 byte files. Is there a file size limit in SPOOL or the path on the application server where files are being written?

       

      Thanks,

      Veena