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?
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.
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.
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).