Displaying procedures and/or packages multiple times in Schema Browser with connections to Oracle 10.2.0.4.
This is an Oracle Bug in the Oracle Patch 6917874:
QUERY ON DBA_TAB_PARTITIONS AND DBA_PART_TABLES RETURNS NO RECORDS IN 10.2.0.4 document-id at metalink 6917874.8, document note 9.5.2008, status: Published.
It is caused by the Sun forte compiler using a specific optimizing parameter for generating the oracle code for 10.2.0.4
The oracle bug number is: #7155655
You can add one or a combination of the following entries in you init.ora file. Different entries or combinations of entries seem to fix the issue on different machines.
As this is an Oracle bug, Quest Software can not provide a solution, revoke the Oracle-patch.
The Project Manager seems to be free from this bug. Import the desired Schema(s) and packages into the Project Manager and work with them from there.
The Problem is reproducible (In the combination SOL10/ORACLE 10.2.0.4 SPARC64).
The Problem is caused by the Oracle Patch :
6917874:QUERY ON DBA_TAB_PARTITIONS AND DBA_PART_TABLES RETURNS NO RECORDS IN 10.2.0.4
document-id at metalink 6917874.8, document note 9.5.2008, status: Published
If installing this patch (independent from the users privileges) you get the issue.
This patch is recommended by oracle: generic/ all most platforms affected
At the moment the patch is available for the following platforms (but if this patch would be available for windows, I would have met the issue as well):
- Linux x86/64
- HP-UX Itanium