Object Browser issue: packages

[aqua]

Hi,

I've faced the following issue:
- I've got a user having a privilege to see all the source of PLSQL objects within another schema.
- Trying to get the list of modules in PLSQL Developer I see nothing.
- I was pretty sure that I must see something. I've tried Oracle SQL Developer. In this tool it worked just fine showing me all the packages and source code for each single one.
- I've decided to trace the statements, which were issued by both tools in order find out the difference:

PLSQL DEVELOPER:
----------------------------------------
SELECT OBJECT_NAME SYNONYM_NAME,
OBJECT_NAME,
OWNER OBJECT_OWNER,
STATUS,
OBJECT_TYPE
FROM SYS.ALL_OBJECTS O
WHERE O.OWNER = :OBJECT_OWNER
AND O.OBJECT_TYPE IN ('PACKAGE')

ORDER BY O.OBJECT_TYPE, O.OBJECT_NAME

ORACLE SQL DEVELOPER:
----------------------------------------
SELECT *
FROM SYS.DBA_SOURCE
WHERE OWNER = :OWNER
AND TYPE = 'PACKAGE'

The problem is that the second statement returns me everything I need, while the first one returns me nothing.

Could you please comment on this?

Kind regards,
Alex.

 

[aqua]

Found an answer.
Preferences > Oracle > Options > Use DBA Views
Sorry for bothering you...