When I edit the NCLOB data in Table Data Editor and save，ORA-01704: string literal too long error occured!
How can I edit NCLOB data in DataStudio?
You're getting the ORA-01704 because your string literal is more than 4000 bytes, which is the size limit for string literals in SQL calls.
Thank you for your reply! I know this is the problem, because the text to be stored may be very large, which is why NCLOB is used instead of varchar2. Data Studio should provide editing functions for NCLOB data, just as PL/SQL Developer can support CLOB data editing very well. Otherwise, there will be no way to edit more than 40,000-length text in Data Studio, and have to resort to tools like OraLobEditor.
Powered by IDERA