Print Thread
Upload large file
#65542 03/20/24 11:47 AM
Joined: Nov 2019
Posts: 7
M
Member
OP Offline
Member
M
Joined: Nov 2019
Posts: 7
How can I upload a large file to a LOB field? I'm trying upload a JSON file with 50Mb (not so large) into a CLOB column, but the large editor frozen trying to show the data. There is any way to upload a file without passing by Large Data Editor window?

Re: Upload large file
MarcielDeg #65562 03/22/24 10:16 AM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
50MB is probably too large for the text editor that is used by default for JSON CLOB's. You can try the following:

1. Query a record with a smaller (or null) value.
2. Click on the cell button to invoke the Large Data Editor.
3. Click on the "External" tab.
4. Enter .json in the "File extension" field.
5. Select an external application to edit the json file.
6. Enable the "Execute automatically next time" option.
7. Press OK.


Marco Kalter
Allround Automations
Re: Upload large file
MarcielDeg #65565 03/22/24 01:14 PM
Joined: Nov 2019
Posts: 7
M
Member
OP Offline
Member
M
Joined: Nov 2019
Posts: 7
I'm trying this solution, but I got the error "ORA-03001: unimplemented feature".

Steps to reproduce:
1. Create an empty table : create table test_clob (XCLOB clob)
2. Create an test insert dml: insert into test_clob values :XCLOB
3. Configure XCLOB variable as your response
4. Execute the update

I tryed the datatypes CLOB and Temporary CLOB, but I got the same problem.

Re: Upload large file
MarcielDeg #65566 03/22/24 01:17 PM
Joined: Nov 2019
Posts: 7
M
Member
OP Offline
Member
M
Joined: Nov 2019
Posts: 7

Re: Upload large file
MarcielDeg #65571 03/25/24 09:59 AM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
I cannot immediately reproduce this ORA-03001 issue. To obtain some more diagnostic information, can you modify the PL/SQL Developer shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer 15\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 15 directory (e.g. C:\Users\<User>\AppData\Roaming\PLSQL Developer 15).


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.071s Queries: 14 (0.022s) Memory: 2.5140 MB (Peak: 3.0393 MB) Data Comp: Off Server Time: 2024-04-27 23:27:44 UTC
Valid HTML 5 and Valid CSS