Program fails while doing "Copy to Excel" on a recordset with big CLOB - Allround Automations forums

Register Log In

Forums Products PL/SQL Developer Program fails while doing "Copy to Excel" on a recordset with big CLOB

Print Thread

Program fails while doing "Copy to Excel" on a recordset with big CLOB #65600 04/03/24 05:14 AM
Joined: Apr 2024 Posts: 2 B basf OP Member
OP basf Member B Joined: Apr 2024 Posts: 2	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... Last edited by basf; 04/03/24 05:16 AM.

Re: Program fails while doing "Copy to Excel" on a recordset with big CLOB basf #65601 04/03/24 05:29 AM
Joined: Apr 2024 Posts: 2 B basf OP Member
OP basf Member B Joined: Apr 2024 Posts: 2	Frankly speaking, it appears that PL/SQL Developer 15 fails much more offen than 14's did... not only with Excel. Is there a problem with cathing exceptions?

Re: Program fails while doing "Copy to Excel" on a recordset with big CLOB basf #65604 04/04/24 10:06 AM
Joined: Aug 1999 Posts: 22,206 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,206	I can indeed reproduce the crash when using the "Copy to Excel" function with large CLOB data. We'll fix it! Marco Kalter Allround Automations

Moderated by support

Link Copied to Clipboard

Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.026s Queries: 15 (0.007s) Memory: 2.5024 MB (Peak: 3.0393 MB) Data Comp: Off Server Time: 2024-04-30 03:15:33 UTC
Valid HTML 5 and Valid CSS