Skip to Main Content

SQL Developer Data Modeler

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Editing view that selects from table with same name via database link gives Java errors

user10440593Feb 10 2020 — edited Mar 23 2020

1. On a new empty design, in the Relational Model, create a new View named "VIEW_1".

2. In the View's Query section, enter "SELECT x FROM VIEW_1@ELSEWHERE" and click OK.

3. Double-click the View, and change the Query to "SELECT x, x FROM VIEW_1@ELSEWHERE" and click OK.

The "Logging Page" now shows "null at oracle.dbtools.crest.model.design.relational.ColumnView.getDataType(ColumnView.java:63)" and the Properties dialog does not close.

Closing the dialog via "X" leads to other new errors.

I believe this is a workaround:

1. Change the query so it selects from VIEW_2@ELSEWHERE instead.

2. Make whatever other changes to the view you want.

3. Rename the view to VIEW_3

4. Change the query back so it selects from VIEW_1@ELSEWHERE

5. Rename the view back to VIEW_1

Oracle Data Modeler Version 19.4.0.350

Comments

Post Details

Added on Feb 10 2020
2 comments
165 views