Grid Display for CLOB columns - How do I reset it to default

[pconnelly]

I have a new install of v14 and was working with a query that returned a clob value.
I clicked the three ellipsis and instead of opening the internal Large Data editor it gives me a message
This file does not have an app associated with it for preforming this action. Please install an app, or if one is already installed, create an associations in the Default App Settings page.

How do I reset things so clicking the ellipsis gets the default Large Data editor

 

[Marco Kalter]

You can hold down the Ctrl key when clicking on the [...] button. Now you will get the Large Data Editor, which allows you to remove the association between this column and the external application.

It can also be that the CLOB is recognized as a file type, such as XML or HTML, and that PL/SQL Developer is trying to launch an external viewer. In this case, go to Preferences > User Interface > Options, click on the “DSA Dialogs” button at the bottom, and remove the following lines (if present):

View.XML=n
View.HTML=n

It can also be another format of course.