Transfer data more than 32767 to txt file using UTL_FILE
Hi,
I am using the UTL_FILE package to transfer data to a text file. However, UTL_FILE has a limitation of maximum line size not exceeding 32767 bytes. Suppose, I want to put more data into the txt file than 32767 bytes. How do I accomplish that?
I am using the UTL_FILE package to transfer data to a text file. However, UTL_FILE has a limitation of maximum line size not exceeding 32767 bytes. Suppose, I want to put more data into the txt file than 32767 bytes. How do I accomplish that?
The requirement is that I have to send data in the txt file in one single line without splitting it to the next line. I am able to do it but once the data exceeds 32767 bytes, the txt file generated is blank.
Here is my code:
*
CREATE OR REPLACE PROCEDURE WRITE_TXTFLE (p_dir VARCHAR2,p_name VARCHAR2) is
0