My Oracle Support Banner

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

Last updated on JUNE 11, 2021

Applies to:

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


In JDeveloper, 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.

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"




To view full details, 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 a vibrant support community of peers and Oracle experts.