Program fails while doing "Copy to Excel" on a recordset with big CLOB - 04/03/24 05:14 AM
Hello!
I regurlarily use my SQL-script with CLOB output (of different length) and save result to Exsel by choosing the "Copy to Excel" function in the result set context menu.
If I have very long CLOB (>32767 chars), in PL/SQL Developer 14.0.6.1998 (32 bit) I got the error and can fix the query and go on, but in the newer versions (15.0.2.2054 32 bit, 15.0.4.2064 64 bit) PL/SQL Developer just fails and closes itself.
Can you fix it, please? Catch this exception and give the error as before, or (ideally) reformat the output and split the huge string in two+ cells/rows...
I regurlarily use my SQL-script with CLOB output (of different length) and save result to Exsel by choosing the "Copy to Excel" function in the result set context menu.
If I have very long CLOB (>32767 chars), in PL/SQL Developer 14.0.6.1998 (32 bit) I got the error and can fix the query and go on, but in the newer versions (15.0.2.2054 32 bit, 15.0.4.2064 64 bit) PL/SQL Developer just fails and closes itself.
Can you fix it, please? Catch this exception and give the error as before, or (ideally) reformat the output and split the huge string in two+ cells/rows...