Test and Explain SQL option for Custom SQL View Objects Show Empty Panels (Doc ID 2299199.1)

Last updated on AUGUST 21, 2017

Applies to:

Oracle JDeveloper - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

In JDeveloper 12.2.1.0.0, using the "Test and Explain" button for a custom SQL View Object does not show the SQL Statement in the popup window, nor does it execute it.

Steps-to-reproduce
1) In the Model project, locate and open a custom SQL View Object
2) Select the Query tab from the VO Overview
3) Click on the "Test and Explain" button
--> The popup shows two empty panels: "SQL" and "Result"

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms