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

pconnelly

Member
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
 
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.
 
Thank You, that worked!
Using CTRL key when clicking on the [...] button opened the Large Data editor

Going into DSA Dialogs there was a View.XML=6 line. I removed it and saved the setting.
I went back to the data grid and clicked the [...] and it prompted for an external editor, I clicked no and checked the do not show again box. When I went back and checked DSA Dialogs it has a new line View.XML=7.
 
Last edited:
Back
Top