Skip to Main Content
Forums

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query results pane is disabled or can not access results

User_EKWC5Jan 17 2020 — edited Jan 24 2020

Hi, i have been facing this issue quite longer now.

I am using SQL developer, when i run my SQL its displays the results correctly in Query Results window, but when i want to copy something from Query Results, or want to do right click on the Query Results to do export and all, its just seems like disabled.

It does not highlight any cell on clicking on Query results pane or does not display Context Menu on Right clicking on Query Results etc. I cant even click on Column Headers to sort the results.

Clicking on anywhere else or right click anywhere else works perfectly fine. Even i can copy contents of Script output pane, but the issue is only with Query Results.

I faced this issue with SQL Developer Version 3.2.09, Build MAIN-09.30, also with V18 as well.

Is there any way i can make it enabled or is it a BUG. Not sure it got disable by mistake by me.

I have already tried installing uninstalling SQL developer version, but no luck.

Can somebody help?
This post has been answered by Glen Conway on Jan 20 2020
Jump to Answer

Comments

John JB Brock-Oracle

What version of JET are you working with?
This looks like you may have the script module hardcoded to main.js in your index.html file, and we change that name to bundle.js when using --release. In the more recent versions of the JET Starter templates, injector tags are using in the index.html to update the requirejs main module name at build time.

  <!-- This injects script tags for the main javascript files -->
  <!-- injector:scripts -->
  <!-- endinjector -->
renangi

Ojet 9.2 migrated to Ojet 11

Look in your applications index.html for the lines that I provided above. If they don't exist and/or there are hardcoded strings for the require.js and main entries, add/replace with what I shared above.

renangi

<!-- This is the main css file for the default theme -->
<!-- injector:theme -->
<link rel="stylesheet" href="css/libs/oj/v9.2.0/redwood/oj-redwood-min.css" type="text/css" />
<!-- endinjector -->
i have above code in my index.html,

That is not the same injectors that I posted about. Those are the theme injectors at the top of the file. Look at the bottom of your index.html file as I posted early.

1 - 5

Post Details

Added on Jan 17 2020
9 comments
4,609 views