Some PL/SQL Definitions (Packages, Procedures, ...) Are Not Diplayed In The Navigator of the Design Editor. (Doc ID 259369.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Designer - Version: 6.5 to 9.0
This problem can occur on any platform.
PL/SQL Definitions (Functions, Packages, Procedures, Cursors, Triggers & Undefined PL/SQL)
'Server Model' tab in the Design Editor (DE)

"Checked for relevance on 11-Sep-2008"

Symptoms

Some PL/SQL definitions (packages, procedures, functions, ...) are not displayed in the navigator of the Design Editor.

This happens on a specific machine. It happens for all users. When the same users work on another machine, all PL/SQL Definitions are displayed in the DE.

The Repository Object Navigator (RON) displays all the PL/SQL definitions.
The same PL/SQL Definitions are visible in the DE, under tab 'DB Admin' (Database Administration), under Nodes 'Oracle Database', 'Users', 'Schema Objects', 'Package Implementations', 'Procedure Implementations', ...

The Design Editor has no Filters defined on the PL/SQL Definitions or one of its sub-nodes.

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