My Oracle Support Banner

While Extending View Object, the Step "Building Columns in SQL Query" Never Ends (Doc ID 2983077.1)

Last updated on OCTOBER 25, 2023

Applies to:

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

Symptoms

While using JDeveloper 12.2.1.4.0 to create a VO by extending an existing one, the wizard gets stuck in a step with the message "Building columns in SQL Query" and never ends.

Steps:

Issue happens even with simple queries.
Connection to the same DB and execution of those queries from the same JDeveloper works normally. This is an Oracle 19c database.

Changes

 

Cause

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.