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!

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
167 views