3 Replies Latest reply on May 13, 2015 3:50 AM by aJohny

    fnd_file.put_line (fnd_file.output --size limit

    Dhanya-Oracle

      Hi All,


      When trying to  place a CLOB variable in the out put file of the concurrent program using below,

       

      fnd_file.put_line (fnd_file.output, clob_genrate_xml);

       

      It is giving an error MAIN EXCEPTION of create shipment XMLORA-06502: PL/SQL: numeric or value error.

       

      What is the limitation to store the data on the output file (View Output) of the concurrent program.


      The size of clob_generate_xml is more than 32767 byes and it is failing to show it on the output file if the file size exceeds 32767 bytes.


      Kindly advise if there is any size limit for output file or fnd_file.put_line procedure.


      Regards,

      Dhanya