3 Replies Latest reply on Nov 16, 2016 11:31 PM by Gary Graham-Oracle

    Adjust SQLDeveloper default BLOB/CLOB/LOB fetch size.

    dmafackler

      How do I configure SQLDeveloper to fetch more of BLOB/CLOB/LOB fields in the object viewer?

       

      When I double-click on a field, then open the edit data dialog, I am often seeing content truncated to 75 characters, though I know there's more.

       

      SQLDeveloper 4.2.0.16

      RDBMS 11.2.0.4

      ojdbc 12.2.0.1.0

       

       

      Reproducability case

       

      create table eg (f clob);

      insert into eg select '123456789_123456789_123456789_123456789_123456789_123456789_123456789_123456789_' from dual;

       

      Open the table in object view.

       

      Open the edit data view for that field.

      Shows it all this time.

       

      Edit the field via the data view dialog.

      Add an extra character or two.

      Ok.

      Ctrl-S to commit;

       

      Open the field via data view again.

      This time I see only 75 characters.

      Although, if I go to sqlplus and select the content or export the table content, I can see the rest of the clob via those paths.